Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Netflix is planning to start a new video rental service. In this service: Clients will be identified by their email IDs. For each client:
1. Netflix is planning to start a new video rental service. In this service: Clients will be identified by their email IDs. For each client: Name, Address, and Postal Code will also be stored Each Client can optionally have multiple payment modes stored in the system. For each payment mode: Card Number and Expiry Date will be stored. The videos, called Titles, will have Name, Rating, Price and Duration stored in the system. A Client can rent one or more Titles, also the same Title again and again. Whenever a Client rents a Title, the Date, Rent Start Time and Duration (in hours) of the rent is stored in the system. Also, when a Client rents the same Title again, a discount on Price is offered to the Client. If a Client rents the same Title multiple times, then these rentals can not overlap with each other in terms of time. For example, if John has rented God Father I on Feb. 9, 2021 at 8 PM for 5 hours then he can not rent this Title for a period which overlaps with the period (Feb. 9, 2021 8 PM to Feb. 10, 2021 at 1 AM). Draw the ER diagram for this business scenario. Try to use the same names as used in the description above. For each relationship type, you must mention the cardinality and participation. [30 Marks]
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