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 realtionshipe in your ERD. Manager AVS Management System Maintain Video Collection Process Overdue Video Rentals Search Video Collection Rent Videos Actor Compliance Customer department Return Videos Case name: Primary actor: Brief Description: Maintain video collection Manager Prior to a video being made available to rent, it must be cataloged and entered the video database. Stakeholders Trigger: Normal Flow of events: Optional optional If new video is cataloged and entered in the database, then placed on shelf. If used video is checked for damage and if no damage is found it is cataloged and places on the shelf. Damaged video handling If video is deemed damaged, manger will remove video from the database, and access charges to customer account. Subflows: Alternate/ Exception flow: Use case name: Primary actor: Brief Description: Stakeholders Trigger Normal Flow of events: Process overdue video rentals Manger If a video is overdue, a fee is accessed to the customer account Customer Exceeds rental return date of 3 days in the system Once a video is rented, a return date of 3 days is given to each video that is associated with a customer account. A fee will be applied each day that the video rental is outstanding after the return date has passed and until the video has been categorized into the database. Two or more days overdue - call customer After Two or more days of a video being overdue, the manger will call the customer to remind them to return the video Subflows: Alternate/ Exception flow: Use case name Search video collection Subflows: Alternate/ Exception flow that the video rental is outstanding after the return date has passed and until the video has been categorized into the database. Two or more days overdue-call customer After Two or more days of a video being overdue, the manger will call the customer to remind them to return the video. Use case name: Primary Actor Brief Description: Stakeholders: Triggers: Normal Flow of events: Search video collection Customer A customer seeking to rent a video will search the video collection of AVS store Optional Optional Customer will search through cataloged videos that are on the shelf of AVs to select a video for rental. Subflows: Optional Video damage fee Customer infomation Manager Damaged video Information 1 Maintain AVS Customer card Video descriptive Video video Overdue damaged Information inventory xidee fee Supplier Maintain sustom Overdue damaged New video Video removed Video fee payment information from stock Fee Video D1 Customs Overdue payment -record vidas Overdue videos Video fee information D2 Customers D Rentals Rented video Returned video Customer data 3 Overdue sideo Maintain Overdue fee assessment video rental data Overdue video notice AVS Curd Video to retur Video to rent Customer