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.

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

  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)

 

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.