Data Modeling with ER Model Questions and Answers
Data Modeling with ER Model forms the core of any database design process and frequently appears in DBMS aptitude questions and answers during exams and interviews. The Entity-Relationship (ER) model defines data objects, their relationships, and constraints, helping designers create efficient database schemas. For students preparing for Infosys, Cognizant, and TCS NQT, understanding ER diagrams, cardinality, and relationship mapping is crucial. Practicing aptitude questions with solutions PDF on ER models ensures clarity on database conceptual design. Mastering this concept allows candidates to analyze business requirements and translate them into accurate and logical database structures.
Learn entity-relationship model for database design. Supplement with database design and data models into database designs
Data Modeling with ER Model
11. An attribute that names or identifies entity instances is a(n):
- entity.
- attribute.
- identifier.
- relationship.
12. Properties that describe the characteristics of entities are called:
- entities
- attributes.
- identifiers.
- relationships.
13. In which of the following can many entity instances of one type be related to many entity instances of another type?
- One-to-One Relationship
- One-to-Many Relationship
- Many-to-Many Relationship
- Composite Relationship
14. Entities of a given type are grouped into a(n):
- database.
- entity class.
- attribute.
- ERD.
15. Which of the following is NOT a basic element of all versions of the E-R model?
- Entities
- Attributes
- Relationships
- Primary keys
16. In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
- One-to-One Relationship
- One-to-Many Relationship
- Many-to-Many Relationship
- Composite Relationship
17. Entities can be associated with one another in which of the following?
- Entities
- Attributes
- Identifiers
- Relationships
18. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
- Supertype entity
- Subtype entity
- Archetype entity
- Instance entity
19. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
- Supertype entity
- Subtype entity
- Archetype entity
- Instance entity
20. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
- parent
- child
- instance
- subtype