Find the correct statements.
  1. Prime attribute transitively determined by superkey is allowed by 3NF
  2. Non-Prime attribute transitively determined by superkey is allowed by 3NF
  3. Every partial dependency is transitive dependency
  4. 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

6Comments
set2018 @setgate
14 Oct 2017 02:14 pm

a

Sukannya @sukannyapurkaya
14 Oct 2017 05:51 pm

And what's the reason?

Pun m @punm
15 Oct 2017 12:46 am

is b is answer?

if i am right 

  1. Prime attribute transitively determined by superkey is allowed by 3NF  true
  2. false
  3. true                                                                       https://www.quora.com/What-is-the-difference-between-partial-and-transit...
  4. true as we know cd required fd only 
Sukannya @sukannyapurkaya
15 Oct 2017 09:08 pm

Ya, b is the answer.

shivani @shivani1234
15 Oct 2017 07:46 pm
  1. Prime attribute transitively determined by superkey is allowed by 3NF
    // SK ->non PRIME ATTRIBUTE
    non PRIME ATTRIBUTE -> PRIME ATTRIBUTE
    (allowed in 3NF since LHS is SK and RHS is prime attribute)
  2. Non-Prime attribute transitively determined by superkey is allowed by 3NF
    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
  3. Every partial dependency is transitive dependency
    // since if fd is not in 2nf , then it is surely not in 3nf also.
  4. Candidate key is only determined by functional dependencies, not by MVDs
    // true since MVDs can be determined when we are provided with tuples set, and given fd we can determine CK
    So, ans is b
Sukannya @sukannyapurkaya
15 Oct 2017 09:07 pm

Thank you, @shivani for such a detailed answer.