MODELING DATA IN THE ORGANIZATION QUIZ

A fact is a word or phrase that has a specific meaning for the business.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A ternary relationship involves how many entities?

3

3 or less

More than 3

3 or more

TRUE ANSWER : ?
YOUR ANSWER : ?

Output reports should be included as part of an ERD.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A rectangle represents which of the following in an ERD?

Attribute

Relationship

Optional One

Entity

TRUE ANSWER : ?
YOUR ANSWER : ?

A relationship is which of the following?

Property or characteristic of an entity

Weak entity

Link between entities

A person, place, or thing

TRUE ANSWER : ?
YOUR ANSWER : ?

A good identifier is which of the following?

Be intelligent

One that is unique

Can be null

One that can change over time

TRUE ANSWER : ?
YOUR ANSWER : ?

A good business rule is which of the following?

Imprecise

Compound

Redundant

Declarative

TRUE ANSWER : ?
YOUR ANSWER : ?

If there are two entities with a relationship between them, and one of the entities is completely dependent on the other, then which of the following must exist?

Optional one cardinality

Weak entity

Derived attribute

Multi-valued attribute

TRUE ANSWER : ?
YOUR ANSWER : ?

Relationships cannot have attributes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A composite attribute is which of the following?

An identifier

An attribute that cannot be broken into components

An attribute that can be broken into components

Multiple attributes

TRUE ANSWER : ?
YOUR ANSWER : ?

↑