BTM Exam 3 Review (updated)
questions well answered
Data and Information Hierarchies - correct answer ✔✔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 - correct answer ✔✔High speed, automatic
software updates, cost/energy efficient, data security, and scalability
Metcalfe's law - correct answer ✔✔Law of network economics, value of a network increases
with the square of the number of known users
Moores Law - correct answer ✔✔Cost of data, processing, communications, and storage is
essentially zero (power of computing will double every 18-24 months cost constant)
Index - correct answer ✔✔Statistical measure (of change or otherwise)
Foreign Key - correct answer ✔✔Column in a relational database that provides a link between
data in two tables.
Primary Key - correct answer ✔✔Column that contains values that uniquely identify each row in
a table.
, Referential Integrity - correct answer ✔✔Prevents orphaned references throughout the
database
Minimum Cardinality - correct answer ✔✔The minimum number of relationships one entity can
have in relation to another.
Maximum Cardinality - correct answer ✔✔The maximum number of relationships one entity
can have in relation to another.
Internet of Things (IoT) - correct answer ✔✔Imbedding of intelligence into otherwise
unintelligent devices
Define the Internet - correct answer ✔✔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 - correct answer
✔✔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) - correct answer ✔✔Standardized programming language
that's used to manage relational databases and perform various operations on the data in them.
Value Chain - correct answer ✔✔Each step in a process should be adding value
Big Data (5 V's) - correct answer ✔✔Volume: massive data
questions well answered
Data and Information Hierarchies - correct answer ✔✔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 - correct answer ✔✔High speed, automatic
software updates, cost/energy efficient, data security, and scalability
Metcalfe's law - correct answer ✔✔Law of network economics, value of a network increases
with the square of the number of known users
Moores Law - correct answer ✔✔Cost of data, processing, communications, and storage is
essentially zero (power of computing will double every 18-24 months cost constant)
Index - correct answer ✔✔Statistical measure (of change or otherwise)
Foreign Key - correct answer ✔✔Column in a relational database that provides a link between
data in two tables.
Primary Key - correct answer ✔✔Column that contains values that uniquely identify each row in
a table.
, Referential Integrity - correct answer ✔✔Prevents orphaned references throughout the
database
Minimum Cardinality - correct answer ✔✔The minimum number of relationships one entity can
have in relation to another.
Maximum Cardinality - correct answer ✔✔The maximum number of relationships one entity
can have in relation to another.
Internet of Things (IoT) - correct answer ✔✔Imbedding of intelligence into otherwise
unintelligent devices
Define the Internet - correct answer ✔✔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 - correct answer
✔✔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) - correct answer ✔✔Standardized programming language
that's used to manage relational databases and perform various operations on the data in them.
Value Chain - correct answer ✔✔Each step in a process should be adding value
Big Data (5 V's) - correct answer ✔✔Volume: massive data
