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: https://youtu.be/xqIm-Y3oVDk
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.