Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relational model for NetFlix: SubscriptionContracts ( ContractID , CustomerID, ServiceAddress, ServiceType, StartDate ) Below are the business rules: Every customer is assigned

Consider the following relational model for NetFlix:
SubscriptionContracts(ContractID, CustomerID, ServiceAddress, ServiceType, StartDate)
Below are the business rules:
Every customer is assigned a unique CustomerID which is the email address that customer uses for registration.
A customer can have multiple subscriptions.
Each subscription is assigned a unique ContractID.
A customer is allowed to have multiple subscriptions for the same ServiceAddress.
A customer is allowed to have only one ServiceAddress.
Each subscription can have one of the two ServiceType: "Rental" or "Periodical".
StartDate is only valid for "Periodical"; in case of "Rental", this field is null. In case of "Periodical", it is the date on which the subscription was purchased.
StartDate is only valid for "Periodical"; in case of "Rental", this field is null. In case of "Periodical", it is the date on which the subscription was purchased.
Now answer following problems:
a. Identify all possible direct (not transitive) Functional Dependencies in this model. You must answer in the form X->Y. You should not mention any Trivial dependencies.
[2 Marks]
b. Suggest the best possible PK for this table. Justify your selection with explanation. We do not want to decompose the table.
[1 Mark]
c. Which functional dependencies are redundant? Justify your answer.
[2 Marks]
image text in transcribed

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_2

Step: 3

blur-text-image_3

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

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

=+f. Does it promise a benefit or solve a problem?

Answered: 1 week ago

Question

=+ Who do you think is right? Why?

Answered: 1 week ago