ER MODEL AND BUSINESS RULES QUIZ

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

Diamond

Oval

Rectangle

Circle

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an EER?

Entity

Optional One

Relationship

Attribute

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity cluster is a set of one or more entity types and associated relationships.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

An oval represents which of the following in an EER?

Entity

Relationship

Optional One

Attribute

TRUE ANSWER : ?
YOUR ANSWER : ?

Generalization is the process of defining more general entity types from a set of more specialized entity types.

False

True

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

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.

No attributes apply to any of the instances of an entity type.

Attributes apply to all of the instances of an entity type.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑