In the Week 3: Reading "SQL Queries for EliteVideo" - Chapter 8, go to 8-9e Cases in the Chapter Review section at the end of the module and review the EliteVideo case from the perspective of a database administrator assigned to build this database. Select one of the entities shown in the ERD for the EliteVideo database in Figure P8.47 (reproduced below). What data types would you use for the attributes in this entity? How would you code a CREATE TABLE statement to implement this entity as a table in the database?

Figure P8.47

Figure P8.47 The CHOS_MOVIECO ERD MEMBERSHIP DETAILRENTAL RENTAL PK MEM NUM PK,FK1 RENT NUM PK,FK2 VID NUM MEM_FNAME -H--OF PK RENT NUM DETAIL_FEE MEM_LNAME RENT DATE MEM_STREET FK1 MEM_NUM DETAIL_DUEDATE MEM_CITY DETAIL_RETURNDATE MEM_STATE DETAIL_DAILYLATEFEE MEM_ZIP MEM_BALANCE MOVIE VIDEO PRICE PK MOVIE NUM -H-OF PK VID NUM PK PRICE CODE MOVIE_TITLE VID_INDATE MOVIE_YEAR FK1 MOVIE_NUM PRICE_DESCRIPTION MOVIE_COST PRICE_RENTFEE MOVIE GENRE PRICE_DAILYLATEFEE FK1 PRICE_CODE