INFO 340 Study Guide - Quiz Guide: Foreign Key, Candidate Key, Unique Key
INFO 340
Quiz 2 Review
1. Explain what the instructor means by the phrase ‘organize or die’.
a. Progression of data: daa → information → knowledge → understand →
wisdom
i. Data – raw values lacking context
ii. Information – data in context
iii. Knowledge – information that is processed
(deductions/inferences)
iv. Understanding – knowledge that is validate (“good thing I brought
an umbrella”)
v. Wisdom – subconscious/internalized understanding
b. Leverage data into a competitive advantage
c. System – input that leads to expected output/result
i. Repeatable; leads to efficiency + can be optimized over time
ii. Learning based on organizing + analyzing: Those who were
effective at building systems survived
iii. When you have systems → specialization, experts, innovation,
people become interchangeable
d. Databases allow for competitive advantage via consumption of massive
amounts of data
i. Analyze trends b/c of better information
2. Explain the benefits and liabilities of paper-based systems.
a. What is it?
i. They still exist: drawers, glove compartment, receipts, file
cabinets
b. Benefits
i. Cheap
ii. Easy to use; no specialized skills
iii. Quick to establush
c. Liabilities
i. Binders/ledgers of accounting; if lost, it’s gone (vulnerable)
ii. Expensive to replace if lost