a. Write the proper sequence of activities in the design of a video rental datab
ID: 3699644 • Letter: A
Question
a. Write the proper sequence of activities in the design of a video rental database. The initial ERD is shown in 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.
This is the link to figure 9.9 as discussed above I put together. https://imgur.com/UiRjfIG no copy please.
Explanation / Answer
Its level of detail and (relative) complexity,
this problem would make an excellent class project. Use thechapter’s coverage of the database life cycle (DBLC) as the procedural template.
The text’s Figure 9.3 isparticularly useful as a procedural map for this problem’s solution and Figure 9.6 provides a more detailed viewof the database design’s procedural flow.
Make sure that the students review section 9.4.2, “Database Design,”before they attempt to produce the problem solution.Appendix B, “The University Lab: Conceptual Design,” and Appendix C “The University Lab: ConceptualDesign Verification,
Logical Design, and Implementation” show a very detailed example of the proceduresrequired to deliver a completed database.
You will find a more detailed video rental database problemdescription in Appendix B, problem 4.
This problem requires the completion of the initial database design.
Thesolution is shown in this manual’s Appendix B coverage
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.