This assignment require you to apply the Data Modeling concept and skill learned from Chapter 6 to build an ERD based on the previous AVS case (A Video Store) from your Assignment 2 & 3.

Turn in an ERD with appropriate relationship sentences. You can use drawing tools in MS Word or MS Visio to create your ERD. Make sure your relationship sentences are consistent with your relationship in your ERD.

 

Video damage fee Customer infomation Damaged video Information Manager * AVS Customer card Overdue damasd video fee Overdue damaged Video fee paymant Maintain Video Supplier Video descriptive Information video inventory Maintain sustomer data New video Video removed information from stock Fee Overdue video fe Video D1 Customer -record payment Video information Overdue videos D2 Customers Rentals Customer data Rented 3. Overdue video xideo Maintain Overdue fee assessmant Returned video video rental data Overdue videonotice AVS Card Customer Video to retum Video to rent