Third normal form is based on the concept of ______?

[Solved] The third normal form is based on the concept of _____?

(A). Normal Dependency
(B). Closure Dependency
(C). Full Functional Dependency
(D). Removing Transitive Dependency

Answer: Removing 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.

 

 

 

---

[Solved] The fourth normal form (4NF) is based on the concept of _____?

(A). Normal Dependency
(B). Closure Dependency
(C). Full Functional Dependency
(D). Removing More than one multi-valued dependencies

Answer: Removing More than one multi-valued dependencies

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

 

---

[Solved] The second normal form (2NF) is based on the concept of _____?

(A). Normal Dependency
(B). Closure Dependency
(C). Removing partial Functional Dependency
(D). Removing More than one multi-valued dependencies

Removing partial Functional Dependency

What is Partial Functional Dependency?

After 2NF

 

 

---

[Solved] The first normal form (1NF) is based on the concept of _____?

(A). Removing repeating groups
(B). Closure Dependency
(C). Removing partial Functional Dependency
(D). Removing More than one multi-valued dependencies

Answer:  Removing 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)