BTM Exam 3 Review – Study Guide, Practice Questions & Course
Preparation
Data and Information Hierarchies - ANS ✔✔Information: contained in descriptions
Knowledge: conveyed by instructions (answers to how-to questions)
Understanding: conveyed by explanation (answers to why questions)
Wisdom: deals with values (is an exercise of judgement and whether or not something is
actually a good idea)
One benefit of the cloud discussed in class includes - ANS ✔✔High speed, automatic software
updates, cost/energy efficient, data security, and scalability
Metcalfe's law - ANS ✔✔Law of network economics, value of a network increases with the
square of the number of known users
Moores Law - ANS ✔✔Cost of data, processing, communications, and storage is essentially zero
(power of computing will double every 18-24 months cost constant)
Index - ANS ✔✔Statistical measure (of change or otherwise)
Foreign Key - ANS ✔✔Column in a relational database that provides a link between data in two
tables.
Primary Key - ANS ✔✔Column that contains values that uniquely identify each row in a table.
Referential Integrity - ANS ✔✔Prevents orphaned references throughout the database
, Minimum Cardinality - ANS ✔✔The minimum number of relationships one entity can have in
relation to another.
Maximum Cardinality - ANS ✔✔The maximum number of relationships one entity can have in
relation to another.
Internet of Things (IoT) - ANS ✔✔Imbedding of intelligence into otherwise unintelligent devices
Define the Internet - ANS ✔✔The global communication network that allows almost all
computers worldwide to connect and exchange information.
Date's of Internet/Worldwide Web (WWW) Invention & of Other Importance - ANS ✔✔1972:
Internet created
1982: IBM introduce IBM PC (personal computer)
1989: Tim Burners Lee working at Cern in Switzerland invents WWW
1991: U.S. government releases internet for general public use
1994: Javascript is introduced
SQL (Structured Query Language) - ANS ✔✔Standardized programming language that's used to
manage relational databases and perform various operations on the data in them.
Value Chain - ANS ✔✔Each step in a process should be adding value
Big Data (5 V's) - ANS ✔✔Volume: massive data
Velocity: how rapidly something is entering the system
Variety: analyzed for purposes other than for which they were collected
Veracity: "truthiness" of data
Value: able to get something important out of the data
Preparation
Data and Information Hierarchies - ANS ✔✔Information: contained in descriptions
Knowledge: conveyed by instructions (answers to how-to questions)
Understanding: conveyed by explanation (answers to why questions)
Wisdom: deals with values (is an exercise of judgement and whether or not something is
actually a good idea)
One benefit of the cloud discussed in class includes - ANS ✔✔High speed, automatic software
updates, cost/energy efficient, data security, and scalability
Metcalfe's law - ANS ✔✔Law of network economics, value of a network increases with the
square of the number of known users
Moores Law - ANS ✔✔Cost of data, processing, communications, and storage is essentially zero
(power of computing will double every 18-24 months cost constant)
Index - ANS ✔✔Statistical measure (of change or otherwise)
Foreign Key - ANS ✔✔Column in a relational database that provides a link between data in two
tables.
Primary Key - ANS ✔✔Column that contains values that uniquely identify each row in a table.
Referential Integrity - ANS ✔✔Prevents orphaned references throughout the database
, Minimum Cardinality - ANS ✔✔The minimum number of relationships one entity can have in
relation to another.
Maximum Cardinality - ANS ✔✔The maximum number of relationships one entity can have in
relation to another.
Internet of Things (IoT) - ANS ✔✔Imbedding of intelligence into otherwise unintelligent devices
Define the Internet - ANS ✔✔The global communication network that allows almost all
computers worldwide to connect and exchange information.
Date's of Internet/Worldwide Web (WWW) Invention & of Other Importance - ANS ✔✔1972:
Internet created
1982: IBM introduce IBM PC (personal computer)
1989: Tim Burners Lee working at Cern in Switzerland invents WWW
1991: U.S. government releases internet for general public use
1994: Javascript is introduced
SQL (Structured Query Language) - ANS ✔✔Standardized programming language that's used to
manage relational databases and perform various operations on the data in them.
Value Chain - ANS ✔✔Each step in a process should be adding value
Big Data (5 V's) - ANS ✔✔Volume: massive data
Velocity: how rapidly something is entering the system
Variety: analyzed for purposes other than for which they were collected
Veracity: "truthiness" of data
Value: able to get something important out of the data
