Data and Databases - Study Guide
Data and Databases - Study Guide

Data and Databases - Study Guide

Source: Pressbooks

Student Price: FREE

A study guide on data and databases in a business context.

This content is licensed under the Creative Commons Attribution 3.0 Unported License.

​Data and Databases - Study Guide

​Learning Objectives

  • Describe the differences between data, information, and knowledge
  • Define the term database and identify the steps to creating one
  • Describe the role of a database management system 
  • Describe the characteristics of a data warehouse 
  • Define data mining and describe its role in an organization
D1

What is the difference between data, information, and knowledge?


D2

Explain in your own words how the data component relates to the hardware and software components of information systems.


D3

What is the difference between quantitative data and qualitative data? In what situations could the number 42 be considered qualitative data?


D4

What are the characteristics of a relational database?


D5

When would using a personal DBMS make sense?


D6

What is the difference between a spreadsheet and a database? List three differences between them.


D7

Describe what the term normalization means.


D8

Why is it important to define the data type of a field when designing a relational database?


D9

Name a database you interact with frequently. What would some of the field names be?


D10

What is metadata?


D11

Name three advantages of using a data warehouse.


D12

What is data mining?


D13

Do some original research and find two examples of data mining. Summarize each example and then write about what the two examples have in common.


D14

Conduct some independent research on the process of business intelligence. Using at least two scholarly or practitioner sources, write a two-page paper giving examples of how business intelligence is being used.


D15

Conduct some independent research on the latest technologies being used for knowledge management. Using at least two scholarly or practitioner sources, write a two-page paper giving examples of software applications or new technologies being used in this field.

​Information Systems for Business and Beyond © 2014 David T. Bourgeois, is licensed under a Creative Commons Attribution (CC BY) license made possible by funding from The Saylor Foundation’s Open Textbook Challenge.

​​Creative Commons License