Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started