Question: II Data Modeling with ERD The video store database keeps track of customers who borrow movie DVDs in the stores. Given the following business requirements,

 II Data Modeling with ERD The video store database keeps track

II Data Modeling with ERD The video store database keeps track of customers who borrow movie DVDs in the stores. Given the following business requirements, identify entity types, attributes and relationships, and then draw an ER diagram. The following business rules are given. One DVD must record only one copy of a movie One movie may be recorded on one or more DVDs One DVD must be rented by one and only one customer. One customer may be the renter of one or more DVDs One movie may have the feature of one or more actors. 1. Identify entity types and relationship types. Fill out the following relationship matrix. 2. Draw an ER diagram with 1) entity types, 2) relationship types, 3) keys, and 4) cardinality ratio

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!