Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Database Analytics

Authors: Andrew D. Banasiewicz

1st Edition

0415657881, 978-0415657884

Students also viewed these Databases questions