4NF is designed to cope with____?

4NF is designed to cope with :
(a). Multi-valued dependency
(b). Join dependency
(c). Transitive dependency
(d). None of these
Answer: Multi-valued dependency

---

What is Multi-valued dependency?

A multivalued dependency consists of at least two attributes that are dependent on a third attribute that’s why it always requires at least three attributes.

Exercise:

“The table is with more than one multi-valued dependency”. Solve the problem to ensure 4th normal form

Solution

Table 1: Hobby table with just one multi-valued dependency

Table 2: Language table with just one multi-valued dependency

---

3NF is designed to cope with :
(a). Multi-valued dependency
(b). Join dependency
(c). Transitive dependency
(d). None of these
Answer: Transitive dependency

What is Transitive dependency?

Transitive dependency means that a non-prime attribute A( other than the candidate key) depends on another non-prime attribute B and that B is entirely dependent on the candidate key.

 

 

 

---

2NF is designed to cope with :
(a). Multi-valued dependency
(b). Partial Functional Dependency
(c). Transitive dependency
(d). None of these
Answer: Partial Functional Dependency

What is Partial Functional Dependency?

After 2NF

 

---

1NF is designed to cope with :
(a). Multi-valued dependency
(b). Partial Functional Dependency
(c). Transitive dependency
(d). Repeating groups
Answer: Repeating groups

What is a Repeating group?

A repeating group is a group of two or more rows/records for an instance of an entity.

After removing the repeating groups;

 

Read Tutorials about Normalization in DBMS

1. First Normal form in DBMS
2. Second normal form Examples in DBMS
3. Third normal form
4. Boyce-Codd Normal Form (3.5 NF)
5. Fourth Normal Form
6. Fifth Normal Form (5NF)