• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 7 páginas
Examen

MIS3353 (Databases) Final Exam Study Guide with correct answers.

Document preview thumbnail
Vista previa 2 fuera de 7 páginas

MIS3353 (Databases) Final Exam Study Guide with correct answers.

Vista previa del contenido

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.

Información del documento

Subido en
18 de octubre de 2025
Número de páginas
7
Escrito en
2025/2026
Tipo
Examen
Contiene
Preguntas y respuestas
$15.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
lectjones
4.0
(3)
Vendido
27
Seguidores
2
Artículos
2293
Última venta
1 mes hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes