Write the SQL code to create the table structures for the entities shown in Figure P7.65. The structures should contain the attributes specified in the ERD. Use data types that would be appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the ERD.

Transcribed Image Text:

DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 RENT NUM PK,FK2VID NUM PK MEM NUM PK RENT NUM MEM FNAME MEM LNAME MEM STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE DETAIL FEE DETAIL DUEDATE DETAIL RETURNDATE DETAIL DAILYLATEFEE RENT DATE FK1 MEM NUM MOVIE VIDEO PK MOVIE NUM PK VID NUM PRICE MOVIE TITLE MOVIE YEAR MOVIE COST VID INDATE FK1 MOVIE NUM PK PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE MOVIE GENRE FK1 PRICE CODE