Given the basic ER and relational models, which of the following is INCORRECT?
20122023
Given the basic ER and relational models, which of the following is INCORRECT?
- A.
An attribute of an entity can have more than one value
- B.
An attribute of an entity can be composite
- C.
In a row of a relational table, an attribute can have more than one value
- D.
In a row of a relational table, an attribute can have exactly one value or a NULL value
Attempted by 1861 students.
Show answer & explanation
Correct answer: C
Correct choice (the incorrect statement): In a row of a relational table, an attribute can have more than one value
Why this is incorrect:
The basic relational model (and First Normal Form) requires each attribute in a tuple to hold a single (atomic) value or NULL.
The ER model does allow multivalued and composite attributes; when mapping an ER schema to relations you must convert multivalued attributes into separate relations or columns.
Typical representation: if an entity has multiple phone numbers, create a separate relation such as Phone(student_id, phone_number) so each row stores one atomic phone_number value.
Takeaway: The statement claiming that a relational table attribute can hold more than one value contradicts the atomic-value requirement of the basic relational model, so that statement is incorrect.
A video solution is available for this question — log in and enroll to watch it.