Relations produced from an E-R model are always in ________.
2018
Relations produced from an E-R model are always in ________.
- A.
1 NF
- B.
2 NF
- C.
3 NF
- D.
4 NF
Attempted by 765 students.
Show answer & explanation
Correct answer: A
Answer: 1NF
Relations produced from an E-R model are always in First Normal Form (1NF).
Reason:
In the relational model, each table attribute must contain atomic values. During ER-to-relational mapping, composite attributes are broken into simple attributes and multivalued attributes are usually represented in separate relations. This ensures the resulting relations satisfy 1NF.
However, higher normal forms such as 2NF, 3NF, BCNF, and 4NF depend on additional functional or multivalued dependencies. They are not guaranteed just because the relations were produced from an E-R model.
Therefore, the correct answer is 1NF.
A video solution is available for this question — log in and enroll to watch it.