Question: Given the set of functional dependencies F {fd1, fd2, fd3, fd4, fd5, fd6, fd7, fd8, fd9, fd10} where: a. Construct the universal relation schema that

Given the set of functional dependencies F {fd1, fd2, fd3, fd4, fd5, fd6, fd7, fd8, fd9, fd10} where:

Given the set of functional dependencies F {fd1, fd2, fd3,

a. Construct the universal relation schema that includes (i.e., preserves) the set of functional dependencies in F.
b. Do the functional dependencies shown constitute a minimal cover of F? If not, derive a minimal cover.
c. Derive the candidate key(s) of F.
d. Select the primary key and justify your choice.
e. Considering your primary key and candidate key(s), distinguish between (1) key versus non-key attributes and (2) prime versus non-prime attributes.

fd2: Job Salary fdi: Tenant#-> {Name, Job, Phone#, Address) fd3 : Name Gender fdS: {Name, Phone#} (Tenant. Deposit) fd7: Area Rent, County fd9: {Lot, County)-) {Survey, Area | fd4: Phone#-) Address | fd6: County-) Tax-rate fds. Survey#-) Lot fd10: {Survey#. Area)-) County

Step by Step Solution

3.39 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Key attribute Nonkey attribute Nonkey attribute Nonkey attribute Nonkey attribute Name Phone Address ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

887-CS-DB (2172).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!