**Correct Answer : A,B,D.** $\color{red}{\text{ }}$

Partial Dependency, Transitive Dependency, 2NF, 3NF etc. are the concepts which are **Wrongly Understood** by majority of students.

Consider the following two GATE Questions:

https://gateoverflow.in/1260/gate-cse-2007-question-62-ugcnet-june2014-ii-47

https://gateoverflow.in/84054/gate-cse-1990-question-3-ii

For these two GATE questions, $\color{brown}{\text{Find Video Solution Below:}}$

**Detailed Video Solution of GATE CSE 1990, 2007 Questions**

For **Correct Concepts of Normalization**, Refer Standard Resources Or Watch the playlist below.

**Normalization Complete Course Playlist**

$\color{red}{\text{Misconception 1:}}$ A Relation in 3NF cannot have Transitive Dependency.

The above statement is FALSE.

(If this statement is True then in the following GATE question, Option $C$ would also be False. : https://gateoverflow.in/1260/Gate-cse-2007-question-62-ugcnet-june2014-ii-47)

$\color{green}{\text{Correct Concept 1:}}$ A Relation in 3NF may still have Transitive Dependency, but a relation in 3NF can Never have Transitive Dependencies where some Candidate Key is transitively determining some non-prime attribute.

$\color{blue}{\text{Third Normal Form :}}$

The relation must be in 2NF and Every non-prime attribute of the relation is non-transitively dependent on Each candidate key of the relation.

Restated, a relation $R$ is in Third Normal Form if it is in 2NF and NO non-key attribute of R is transitively dependent on any candidate key of $R$.

https://youtube.com/playlist?list=PLIPZ2_p3RNHhJjQGnZB2jORa0JxLdMp4X

After Watching the above playlist, solve the following GATE Question:

https://gateoverflow.in/1260/Gate-cse-2007-question-62-ugcnet-june2014-ii-47

In this GATE 2007 Question, Option C is True because in a relation in 3NF, we can have Transitive Dependency where Some Prime Attribute is Transitively Dependent on a candidate key.

$\color{red}{\text{Misconception 2:}}$ A Relation in 2NF cannot have Partial Dependency.

$\color{green}{\text{Correct Concept 2:}}$ A Relation in 2NF may still have Partial Dependency, but a relation in 2NF can Never have a Dependency where some Candidate Key is partially determining some non-prime attribute.

Watch this playlist for Correct Understanding of Concepts, and correct your misconceptions:

Normalization Complete Course Playlist - Learn Correct Concepts

https://bohr.wlu.ca/cp363/notes/theory/18_3nf.php

Codd’s Original Research Paper for Normal Forms :

https://forum.thethirdmanifesto.com/wp-content/uploads/asgarosforum/987737/00-efc-further-normalization.pdf

Refer Standard Books : Korth OR Navathe. Or watch Goclasses DBMS Course.