The text lists the following (the student should pick at least three of these):i. The process of developing a data warehouse forces an organization to better understand the data that it is currently collecting and, equally important, what data isnot being collected.ii. A data warehouse provides a centralized view of all data being collected acrossthe enterprise and provides a means of determining data that is inconsistent.iii. Once all data is identified as consistent, an organization can generate one version of the truth. This is important when the company wants to report consistentstatistics about itself, such as revenue or number of employees.iv. By having a data warehouse, snapshots of data can be taken over time. Thiscreates a historical record of data, which allows for an analysis of trends.v. A data warehouse provides tools to combine data, which can provide newinformation and analysis.
  • What are the characteristics of a relational database?
  • Name a database you interact with frequently. What would some of the field names be?
  • Name three advantages of using a data warehouse.
  • Describe what the term normalization means.
The student can choose any sort of system that they interact with, such as Amazon or their school's online systems. The fields would be the names of data being collected, such as "first name", or "address".
  • What is the difference between data, information, and knowledge?
  • Name a database you interact with frequently. What would some of the field names be?
  • What are the characteristics of a relational database?
  • Why is it important to define the data type of a field when designing a relational database?
A database is generally more powerful and complex than a spreadsheet, with the ability to handle multiple types of data and link them together. Some differences: A database has defined field types, a spreadsheet does not. A database uses a standardized query language (such as SQL), a spreadsheet does not. A database can hold much larger amounts of data than a spreadsheet.
  • What is the difference between data, information, and knowledge?
  • What is the difference between a spreadsheet and a database? List three differences between them.
  • What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?
  • Why is it important to define the data type of a field when designing a relational database?
Quantitative data is numeric, the result of a measurement, count, or some other mathematical calculation. Qualitative data is descriptive. The number 42 could be qualitative if it is a designation instead of a measurement, count, or calculation. For example: that player's jersey has number 42 on it.
  • What is the difference between data, information, and knowledge?
  • What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?
  • What are the characteristics of a relational database?
  • What is the difference between a spreadsheet and a database? List three differences between them.
A relational database is one in which data is organized into one or more tables. Each table has a set of fields, which define the nature of the data stored in the table. A record is one instance of a set of fields in a table. All the tables are related by one or more fields in common.
  • What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?
  • What are the characteristics of a relational database?
  • What is the difference between data, information, and knowledge?
  • What is the difference between a spreadsheet and a database? List three differences between them.
A data type tells the database what functions can be performed with the data. The second important reason to define the data type is so that the proper amount of storage space is allocated for the data.
  • What is the difference between data, information, and knowledge?
  • What is the difference between a spreadsheet and a database? List three differences between them.
  • Why is it important to define the data type of a field when designing a relational database?
  • What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?
Metadata is data about data. It refers to the data used to describe other data, such as the length of a song in iTunes, which describes the music file.
  • What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?
  • What is metadata?
  • What is data mining?
  • What is the difference between data, information, and knowledge?
Data mining is the process of analyzing data to find previously unknown trends, patterns, and associations in order to make decisions.
  • What is the difference between data, information, and knowledge?
  • What is the difference between a spreadsheet and a database? List three differences between them.
  • What is data mining?
  • What is metadata?
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0