Answered step by step
Verified Expert Solution
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:
SubscriptionContractsContractID 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 XY You should not mention any Trivial dependencies.
Marks
b Suggest the best possible PK for this table. Justify your selection with explanation. We do not want to decompose the table.
Mark
c Which functional dependencies are redundant? Justify your answer.
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