DATABASE REDESIGN QUIZ

Relationships cannot have attributes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Cannot tell

Mandatory one

Mandatory many

Optional one

TRUE ANSWER : ?
YOUR ANSWER : ?

A derived attribute is an attribute whose values can be calculated from a related relationship.

False

True

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 an independent meaning.

All of these

The resulting associative entity has no attributes.

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

An attribute name should be which of the following?

Follow a standard format

Singular verb or verb phrase

All of these

Use a alias

TRUE ANSWER : ?
YOUR ANSWER : ?

An attribute is a person, place, object, event in a user environment.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A relationship is an association representing the interaction between attributes.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑