Consider the following relation for published books: BOOK [Title, Author-name, T

Question

Consider the following relation for published books:

      BOOK [Title, Author-name, Type, List-price, Category, Author-affil, Publisher]

Author-affil refers to the affiliation of author. Suppose the following functional dependencies are derived from the business rules of this application domain:

      Title ? Type, List-price, Publisher

      Type ? Category

      Author-name ? Author-affil

1.    What normal form is this relation in? Explain your answer

2. Apply normalization until you cannot decompose the relation further. State the reasons of each decomposition. (Draw the relational forms chart)

Explanation / Answer

1.BOOK relation is in 1NF

2NF violations

Title ? Type, List-price, Publisher

      Type ? Category

      Author-name ? Author-affil

Reason: they denote partial functional dependence on simply a part of the primary key.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.