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 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.

Transcribed Image Text:

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