Modeling Data in the Organization – General Questions

1. A binary relationship is which of the following?

A. A relationship between two attributes
B. A relationship between two entities
C. An attribute with two different relationships
D. An entity with two different relationships

Correct Answer: B. A relationship between two entities

2. 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?

A. Derived attribute
B. Optional one cardinality
C. Multi-valued attribute
D. Weak entity

Correct Answer: D. Weak entity

3. A relationship is which of the following?

A. A person, place, or thing
B. Property or characteristic of an entity
C. Link between entities
D. Weak entity

Correct Answer: C. Link between entities

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

A. Some of the relationships for the participating entities are “many”.
B. The resulting associative entity has an independent meaning.
C. The resulting associative entity has no attributes.
D. All of the above

Correct Answer: B. The resulting associative entity has an independent meaning.

5. A good identifier is which of the following?

A. One that can change over time
B. Can be null
C. One that is unique
D. Be intelligent

Correct Answer: C. One that is unique

Leave A Comment?

14 − 12 =