MIS3353 (Databases) Final Exam Study Guide with
| | | | | | |
correct answers |
What |happens |when |you |have |a |relationship |between |delivery |out |and |salesorder? |- |correct |answer | |
not |allowing |partial |orders |to |be |sent
What |happens |when |you |have |a |relationship |between |delivery |in |and |purchaseorderline? |- |correct |
answer | |allowing |partial |purchases |to |be |received
Which |of |the |following |documents |is |created |by |a |manager |who |recognizes |the |need |to |stock |up |on |
inventory |of |a |certain |raw |material? |- |correct |answer | |Purchase |Requisition
type |of |accounts |receivable |system |that |permits |a |customer |payment |on |an |account |balance |is |called |
a(n) |__________ |system. |- |correct |answer | |balance-forward
Fred's |Slow |Mail |Order |Company |sells |stuff |through |the |mail. |When |customers |want |to |buy |
something, |they |call |a |salesperson |and |place |the |order. |That |sales |person |records |the |order. |At |the |
end |of |each |week, |a |sales |supervisor |reviews |all |the |week's |sales |and |approves |them |(or |rejects |
them). |Following |approval, |all |orders |are |shipped |out |the |next |Tuesday. |Assuming |that |all |employees |
involved |in |the |process |are |represented |by |records |in |the |Employee |table |and |that |sales |orders |are |
recorded |(and |approval/rejection |noted) |in |the |SalesOrder |entity, |what |would |the |cardinality |be |on |
the |Employee |side |of |the |relationship |with |SalesOrder |that |represents |order |approval? |- |correct |
answer | |zero |to |one
If |you |were |writing |a |query |and |wanted |to |show |data |for |all |columns |returned |in |the |query, |which |of
|the |following |could |you |use |as |your |SELECT |clause? |- |correct |answer | |select |*
In |which |case |would |you |identify |a |field |as |an |index |field |when |creating |a |data |dictionary? |- |correct |
answer | |The |field |is |often |part |of |the |WHERE |statement |in |SQL |queries.
A |data |warehouse |stores |which |type |of |data? |Select |all |that |apply. |- |correct |answer | |status |data, |
event |data, |and |periodic |data
, What |are |the |3 |V's |of |Big |Data? |Select |all |that |apply |- |correct |answer | |Variety, |Velocity, |Volume
The |Waterfall |SDLC |focuses |heavily |on |documentation |at |each |phase, |whereas |Agile |places |a |higher |
emphasis |on |working |software |and |collaboration. |(True/False) |- |correct |answer | |True
What |determines |whether |an |object/noun |qualifies |as |an |entity |in |a |database? |- |correct |answer | |
There |are |multiple |instances |of |the |entity's |"type".
What |are |the |four |qualities |of |a |Primary |Key? |- |correct |answer | |Must |be |unique, |not |null, |not |
changing, |and |must |be |semantic |or |artificial
What |is |an |atomic |attribute? |- |correct |answer | |its |values |are |treated |as |a |single |unit |and |cannot |be |
broken |into |smaller |pieces
What |is |total |specialization? |- |correct |answer | |Supertype |must |fall |into |one |of |the |subtypes
What |is |partial |specialization? |- |correct |answer | |Supertype |may |fall |into |one |of |the |subtypes, |but |can |
also |exist |without |any |subtype |attributes
What |is |disjointness |constraint? |- |correct |answer | |whether |subtypes |are |disjoint |or |overlap
The |attribute |within |the |super-type |entity |that |is |used |to |specify |the |sub-type(s) |to |which |an |instance
|belongs |is |called |what? |- |correct |answer | |Sub-type |discriminator
What |is |the |biggest |problem |you |can |face |with |invoices? |- |correct |answer | |paying |invoices |multiple |
times
What |is |the |primary |purpose |of |controls |within |an |organization? |- |correct |answer | |To |reduce |the |
company's |exposure |to |threats |by |either |lowering |the |damage |a |threat |can |inflict |or |decreasing |the |
probability |of |its |occurrence.
| | | | | | |
correct answers |
What |happens |when |you |have |a |relationship |between |delivery |out |and |salesorder? |- |correct |answer | |
not |allowing |partial |orders |to |be |sent
What |happens |when |you |have |a |relationship |between |delivery |in |and |purchaseorderline? |- |correct |
answer | |allowing |partial |purchases |to |be |received
Which |of |the |following |documents |is |created |by |a |manager |who |recognizes |the |need |to |stock |up |on |
inventory |of |a |certain |raw |material? |- |correct |answer | |Purchase |Requisition
type |of |accounts |receivable |system |that |permits |a |customer |payment |on |an |account |balance |is |called |
a(n) |__________ |system. |- |correct |answer | |balance-forward
Fred's |Slow |Mail |Order |Company |sells |stuff |through |the |mail. |When |customers |want |to |buy |
something, |they |call |a |salesperson |and |place |the |order. |That |sales |person |records |the |order. |At |the |
end |of |each |week, |a |sales |supervisor |reviews |all |the |week's |sales |and |approves |them |(or |rejects |
them). |Following |approval, |all |orders |are |shipped |out |the |next |Tuesday. |Assuming |that |all |employees |
involved |in |the |process |are |represented |by |records |in |the |Employee |table |and |that |sales |orders |are |
recorded |(and |approval/rejection |noted) |in |the |SalesOrder |entity, |what |would |the |cardinality |be |on |
the |Employee |side |of |the |relationship |with |SalesOrder |that |represents |order |approval? |- |correct |
answer | |zero |to |one
If |you |were |writing |a |query |and |wanted |to |show |data |for |all |columns |returned |in |the |query, |which |of
|the |following |could |you |use |as |your |SELECT |clause? |- |correct |answer | |select |*
In |which |case |would |you |identify |a |field |as |an |index |field |when |creating |a |data |dictionary? |- |correct |
answer | |The |field |is |often |part |of |the |WHERE |statement |in |SQL |queries.
A |data |warehouse |stores |which |type |of |data? |Select |all |that |apply. |- |correct |answer | |status |data, |
event |data, |and |periodic |data
, What |are |the |3 |V's |of |Big |Data? |Select |all |that |apply |- |correct |answer | |Variety, |Velocity, |Volume
The |Waterfall |SDLC |focuses |heavily |on |documentation |at |each |phase, |whereas |Agile |places |a |higher |
emphasis |on |working |software |and |collaboration. |(True/False) |- |correct |answer | |True
What |determines |whether |an |object/noun |qualifies |as |an |entity |in |a |database? |- |correct |answer | |
There |are |multiple |instances |of |the |entity's |"type".
What |are |the |four |qualities |of |a |Primary |Key? |- |correct |answer | |Must |be |unique, |not |null, |not |
changing, |and |must |be |semantic |or |artificial
What |is |an |atomic |attribute? |- |correct |answer | |its |values |are |treated |as |a |single |unit |and |cannot |be |
broken |into |smaller |pieces
What |is |total |specialization? |- |correct |answer | |Supertype |must |fall |into |one |of |the |subtypes
What |is |partial |specialization? |- |correct |answer | |Supertype |may |fall |into |one |of |the |subtypes, |but |can |
also |exist |without |any |subtype |attributes
What |is |disjointness |constraint? |- |correct |answer | |whether |subtypes |are |disjoint |or |overlap
The |attribute |within |the |super-type |entity |that |is |used |to |specify |the |sub-type(s) |to |which |an |instance
|belongs |is |called |what? |- |correct |answer | |Sub-type |discriminator
What |is |the |biggest |problem |you |can |face |with |invoices? |- |correct |answer | |paying |invoices |multiple |
times
What |is |the |primary |purpose |of |controls |within |an |organization? |- |correct |answer | |To |reduce |the |
company's |exposure |to |threats |by |either |lowering |the |damage |a |threat |can |inflict |or |decreasing |the |
probability |of |its |occurrence.
