Database - ER Model and Business Rules
Database - 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.