Relational Database Design -The Fourth Normal Form and the Fifth Normal Form (4NF and 5NF)

To understand the basics of relational database design and functional dependencies watch the following videos:

To learn about decomposition and the First Normal Form, watch the following video:

To learn about the Second Normal Form (2NF), watch the following video:

To learn about the Third Normal Form (3NF) and the Boyce Codd Normal Form (BCNF), watch the following video:

Review Questions:
1. Does a relation have to be in BCNF in order to be in 4NF?
2. When can you say that a relation is in 4NF?
3. What is a multi-valued dependency?
4. What is the difference between a multi-valued dependency and a functional dependency?
5. When can you say that a relation is in 5NF?
6. What is a join dependency?
7. Give an example of a join dependency.