ER MODEL AND BUSINESS RULES QUIZ

It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which one of the following symbols is not used in an ERD?

Oval

Rectangle

Diamond

Circle

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An ERD that has had the entities clustered will display more entities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype discriminator is which of the following?

An attribute of the supertype whose values determine the supertype

An attribute of the subtype whose values determine the supertype

An attribute of the subtype whose values determine the subtype

An attribute of the supertype whose values determine the subtype

TRUE ANSWER : ?
YOUR ANSWER : ?

Packaged data models are meant to be exactly right straight out of the box.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An action assertion must include which of the following?

Anchor object

All of these

Corresponding object

Action

TRUE ANSWER : ?
YOUR ANSWER : ?

A subtype entity name should be which of the following?

Specific to the organization

Concise

All of these

A singular noun

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑