Microsoft
98-364 · Question #123
98-364 Question #123: Real Exam Question with Answer & Explanation
The correct answer is B. It violates 2NF.. See the full explanation below for the reasoning.
Question
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?
Options
- AIt violates 4NF.
- BIt violates 2NF.
- CIt violates 1NF.
- DThere is no violation.
Community Discussion
No community discussion yet for this question.