Chapter 7, Problem 42E

Explanation of Solution

Normalization of the schema to 4NF:

• It is the normalization level next to Boyce-Codd Normal Form (BCNF).
• Given schema,

books(accessionno, isbn, title, author, publisher)

users(userid, name, deptid, deptname)

• The constraints given in the question are,

accessionno → isbn

isbn → title

isbn → publisher

isbn →→ author

userid → name

userid → deptid

deptid → deptname

• Second Normal Form (2NF): If the schema does not contain any functional dependencies, then it is said to be in second Normal Form.
  • The conversion of the given  normal  to 2NF is a s follows,
  • Consider the functional dependencies,

isbn → title

isbn → publisher

isbn →→ author

• For the above functional dependencies,
  • The relational schema “books(accessionno, isbn, title, author, publisher)” is converted to “books(isbn, title, author, publisher)” and books(accessionno, isbn)...