MODELING DATA IN THE ORGANIZATION QUIZ

An oval represents which of the following in an ERD?

Relationship

Attribute

Entity

Optional One

TRUE ANSWER : ?
YOUR ANSWER : ?

A binary relationship is a relationship between two or more entities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

No two attributes of the same entity type should have the same name.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A composite attribute is which of the following?

Multiple attributes

An identifier

An attribute that can be broken into components

An attribute that cannot be broken into components

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following conditions should exist if you want to convert a relationship to an associative entity?

Some of the relationships for the participating entities are 'many'.

The resulting associative entity has no attributes.

All of these

The resulting associative entity has an independent meaning.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A binary relationship cannot be which of the following?

Many-to-Many

One-to-Many

One-to-One

Zero-to-Zero

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?

Declarative

Compound

Redundant

Imprecise

TRUE ANSWER : ?
YOUR ANSWER : ?

When the minimum number of instances of an entity is one, you know which of the following?

Mandatory many

Cannot tell

Mandatory one

Optional one

TRUE ANSWER : ?
YOUR ANSWER : ?