1|Page
SER 322 MIDTERM Questions with
Detailed Verified Answers
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 Ans: C
A condition that an entity can be a member of at most one of the subclasses
of the specialization is called ______________.
,2|Page
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint Ans: 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 Ans: 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 Ans: A.
,3|Page
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 Ans: 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
, 4|Page
D. Variable Ans: C.
In an E-R diagram entities are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles Ans: D.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
SER 322 MIDTERM Questions with
Detailed Verified Answers
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 Ans: C
A condition that an entity can be a member of at most one of the subclasses
of the specialization is called ______________.
,2|Page
A. completeness constraint
B. overlapping constraint
C. disjointness constraint
D. predicate constraint Ans: 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 Ans: 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 Ans: A.
,3|Page
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 Ans: 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
, 4|Page
D. Variable Ans: C.
In an E-R diagram entities are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
D. rectangles Ans: D.
In an E-R diagram Attributes are represented by _______________.
A. diamond shaped box
B. circles
C. ellipse
