4NF is designed to cope with____?

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

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

STUDENTHOBBYLANGUAGE
1CricketEnglish
1PaintingUrdu
2CricketHindi
2PaintingEnglish

Solution

STUDENTHOBBY
1Cricket
1Painting
2Singing

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

STUDENTLANGUAGE
1English
1Urdu
2Hindi

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.

SPECIALIZATION CODESPECIALIZATION NAMECOURSE CODECOURSE NAME
1ComputingA1BATABASE
2DevelopmentA2C++
3ComputingA3OPERATING SYSTEM
4DevelopmentA4OOP

 

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

 

COURSE CODECOURSE NAME
A1BATABASE
A2C++

 


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?

Employee nameskillCurrent work location
ElizabethGraphic designerGermany
ElizabethDatabaseGermany
ElizabethHand writingGermany
EvaTyping speedUnited States
RobertFluent in EnglishUnited States
RobertLeadershipUnited States
HaroonTyping speedUnited States

After 2NF

Employee nameCurrent work location
ElizabethGermany
EvaUnited States
RobertUnited States
HaroonUnited States
Employee nameskill
ElizabethGraphic designer
ElizabethDatabase
ElizabethHand writing
EvaTyping speed
RobertFluent in English
RobertLeadership
HaroonTyping speed

 


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.

Roll No NameMarks
1Robert77
2Basit90
3Elizabeth44
2Basit70

After removing the repeating groups;

Roll NoNameMarks
1Robert77
2Basit90
3Elizabeth44

 

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)