Third normal form is based on the concept of ______?

By: Prof. Dr. Fazal Rehman Shamil | Last updated: February 3, 2024

[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 CODESPECIALIZATION NAMECOURSE CODECOURSE NAME
1ComputingA1DIGITAL LOGIC DESIGN
2DevelopmentA2DATA WAREHOUSE
3ComputingA3OPERATING SYSTEM
4DevelopmentA4OOP

 

SPECIALIZATION CODESPECIALIZATION NAMECOURSE CODE
1ComputingA1
2DevelopmentA2
3ComputingA3
4DevelopmentA4

 

COURSE CODECOURSE NAME
A1DIGITAL LOGIC DESIGN
A2DATA 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

STUDENTHOBBYLANGUAGE
1HockeyEnglish
1PaintingGerman
2HockeyHindi
2PaintingEnglish

Solution

STUDENTHOBBY
1Hockey
1Painting
2Singing

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

STUDENTLANGUAGE
1English
1German
2Hindi

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 nameskillCurrent work location
JohnGraphic designerGermany
JohnDatabaseGermany
JohnShort Hand SpeedGermany
EvaTyping speedCanada
RobertFluent in EnglishCanada
RobertPoetryCanada
HaroonTyping speedCanada

After 2NF

Employee nameCurrent work location
JohnGermany
EvaCanada
RobertCanada
HaroonCanada
Employee nameskill
JohnGraphic designer
JohnDatabase
JohnShort Hand Speed
EvaTyping speed
RobertFluent in English
RobertPoetry
HaroonTyping 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 NameMarks
1Robert33
2John90
3Shehla44
2John70

After removing the repeating groups;

Roll NoNameMarks
1Robert33
2John90
3Shehla44

 

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)