ER MODEL AND BUSINESS RULES QUIZ

An action assertion is a statement that expresses some aspect of the static structure of the organization.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Total specialization is represented by double lines between the supertype and subtype on an EER.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Relationship

Attribute

Optional One

Entity

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Relationship

Entity

Attribute

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following statements concerning business rules is true?

It should not be convertible to computer code.

All of these

It may include restrictions.

It should be complex.

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator of the supertype is an attribute whose values determine the target subtype(s).

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the subtype whose values determine the supertype

An attribute of the supertype whose values determine the supertype

An attribute of the supertype whose values determine the subtype

An attribute of the subtype whose values determine the subtype

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype/subtype hierarchy has which of the following features?

Attributes are assigned at the lowest logical level.

Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.

Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.

Attributes are assigned at the highest logical level.

TRUE ANSWER : ?
YOUR ANSWER : ?