ER MODEL AND BUSINESS RULES QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Attributes are assigned at the highest logical level.

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

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

Attributes are assigned at the lowest logical level.

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype can only have only one subtype.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Action assertions have traditionally been implemented within an application program.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following statements concerning business rules is true?

It may include restrictions.

It should not be convertible to computer code.

It should be complex.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Attribute

Relationship

Entity

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

A supertype/subtype hierarchy is which of the following?

Each supertype has only one subtype.

Each supertype has only one attribute.

Each subtype has only one attribute.

Each subtype has only one supertype.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Diamond

Circle

Oval

Rectangle

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?