For this question, you will be required to create an Entity Relationship Diagram. To create this diagram, lwoulcl recommend using lucid.app. Ii'ou may paste a copy of your 580 in the space below or attach a separate PDFfile to the individual Assignment #2 DropBox. Case Information: Your firned has come to you and asked you to design a simple database to help her with her new business. Her business is a new video rental business. She has provided you with the following information: 1. Each time a new movie is released, her company will purchase several copies ofthe movie, in VHS and DVD video format, for rental to customers. 2. In order to rent a movie, customers have to become members first. They must provide information such as a credit card number, the address (address, city, province, country, postal code] and a contact phone number. 3. When a copy of a movie is rented, the customer's details are recorded. At the same time, the date the movie went out and the date it is expected back (to the store] is recorded. The amount charged for the rental is also recorded. What she wants to achieve, among other things, are to: 1. Identify the availability of a particular movie title, i.e. if all copies are out on rental. If not, how many copies are available for each video format. 2. Determine the revenue generated from a particular movie title. Reguired: Construct an ER diagram for the lMicl'eo Rental System, please make sure your ERD includes the following: - The required entities - ldnetifying attribute{s) for each entity - Attributed for each entity - Relationships between the entities ** if you have anyr assumptions, please state them