ER Model and Business Rules Questions and Answers
ER Model and Business Rules questions with answers are crucial for understanding the foundation of database design. The Entity-Relationship model visually represents data and its relationships, forming the blueprint for logical and physical database design. This set of aptitude questions and answers with explanations focuses on entities, attributes, relationships, and business constraints. Perfect for candidates preparing for TCS, Infosys, and Tech Mahindra exams, these ER model questions provide both conceptual clarity and practice. Students can download ER Model and Business Rules aptitude questions with solutions PDF to strengthen their DBMS aptitude and perform confidently in placement interviews.
Questions on entity-relationship models in databases. See database design using normalization and data modeling with ER model
ER Model and Business Rules
1. An action assertion must include which of the following?
- Anchor object
- Action
- Corresponding object
- All of the above.
2. An oval represents which of the following in an EER?
- Attribute
- Entity
- Optional One
- Relationship
3. Inheritance is which of the following?
- When a supertype entity inherits values of the subtype attribute
- When a subtype entity inherits values of the supertype attribute
- When a supertype entity inherits values of another supertype attribute
- When a subtype entity inherits values of another subtype attribute
4. When an entity instance must be a member of only one subtype, it is which of the following?
- Disjoint with total specialization
- Disjoint with partial specialization
- Overlap with total specialization
- Overlap with partial specialization
5. A supertype/subtype hierarchy is which of the following?
- Each subtype has only one attribute.
- Each supertype has only one attribute.
- Each subtype has only one supertype.
- Each supertype has only one subtype.
6. A rectangle represents which of the following in an EER?
- A rectangle represents which of the following in an EER?
- A rectangle represents which of the following in an EER?
- Entity
- Optional One
7. Which one of the following symbols is not used in an ERD?
- Rectangle
- Oval
- Diamond
- Circle
8. Specialization is which of the following processes?
- Defining one or more subtypes of the supertype and forming supertype/subtype relationships.
- Defining one or more supertypes of the subtype and forming supertype/subtype relationships.
- Defining one or more subtypes of the supertype and not forming supertype/subtype relationships.
- Defining one or more supertypes of the subtype and not forming supertype/subtype relationships.
9. Which of the following statements concerning business rules is true?
- It should be complex.
- It should not be convertible to computer code.
- It may include restrictions.
- All of the above.
10. A supertype/subtype hierarchy has which of the following features?
- Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- Attributes are assigned at the highest logical leve
- Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- Attributes are assigned at the lowest logical level.