ERD of Movie Rental Business

1. You want to have a movie rental business.

2. You have several thousand movie titles in a variety of media formatCDs, DVDs, Blu-rays, videotapes, etc.

3. In your inventory, some of the titles have multiple copies possibly in different formats such as VHS, DVD or Blu-ray.

4. A customer can rent multiple movies at any visit.

5. Rental fees can be different per title (Star Wars 7 fee is higher than Star Wars 4) as well as per media type (e.g. blu-ray fee is higher than DVD) and can be changed over time.

6. You want to keep track of rental history per Genre, Release Year, and Media Type. You also want to keep track of customer information.

(7) You have decided to develop a database for your business. As a first step, develop a ERD for your business. For that, you will need to do the followings.

a)

Identify entities, entity attributes and entity relationships.

b)

Optionally, to help your understanding, sketch tables (with sample instances) for

the identified entities.

c)

Use an online tool to draw your ERD.