##### Find the correct statements.

- Prime attribute transitively determined by superkey is allowed by 3NF
- Non-Prime attribute transitively determined by superkey is allowed by 3NF
- Every partial dependency is transitive dependency
- Candidate key is only determined by functional dependencies, not by MVDs

(a)1,2 and 4 only (b) 1,3 and 4 only (c) 1,2 and 3 only (d) All of these

a

And what's the reason?

is b is answer?

if i am right

Ya, b is the answer.

// SK ->non PRIME ATTRIBUTE

non PRIME ATTRIBUTE -> PRIME ATTRIBUTE

(allowed in 3NF since LHS is SK and RHS is prime attribute)

SK -> PRIME ATTRIBUTE // allowed in 3nf

PRIME ATTRIBUTE -> Non-Prime attribute //not allowed in 3nf since neither lhs is SK nor RHS is prime attribute

// since if fd is not in 2nf , then it is surely not in 3nf also.

// true since MVDs can be determined when we are provided with tuples set, and given fd we can determine CK

So, ans is b

Thank you, @shivani for such a detailed answer.