MODELING DATA IN THE ORGANIZATION QUIZ

A time stamp is a time value that is associated with a data value.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A good identifier is which of the following?

One that can change over time

Can be null

One that is unique

Be intelligent

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Mandatory one

Optional one

Mandatory many

Cannot tell

TRUE ANSWER : ?
YOUR ANSWER : ?

A relationship is an association representing the interaction between attributes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The resulting associative entity has an independent meaning.

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

The resulting associative entity has no attributes.

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Output reports should be included as part of an ERD.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A strong entity is an entity whose existence depends on some other entity type.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A ternary relationship involves how many entities?

3 or more

3 or less

3

More than 3

TRUE ANSWER : ?
YOUR ANSWER : ?

A binary relationship is which of the following?

An attribute with two different relationships

A relationship between two entities

A relationship between two attributes

An entity with two different relationships

TRUE ANSWER : ?
YOUR ANSWER : ?

Some business rules cannot be represented in common data modeling notation.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?