a. Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in above (or refer to textbook figure 9.9). The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers.

b. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. Make sure that the design is normalized properly and that it can support the required transactions.

c. Implement solution using Microsoft Access. Be sure to populate the database with proper data to insure its data integrity.

 

RENTAL CUSTOMER VIDEO PK FK VIDEO_ID CUST NUM PK PK VIDEO_ID PK FK CUST NUM CUST LNAME CUST FNAME CUST INITIAL CUST E MAIL VIDEO CLASS VIDEO TITLE RENTAL OUT VIDEO_CHG RENTAL RETURN Figure 9.9 as described