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 : ?

A supertype/subtype hierarchy is which of the following?

Each subtype has only one attribute.

Each supertype has only one attribute.

Each supertype has only one subtype.

Each subtype has only one supertype.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following statements concerning business rules is true?

All of these

It should not be convertible to computer code.

It may include restrictions.

It should be complex.

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 : ?

A subtype entity name should be which of the following?

Concise

Specific to the organization

A singular noun

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Attribute

Optional One

Relationship

Entity

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.

Attributes are assigned at the highest logical level.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Integrity Control

Enabler

Authorization

Condition

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Entity

Relationship

Attribute

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?