Practice ER Model And Business Rules Multiple Choice Questions with Answers Quiz-2

Q.1.

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.

Q.2.

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.

Q.3.

Which of the following statements concerning business rules is true?

Q.4.

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 level.
Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
Attributes are assigned at the lowest logical level.

Q.5.

Which of the following is not one of the three ways to classify an action assertion?