Given the following relation schema and its functional dependencies:
(a) Specify candidate keys and state the primary key.
(b) Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalising the relation schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your schemas.
(a) Candidate keys: (A, F), (A, D)
Primary key: (A, F)
(b) fd2 violates 2NF definition. Decompose.
You might also like to view...
Which of the following functions is best suited to replace the word "Doctor" with "Dr." in a text string?
A) SUBSTITUTE B) TRIM C) LEFT D) CONCATENATE
In order to apply a style to a particular section of a document, use the ________ element
A) area B) section C) div D) paragraph