Data Modeling with ER Model – General Questions

1. Which of the following indicates the maximum number of entities that can be involved in a relationship?

A. Minimum cardinality
B. Maximum cardinality
D. Greater Entity Count (GEC)

Correct Answer:  B. Maximum cardinality

2. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

A. Weak entity
B. Strong entity
C. ID-dependent entity
D. ID- independent entity

Correct Answer:  A. Weak entity

3. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

A. parent
B. child
C. instance
D. subtype

Correct Answer:  A. parent

4. Which type of entity represents an actual occurrence of an associated generalized entity?

A. Supertype entity
B. Subtype entity
C. Archetype entity
D. Instance entity

Correct Answer:  D. Instance entity

5. A recursive relationship is a relationship between an entity and ________ .

A. itself
B. a subtype entity
C. an archetype entity
D. an instance entity

Correct Answer:  A. itself

Leave A Comment?

1 × four =