Linda works as a Database Designer for Lion Inc.
She has been given an assignment to design the database of a publishing company.
The database has a table named Author, which has a composite key, AuthorID and TitleID. Royalty and LiteraryAgent are the other attributes.
The functional dependencies are such that AuthorID + TitleID-> Royalty (i.e. Royalty is functionally dependent on AuthorID and TitleID) and AuthorID-> LiteraryAgent (i.e. LiteraryAgent is functionally dependent on AuthorID).
Which of the following is true about this table?
A. It violates 4 NF.
B. It violates 2 NF.
C. It violates 1 NF.
D. There is no violation.
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
 |
