MIS 3353 Exam 2 Questions With Correct
Answers
In |the |conceptual |design |context, |the |common |types |of |entities |are... |(Select |any/all |that |
apply.) |- |CORRECT |ANSWER✔✔-weak, |strong, |associative |entities
Customers, |cars, |and |parts |would |most |likely |be |examples |of |which |one |of |the |following? |- |
CORRECT |ANSWER✔✔-Entities
An |entity |type |whose |existence |depends |on |another |entity |type |is |called |a |________ |entity |- |
CORRECT |ANSWER✔✔-weak
A |property |or |characteristic |of |an |entity |type |that |is |of |interest |to |the |organization |is |called |
a(n): |- |CORRECT |ANSWER✔✔-attribute
An |attribute |that |can |be |broken |down |into |smaller |parts |is |called |a(n) |________ |attribute |- |
CORRECT |ANSWER✔✔-composite
The |total |quiz |points |for |a |student |for |an |entire |semester |would |most |likely |be |an |example |of |
a(n) |________ |attribute |- |CORRECT |ANSWER✔✔-derived
An |entity |that |contains |attributes |specific |to |the |relationship |between |instances |within |one |or |
more |entity(-ies) |is |called |a(n)... |(Select |any/all |that |apply.) |- |CORRECT |ANSWER✔✔-
associative |entity
The |number |of |entities |that |participate |in |a |relationship |is |called |the |_____. |- |CORRECT |
ANSWER✔✔-degree
, The |relationship |between |a |weak |entity |type |and |its |owner |is |a |form |of |which |one |of |the |
following? |- |CORRECT |ANSWER✔✔-Identifying |Relationship
A |student |can |attend |five |classes, |each |with |a |different |professor. |Each |professor |has |30 |
students. |The |relationship |of |students |to |professors |is |a |________ |relationship. |- |CORRECT |
ANSWER✔✔-many |to |many
A |________ |specifies |the |number |of |instances |of |one |entity |that |can |be |associated |with |each |
instance |of |another |entity |- |CORRECT |ANSWER✔✔-Cardinality |Constraint
It |would |make |sense |to |consider |creating |a |super-type/sub-type |relationship |when... |- |
CORRECT |ANSWER✔✔-An |entity's |instances |share |some, |but |not |all, |attributes.
An |attribute |included |in |the |super-type... |- |CORRECT |ANSWER✔✔-Is |inherited |by |each |of |the |
sub-types.
Regarding |completeness |constraints... |- |CORRECT |ANSWER✔✔-total |specialization |means |each
|instance |of |the |super-type |must |belong |to |at |least |one |sub-type
The |disjoint |rule |and |the |overlap |rule... |- |CORRECT |ANSWER✔✔-Refer |to |whether |an |instance |
can |belong |to |multiple |sub-types |or |not.
If |I...
1. |Had |a |super-type |of |Personnel |with |sub-types |Volunteer, |Donor, |and |Employee;
2. |Was |okay |with |having |people |in |my |Personnel |table |about |whom |I |wasn't |sure |their |role |in |
the |organization; |and
3. |Was |okay |with, |employees |volunteering |for |events, |volunteers |making |donations, |and |
donors |also |being |employees.
What |constraints |would |I |want |to |place |on |my |super-type/sub-type |relationship? |- |CORRECT |
ANSWER✔✔-Partial |Specialization |Rule, |Overlap |Rule
Answers
In |the |conceptual |design |context, |the |common |types |of |entities |are... |(Select |any/all |that |
apply.) |- |CORRECT |ANSWER✔✔-weak, |strong, |associative |entities
Customers, |cars, |and |parts |would |most |likely |be |examples |of |which |one |of |the |following? |- |
CORRECT |ANSWER✔✔-Entities
An |entity |type |whose |existence |depends |on |another |entity |type |is |called |a |________ |entity |- |
CORRECT |ANSWER✔✔-weak
A |property |or |characteristic |of |an |entity |type |that |is |of |interest |to |the |organization |is |called |
a(n): |- |CORRECT |ANSWER✔✔-attribute
An |attribute |that |can |be |broken |down |into |smaller |parts |is |called |a(n) |________ |attribute |- |
CORRECT |ANSWER✔✔-composite
The |total |quiz |points |for |a |student |for |an |entire |semester |would |most |likely |be |an |example |of |
a(n) |________ |attribute |- |CORRECT |ANSWER✔✔-derived
An |entity |that |contains |attributes |specific |to |the |relationship |between |instances |within |one |or |
more |entity(-ies) |is |called |a(n)... |(Select |any/all |that |apply.) |- |CORRECT |ANSWER✔✔-
associative |entity
The |number |of |entities |that |participate |in |a |relationship |is |called |the |_____. |- |CORRECT |
ANSWER✔✔-degree
, The |relationship |between |a |weak |entity |type |and |its |owner |is |a |form |of |which |one |of |the |
following? |- |CORRECT |ANSWER✔✔-Identifying |Relationship
A |student |can |attend |five |classes, |each |with |a |different |professor. |Each |professor |has |30 |
students. |The |relationship |of |students |to |professors |is |a |________ |relationship. |- |CORRECT |
ANSWER✔✔-many |to |many
A |________ |specifies |the |number |of |instances |of |one |entity |that |can |be |associated |with |each |
instance |of |another |entity |- |CORRECT |ANSWER✔✔-Cardinality |Constraint
It |would |make |sense |to |consider |creating |a |super-type/sub-type |relationship |when... |- |
CORRECT |ANSWER✔✔-An |entity's |instances |share |some, |but |not |all, |attributes.
An |attribute |included |in |the |super-type... |- |CORRECT |ANSWER✔✔-Is |inherited |by |each |of |the |
sub-types.
Regarding |completeness |constraints... |- |CORRECT |ANSWER✔✔-total |specialization |means |each
|instance |of |the |super-type |must |belong |to |at |least |one |sub-type
The |disjoint |rule |and |the |overlap |rule... |- |CORRECT |ANSWER✔✔-Refer |to |whether |an |instance |
can |belong |to |multiple |sub-types |or |not.
If |I...
1. |Had |a |super-type |of |Personnel |with |sub-types |Volunteer, |Donor, |and |Employee;
2. |Was |okay |with |having |people |in |my |Personnel |table |about |whom |I |wasn't |sure |their |role |in |
the |organization; |and
3. |Was |okay |with, |employees |volunteering |for |events, |volunteers |making |donations, |and |
donors |also |being |employees.
What |constraints |would |I |want |to |place |on |my |super-type/sub-type |relationship? |- |CORRECT |
ANSWER✔✔-Partial |Specialization |Rule, |Overlap |Rule
