ERD Video Rental with Access File

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

Note Course Project deliverables are as follows:

1. For items a and b, use a Microsoft Word.  For the      diagrams, use Visio then copy/paste to the Word document. That is, items a      and b will be submitted using Word.
2. When completing your course database design project you      will submit one Word document containing parts a and b and your completed      Access database file.
3. Prior to submission, compress the Word document and      your Access database prior to submission—submit one single compressed      file.

Note Course Project deliverables are as follows:

1. For items a and b, use a Microsoft Word.  For the      diagrams, use Visio then copy/paste to the Word document. That is, items a      and b will be submitted using Word.
2. When completing your course database design project you      will submit one Word document containing parts a and b and your completed      Access database file.
3. Prior to submission, compress the Word document and      your Access database prior to submission—submit one single compressed      file.