Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE
1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE PRICE PK PRICE CODE -H--O PRICE_DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE PK Your answer: RENTAL RENT NUM RENT_DATE FK1 MEM_NUM a) List all details about all members. Your answer: HO----X #H MOVIE PK MOVIE NUM MOVIE_TITLE MOVIE YEAR MOVIE_COST MOVIE_GENRE FK1 PRICE_CODE DETAILRENTAL PK,FK1 RENT NUM PK,FK2 VID NUM H-O DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE PK VIDEO VID NUM VID_INDATE FK1 MOVIE_NUM b) List all details about price ordered by rent fee in ascending order. Hints: Use the ORDER BY clause with PRICE_RENTFEE.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Based on the provided ERD Ill write the MySQL statement...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started