Chapter 8, Problem 10E

Explanation of Solution

Consider the database schema with a relation Emp given in Exercise 8.4.

Redesigning the database into first normal form:

• A relation schema is said to be in First Normal Form (1NF) when the domains of all attributes in the schema are atomic.
• Thus, all the attributes of given schema need to be flattened into a single relation schema to make it into 1NF.
• So, the schema is as follows:

Emp_details= (ename, name, birthday, type, year, city)

• The functional dependencies and multi-level dependencies are as follows:
  • ename, name -> birthday
    • A child has a unique birth date.
  • Ename -> name, birthday
    • An employee cannot have two children of the same name.
  • ename, type -> year, city
    • No relationship exists between the children of an employee and his skill set details...