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
11. A subtype discriminator is which of the following?
- An attribute of the supertype whose values determine the subtype
- An attribute of the subtype whose values determine the supertype
- An attribute of the supertype whose values determine the supertype
- An attribute of the subtype whose values determine the subtype
12. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
- Disjoint with total specialization
- Disjoint with partial specialization
- Overlap with total specialization
- Overlap with partial specialization
13. A subtype entity name should be which of the following?
- A singular noun
- Specific to the organization
- Concise
- All of the above
14. Use of a supertype/subtype relationship is necessary when which of the following exists?
- An instance of a subtype participates in a relationship that is unique to that subtype
- An instance of a subtype participates in a relationship that is the same as the other subtypes.
- Attributes apply to all of the instances of an entity type.
- No attributes apply to any of the instances of an entity type.
15. Which of the following is not one of the three ways to classify an action assertion?
- Condition
- Integrity Control
- Authorization
- Enabler