Question

Draw an entity relationship diagram for each of the following applications.

1. A video rental store wants to keep track of information about the movies it has in stock, the store's customers, and the movies those customers have rented. Also the actors in those movies.
The information it wants to keep is as follows:
• Each movie has a title, year of release, running time, and name of studio which made the movie. There can be several different movies in the store having the same title but made in different years (such as remakes or perhaps by coincidence). A movie can be assigned to one or more genres such as comedy, science fiction, drama, action, etc. Also each movie will have a unique ID
• Each actor has a name, birthdate, gender, and hometown (city and state). An actor may appear in several movies but we assume the actor will play at most one role in in any movie. The role name and description will be kept in the movie database.
• We will assume the store carries one copy of each video (for this problem).
• A customer must register before renting any movie. The store keeps track of the first and last names, address, phone number and registration number of each customer.
• The store keeps track of every movie ever rented by each customer. For each rental, the store records the rental date and the return date (which is NULL if the video is still being rented).
2. Develop the schemas for problem 1.

Answer 1

To create an entity relationship diagram for the video rental store application, you would need to include entities such as Movie, Genre, Studio, Actor, Customer, and Rental, and define their relationships and attributes.

Step-by-step explanation:

The entity relationship diagram for the video rental store application would include the following entities: Movie, Genre, Studio, Actor, Customer, and Rental.

The relationships between these entities would be as follows:

• Each Movie can have multiple Genres.
• Each Movie is associated with a Studio.
• Each Actor can appear in multiple Movies.
• Each Customer can make multiple Rentals.
• Each Rental is associated with a Movie and a Customer.

The attributes for each entity would be as follows:

• Movie: Title, Year of Release, Running Time, and Studio ID.
• Genre: Genre Name.
• Studio: Studio Name.
• Actor: Actor Name, Birthdate, Gender, and Hometown.
• Customer: First Name, Last Name, Address, Phone Number, and Registration Number.
• Rental: Rental Date, Return Date, Movie ID, and Customer ID.