In Chapter 9, you learned to write the proper sequence of activities when designing a database. In this final project you will:
Design a Video Rental Database (The initial ERD was shown in your textbook in figure 9.7. Chapter 9). The design must support all the rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customer.
1. Writing the design activity sequence (Chapter 9).
Figure 9.4 and Problem 1a (pg. 392) are examples of this.
2. CONCEPTUAL DESIGN
After you finish writing the design activity sequence (Chapter 9), complete the ERD in VISIO (Chapters 5, 6 & 9) to ensure that the database design can be successfully implemented. (Make sure the design is normalized properly and can support the required transactions.)
3. PHYSICAL DESIGN
Write the script in notepad that contains the SQL code to create your design (Chapter 7 & 9). Run the script in the database of your choice.
Submit in Blackboard
1. Design Activity Sequence in WORD or VISIO.
2. Final ERD in VISIO format
3. Table creation and insert statements in notepad script.
4. Saved copy of your results from Oracle or MS SQL.
I HAVE NO IDEA HOW TO DO THIS PROJECT. THE BOOK IS:
DATABSE FUNDAMENTALS (SEVENTH EDITION). I NEED HELP. CAN SOMEONE HELP ME AND TELL ME WHAT TO DO BECAUSE I DON’T GET IT. THIS PROJECT IS WASTING MY TIME, BECAUSE I DON’T UNDERSTAND "WHERE DO I START?"