Which of the following features is supported in the relational database model?
2019
Which of the following features is supported in the relational database model?
- A.
Complex data-types
- B.
Multivalued attributes
- C.
Associations with multiplicities
- D.
Generalization relationships
Attempted by 1373 students.
Show answer & explanation
Correct answer: C
Correct Answer is Associations with multiplicities
In the relational database model, data is organized into tables (relations) where each row is unique and each column contains atomic values. Among the choices provided, Associations with multiplicities is the only supported feature because the model is designed specifically to link different entities through Primary Keys and Foreign Keys. These keys allow the database to define how many records in one table relate to records in another, effectively managing one-to-one, one-to-many, and many-to-many relationships.
Conversely, features like multivalued attributes and complex data types are excluded to maintain First Normal Form (1NF), which ensures data remains simple and searchable. Generalization is a characteristic of Object-Oriented or Extended Entity-Relationship (EER) models rather than the standard relational model itself.
A video solution is available for this question — log in and enroll to watch it.