SER 322 MIDTERM EXAM QUESTIONS WITH
CORRECT 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 |- |CORRECT |
ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-C.
In |an |E-R |diagram |entities |are |represented |by |_______________.
A. |diamond |shaped |box
B. |circles
C. |ellipse
D. |rectangles |- |CORRECT |ANSWER✔✔-D.
In |an |E-R |diagram |Attributes |are |represented |by |_______________.
A. |diamond |shaped |box
B. |circles
C. |ellipse
CORRECT 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 |- |CORRECT |
ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-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 |- |CORRECT |ANSWER✔✔-C.
In |an |E-R |diagram |entities |are |represented |by |_______________.
A. |diamond |shaped |box
B. |circles
C. |ellipse
D. |rectangles |- |CORRECT |ANSWER✔✔-D.
In |an |E-R |diagram |Attributes |are |represented |by |_______________.
A. |diamond |shaped |box
B. |circles
C. |ellipse
