ISM 3004 EXAM 3 - THE DATA ASSET QUESTIONS
AND VERIFIED ACCURATE ANSWERS
Data is an asset because... - Answers - it is useful and valuable.
What is the rate of data growth? - Answers - Doubling every 6 months.
It is unprecedented and will continue.
What is "informational overload"? Impact? - Answers - flood of data, hard for people to
do their jobs.
There is a $900 billion cost to economy. Therefore, people cant do their jobs.
Its like drinking water from a fire hydrant.
What is "information abundance"? What are its implications for knowledge workers? -
Answers - -The world has changed, and some people have not caught up to that
change or recognized that they are in a new environment.
- Geek up! Take advantage of the opportunities presented by all that data.
Schema - Answers - the way data is organized
Business Intelligence - Answers - Using information to make decisions based on the
data.
Analytics - Answers - the analysis of data to make the right decisions
Data - Information - Knowledge - Answers - -
What is Data? - Answers - Raw facts + figures
-dont tell you anything +dont answer questions or support decision making
What is Information? - Answers - Data presented in a context so it can answer a
question or support decision making.
What is knowledge? - Answers - insight derived from experience + expertise.
what makes up the great divide? - Answers - Structured + Unstructured Data
Structured Data - Answers - -Organized
-Predefined characteristics - "schema"
Unstructured Data - Answers - -not organized -no schema
, -text data: email, facebook pages, news stories, etc.
-Binary - images, audio, videos
Table - Answers - organized collection of data
- made up of records + fields
Record - Answers - individual observation
a row (each row in a table is a record)
Fields - Answers - columns
- there is data for every observation
- fields are predetermined by the database tables schema
Relational Database - Answers - multiple tables that are related using a common
element
Benefits of using Relational Databases? - Answers - Real power when you can
correlate data from multiple tables.
Relational Database - Key Fields - Answers - -one of the fields
-data items in that field are unique for every row + never repeat
What is an example of Relational Database -Key Fields? - Answers - UFID #
Valid relationship types - Answers - - key fields create relationships between different
tables.
-in order to have a relationship, a field must be found in 2 different tables.
What two different tables can a field be found in valid relationship types? - Answers - -
One:One
-One:Many
-Many:Many - NOT ALLOWED
Why is Many:Many not allowed? - Answers - Because there is no way to uniquely
identify or define it.
Relational Database - Views - Answers - -allow the user to see data from multiple tables
joined together
- appears as if it were one table
- enhances integrity of the data
What does SQL stand for? - Answers - Structured Query Language
Structured Query Language - Answers - -most common language for
creating+manipulating databases
AND VERIFIED ACCURATE ANSWERS
Data is an asset because... - Answers - it is useful and valuable.
What is the rate of data growth? - Answers - Doubling every 6 months.
It is unprecedented and will continue.
What is "informational overload"? Impact? - Answers - flood of data, hard for people to
do their jobs.
There is a $900 billion cost to economy. Therefore, people cant do their jobs.
Its like drinking water from a fire hydrant.
What is "information abundance"? What are its implications for knowledge workers? -
Answers - -The world has changed, and some people have not caught up to that
change or recognized that they are in a new environment.
- Geek up! Take advantage of the opportunities presented by all that data.
Schema - Answers - the way data is organized
Business Intelligence - Answers - Using information to make decisions based on the
data.
Analytics - Answers - the analysis of data to make the right decisions
Data - Information - Knowledge - Answers - -
What is Data? - Answers - Raw facts + figures
-dont tell you anything +dont answer questions or support decision making
What is Information? - Answers - Data presented in a context so it can answer a
question or support decision making.
What is knowledge? - Answers - insight derived from experience + expertise.
what makes up the great divide? - Answers - Structured + Unstructured Data
Structured Data - Answers - -Organized
-Predefined characteristics - "schema"
Unstructured Data - Answers - -not organized -no schema
, -text data: email, facebook pages, news stories, etc.
-Binary - images, audio, videos
Table - Answers - organized collection of data
- made up of records + fields
Record - Answers - individual observation
a row (each row in a table is a record)
Fields - Answers - columns
- there is data for every observation
- fields are predetermined by the database tables schema
Relational Database - Answers - multiple tables that are related using a common
element
Benefits of using Relational Databases? - Answers - Real power when you can
correlate data from multiple tables.
Relational Database - Key Fields - Answers - -one of the fields
-data items in that field are unique for every row + never repeat
What is an example of Relational Database -Key Fields? - Answers - UFID #
Valid relationship types - Answers - - key fields create relationships between different
tables.
-in order to have a relationship, a field must be found in 2 different tables.
What two different tables can a field be found in valid relationship types? - Answers - -
One:One
-One:Many
-Many:Many - NOT ALLOWED
Why is Many:Many not allowed? - Answers - Because there is no way to uniquely
identify or define it.
Relational Database - Views - Answers - -allow the user to see data from multiple tables
joined together
- appears as if it were one table
- enhances integrity of the data
What does SQL stand for? - Answers - Structured Query Language
Structured Query Language - Answers - -most common language for
creating+manipulating databases
