aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DBMS Fundamentals and Data Modeling
  • If every non-key attribute is functionally dependent on t...
Multiple choice

If every non-key attribute is functionally dependent on the primary key, the relation will be in

  1. 1NF

  2. 2NF

  3. 3NF

  4. 4NF

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A relation is in 3NF if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key. If only the primary key determines non-key attributes, it satisfies the condition for 3NF.

Keep practicing — related questions

  • Which of the following normal forms is depicted when a relation where primary key contains multiple attribu...
  • _____________ is a condition in a relation where an attribute is functionally dependent on another non-key ...
  • The condition where one attribute is functionally dependent on another non-key attribute of the same relati...
  • Set F of functional dependencies for relation schema R(A, B, C, D, E) is A$\rightarrow$BC, CD$\rightarrow$E...
  • Which of the following forms of normalisation states that non-key attributes are functionally dependent on ...
  • P : Foreign key cannot have a null value. Q : Primary key and foreign key can exist in same relation. R : F...
  • There is no distinction between ‘Sovereign functions’ and ‘Non-Sovereign functions’ of State in regard to l...
  • Which of the following functions is not directly related to a file?
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy