8.10

Redesign the database of Exercise 8.4 into first normal form and fourth normal form. List any functional and multivalued dependencies that you assume. Also list all referential-integrity constraints that should be present in the first and fourth normal form schemas.


Emp = (emp_id, ename)
Children = (child_id, name, birthday)
EmpChild = (emp_id, child_id)

Skills = (type)
Exams = (year, city)
SkillExams = (type,year, city)

SkillExamsEmp = (emp_id,type,year, city)