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

QEmpdt1(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 relation in

ID: #2601 Normal Form MCQ 39,901 views
Question Info
#2601Q 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 1 NF only ✔ ✖
  • B 2 NF and hence also in 1 NF ✔ ✖
  • C 3NF and hence also in 2NF and 1NF ✔ ✖
  • D BCNF and hence also in 3NF, 2NF and 1NF ✔ ✖
Correct Answer

Explanation

The relation in second normal form is also in first normal form and no partial dependencies on any column in primary key.
 Continue Practice
Previous Question No Next
 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):... 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______... Which forms are based on the concept of functional dependency:... In the __________ normal form, a composite attribute is converted to individual attributes.... Which-one ofthe following statements about normal forms is FALSE?...