Computer Science and Engineering › Normal Form MCQ › Question #2600
Single Choice Not Set

QWhich forms are based on the concept of functional dependency:

ID: #2600 Normal Form MCQ 15,102 views
Question Info
#2600Q ID
Not SetDifficulty
Normal Form MCQTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A 1NF ✔ ✖
  • B 2NF ✔ ✖
  • C 3NF ✔ ✖
  • D 4NF ✔ ✖
Correct Answer

Explanation

The table is in 3NF if every non-prime attribute of R is non-transitively dependent (i.e. directly dependent) on every superkey of R.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Tables in second normal form (2NF):... Empdt1(empcode, name, street, city, state,pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a rel... A table on the many side of a one to many or many to many relationship must:... Which is a bottom-up approach to database design that design by examining the relationship between attributes:... Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:... Which forms has a relation that possesses data about an individual entity:... Functional Dependencies are the types of constraints that are based on______... In the __________ normal form, a composite attribute is converted to individual attributes.... Which-one ofthe following statements about normal forms is FALSE?...