Data Modeling With Er Model(Database ) Questions and Answers
Question 1. Which of the following indicates the maximum number of entities that can be involved in a relationship?
Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
Explanation:-
Answer: Option B. -> Maximum cardinality
Question 2. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
parent
child
instance
subtype
Explanation:-
Answer: Option A. -> parent
Question 3. A recursive relationship is a relationship between an entity and ________ .
itself
a subtype entity
an archetype entity
an instance entity
Explanation:-
Answer: Option A. -> itself
Question 4. Which type of entity represents an actual occurrence of an associated generalized entity?
Supertype entity
Subtype entity
Archetype entity
Instance entity
Explanation:-
Answer: Option D. -> Instance entity
Question 5. 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?
Weak entity
Strong entity
ID-dependent entity
ID- independent entity
Explanation:-
Answer: Option A. -> Weak entity
Question 6. Which of the following indicates the minimum number of entities that must be involved in a relationship?
Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
Explanation:-
Answer: Option A. -> Minimum cardinality
Question 7. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Supertype entity
Subtype entity
Archetype entity
Instance entity
Explanation:-
Answer: Option A. -> Supertype entity
Question 8. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Weak entity
Strong entity
ID-dependent entity
ID-independent entity
Explanation:-
Answer: Option C. -> ID-dependent entity
Question 9. Which of the following refers to something that can be identified in the user's work environment, something that the users want to track?
Entity
Attribute
Identifier
Relationship
Explanation:-
Answer: Option A. -> Entity
Question 10. In which of the following is a single-entity instance of one type related to many entity instances of another type?