cs6400 DB Systems Exam 1 - Chapter 3
QUESTIONS AND VERIFIED CORRECT
ANSWERS GRADED A+ [LATEST] 100%
GUARANTEED PASS
Minimum cardinaltiy constraint - CORRECT ANSWER-Minimum number of relationship
instances that each can participate in
Total participation - CORRECT ANSWER-Every entity in the total set of entities must be
related to a n entity
How is total participation displayed on an ER diagram? - CORRECT ANSWER-Double
line
Partial Participation - CORRECT ANSWER-Some or part of the entities in the total set
of entities must be related to an entity
Attributes of relative types - CORRECT ANSWER-relationship types can have attributes
Weak Entity Types - CORRECT ANSWER-Entity types that do not have key attributes
on their own
Strong Entity TYpes - CORRECT ANSWER-Regualr entity types that do have attributes
of their own
Owner Entity type - CORRECT ANSWER-Entity types belonging to a weak entity type
Identifying Relationship - CORRECT ANSWER-Relationship type that relates to a weak
entity type
Weak entities have what constraint? - CORRECT ANSWER-Total Participation
Weak entity has a - CORRECT ANSWER-Partial Key
Partial Key - CORRECT ANSWER-A attribute that can uniquely identify weak entities
that are related to the same owner entity
Class - CORRECT ANSWER-Entity type in ER model
QUESTIONS AND VERIFIED CORRECT
ANSWERS GRADED A+ [LATEST] 100%
GUARANTEED PASS
Minimum cardinaltiy constraint - CORRECT ANSWER-Minimum number of relationship
instances that each can participate in
Total participation - CORRECT ANSWER-Every entity in the total set of entities must be
related to a n entity
How is total participation displayed on an ER diagram? - CORRECT ANSWER-Double
line
Partial Participation - CORRECT ANSWER-Some or part of the entities in the total set
of entities must be related to an entity
Attributes of relative types - CORRECT ANSWER-relationship types can have attributes
Weak Entity Types - CORRECT ANSWER-Entity types that do not have key attributes
on their own
Strong Entity TYpes - CORRECT ANSWER-Regualr entity types that do have attributes
of their own
Owner Entity type - CORRECT ANSWER-Entity types belonging to a weak entity type
Identifying Relationship - CORRECT ANSWER-Relationship type that relates to a weak
entity type
Weak entities have what constraint? - CORRECT ANSWER-Total Participation
Weak entity has a - CORRECT ANSWER-Partial Key
Partial Key - CORRECT ANSWER-A attribute that can uniquely identify weak entities
that are related to the same owner entity
Class - CORRECT ANSWER-Entity type in ER model
