SER 322 MIDTERM TEST QUESTIONS ANSWERED CORRECTLY
What is a Composite attribute?
A. An attribute that represents a value that is derivable from a related attribute or set of attributes, not
necessarily in the same entity
B. An attribute that holds multiple values for a single component
C. An attribute composed of multiple components each with individual existence
D. An attribute that holds a single value for a single entity
E. An attribute composed of a single component with an independent existence - Answers C
A condition that an entity can be a member of at most one of the subclasses of the specialization is
called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers C
A condition that an entity can be a member of more than one of the subclasses of the specialization is
called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers B
,A condition that every entity in the superclass must be a member of some subclass in the specialization/
generalization is called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers A.
An entity is ____________.
A. an inanimate object in an application
B. a collection of items in a mini-world
C. a distinct object or thing in a mini-world
D. data structure - Answers C.
An entity that does not have sufficient attributes to form a primary key is termed a __________.
A. Variant
B. Strong entity
C. Weak entity
D. Variable - Answers C.
In an E-R diagram entities are represented by _______________.
, A. diamond shaped box
B. circles
C. ellipse
D. rectangles - Answers D.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles - Answers C.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
What is a Composite attribute?
A. An attribute that represents a value that is derivable from a related attribute or set of attributes, not
necessarily in the same entity
B. An attribute that holds multiple values for a single component
C. An attribute composed of multiple components each with individual existence
D. An attribute that holds a single value for a single entity
E. An attribute composed of a single component with an independent existence - Answers C
A condition that an entity can be a member of at most one of the subclasses of the specialization is
called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers C
A condition that an entity can be a member of more than one of the subclasses of the specialization is
called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers B
,A condition that every entity in the superclass must be a member of some subclass in the specialization/
generalization is called ______________.
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint - Answers A.
An entity is ____________.
A. an inanimate object in an application
B. a collection of items in a mini-world
C. a distinct object or thing in a mini-world
D. data structure - Answers C.
An entity that does not have sufficient attributes to form a primary key is termed a __________.
A. Variant
B. Strong entity
C. Weak entity
D. Variable - Answers C.
In an E-R diagram entities are represented by _______________.
, A. diamond shaped box
B. circles
C. ellipse
D. rectangles - Answers D.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles - Answers C.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
