Given the set of functional dependencies F {fd1, fd2, fd3, fd4, fd5, fd6, fd7, fd8, fd9, f10,

Question:

Given the set of functional dependencies F {fd1, fd2, fd3, fd4, fd5, fd6, fd7, fd8, fd9, f10, f11} where:
Given the set of functional dependencies F {fd1, fd2, fd3,
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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Data Modeling and Database Design

ISBN: 978-1285085258

2nd edition

Authors: Narayan S. Umanath, Richard W. Scammel

Question Posted: