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:
- 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.
- When completing your course database design project you will submit one Word document containing parts a and b and your completed Access database file.
- 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:
- 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.
- When completing your course database design project you will submit one Word document containing parts a and b and your completed Access database file.
- Prior to submission, compress the Word document and your Access database prior to submission—submit one single compressed file.
