# 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

## 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

## 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