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:
.png)
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
Key attribute Nonkey attribute Nonkey attribute Nonkey attribute Nonkey attribute Name Phone Address ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
887-CS-DB (2172).docx
120 KBs Word File
