to create a ER Diagram about moview rental. A small database is needed to track online Movie Rentals and other Movie related information. Here is the information that is known.

 

 

This is an In Class Practice Assignment. You have the option of attempting the assignment outside of
class. However, it is strongly recommended that you participate in the in class activity to get a better
understanding of the data modeling process. Database Assignment: Movie Rentals
The requirements for this Assignments is as follows. A small database is needed to track online Movie
Rentals and other Movie related information. Here is the information that is known. Customers rent Videos from the client. The Client keeps information on each Customer; name,
phone number, email, and total purchases. Each Video has a name or title, the year that it was released, The cost to rent the Video, and the
Genre of the Video Customers rent Videos from the client. A Customer may rent multiple Videos in any single video
rental transaction. When a Customer rents videos, the client records the date that the
customers makes a video rental transaction, the movies that were rented. There are Video Details for each video rented in every Video Rental Transaction. Each Rental
Detail contains a rental fee, due date, date returned, a price code, and a daily late fee The price code of the video references information on the pricing of the video. There is a code
for a standard rental fee, a new release fee, a discount fee, and a weekly special fee for the
video based on the price code. The daily late fee can also be accessed through this code There are actors that perform in movies. An actor has a name and a date of birth. An actor may
perform in one or more movies. A movie may have one or more actors performing in it. 1.
2.
3.
4. Create an ER Diagram for this scenario using Microsoft Visio
Place your name as a textbox in the Microsoft Visio Document
Save your document as a Microsoft Visio Document
Save your Microsoft Visio Document as a PDF document Assignment Submission Guidelines
• Submit both of your ER Diagrams, one in a MS Visio format and the other in a PDF Format. Submit
both documents as a single submission

Attachments:

• 1493796078-Database Assignment_Movie Rentals 1.pdf