1. Write the MySQL statements. For the given MovieCo ERD below, write MySQL statements: MEMBERSHIP PK...

Transcribed Image Text:

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. 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.

Answer rating: 100% (QA)

Based on the provided ERD Ill write the MySQL statement... View the full answer