[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.
SPECIALIZATION CODE | SPECIALIZATION NAME | COURSE CODE | COURSE NAME |
1 | Computing | A1 | DIGITAL LOGIC DESIGN |
2 | Development | A2 | DATA WAREHOUSE |
3 | Computing | A3 | OPERATING SYSTEM |
4 | Development | A4 | OOP |
SPECIALIZATION CODE | SPECIALIZATION NAME | COURSE CODE |
1 | Computing | A1 |
2 | Development | A2 |
3 | Computing | A3 |
4 | Development | A4 |
COURSE CODE | COURSE NAME |
A1 | DIGITAL LOGIC DESIGN |
A2 | DATA WAREHOUSE |
[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
STUDENT | HOBBY | LANGUAGE |
1 | Hockey | English |
1 | Painting | German |
2 | Hockey | Hindi |
2 | Painting | English |
Solution
STUDENT | HOBBY |
1 | Hockey |
1 | Painting |
2 | Singing |
Table 1: Hobby table with just one multi-valued dependency
STUDENT | LANGUAGE |
1 | English |
1 | German |
2 | Hindi |
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?
Employee name | skill | Current work location |
John | Graphic designer | Germany |
John | Database | Germany |
John | Short Hand Speed | Germany |
Eva | Typing speed | Canada |
Robert | Fluent in English | Canada |
Robert | Poetry | Canada |
Haroon | Typing speed | Canada |
After 2NF
Employee name | Current work location | |
John | Germany | |
Eva | Canada | |
Robert | Canada | |
Haroon | Canada | |
Employee name | skill | |
John | Graphic designer | |
John | Database | |
John | Short Hand Speed | |
Eva | Typing speed | |
Robert | Fluent in English | |
Robert | Poetry | |
Haroon | Typing speed | |
[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.
Roll No | Name | Marks |
1 | Robert | 33 |
2 | John | 90 |
3 | Shehla | 44 |
2 | John | 70 |
After removing the repeating groups;
Roll No | Name | Marks |
1 | Robert | 33 |
2 | John | 90 |
3 | Shehla | 44 |
Read Tutorials about Normalization in DBMS
- First Normal form in DBMS
- Second normal form Examples in DBMS
- Third normal form
- Boyce-Codd Normal Form (3.5 NF)
- Fourth Normal Form
- Fifth Normal Form (5NF)