Ch. 4 Flashcards

1
Q

What is data?

A

Raw bits and pieces of information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is quantitative?

A

Numeric

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is qualitative?

A

Descriptive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is information?

A

Is when data is given context and is more specific

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is knowledge?

A

Developed when information has been aggregated and analyzed to make decisions, set policies, and spark innovation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is wisdom?

A

The combination of knowledge and experience and may take years to develop

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are databases?

A

Organized collection of related information to generate knowledge for decision making purposes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is relational database?

A

Data is organized into one or more tables such as Microsoft Access. Relational databases use Microsoft Access installed on one machine with one use access at a time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are tables?

A

A collection of fields

Ex. Student ID, course ID, grade earned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a record?

A

An instance in the table Ex. your specific information in the table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Design is a critical first step in creating a database. What things should you recognize in creating this design?

A
  • Understand the goal and how the database will be used
  • Identify the data needed as part of accomplishing this goal
  • Identify how the data is related to each other
  • Identify tables and fields to organize the data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is text? (a field in a database)

A

Non-numeric data less than 256 characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a number? (a field in a database)

A

Numeric data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is yes/no? (a field in a database)

A

Stores 0 for no or false and 1 for yes or true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is date/time? (a field in a database)

A

Number data type that can be interpreted as a number or a time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is currency? (a field in a database)

A

Monetary data

17
Q

Paragraph text? (a field in a database)

A

Stores text longer than 256 characters

18
Q

What is object? (a field in a database)

A

Data that can’t be typed such as a picture or music file

19
Q

Whats is Structured Query Language (SQL)?

A

A tool/language that helps extract information from the database for analysis purposes and is considered a database report

20
Q

What is hierarchical database?

A

Parent/child relationship between data

21
Q

What is document-centric database?

A

Places data into documents that can be manipulated

22
Q

What is NoSQL database?

A

Usually multiple machines and, in some cases, machines in multiple data centers

23
Q

What is database management systems (DBMS)?

A

An application that allows data to be entered, modified and deleted. It can also be read and reported. It has a user friendly interface to design the database

24
Q

What is enterprise database?

A

A database that contains data that is shared by the users of an organization, generally across departments and/or geographic regions. (Serves the entire organization)

25
Q

What is a data warehouse?

A
  • Consists of extracts from one or more of the organization’s databases
  • Allows the data to be copied and stored for analysis and needs to be refreshed as the data changes
  • Data is time-stamped when extracted and allows comparisons between different time periods
  • Data is standardized
26
Q

What are data marts?

A

Smaller subsets of data warehouses for specific business problems

27
Q

What is data mining?

A

Automated process of analyzing data to find previously unknown trends, patterns, and associations and to make better business decisions.

28
Q

What is business intelligence?

A

Collecting and analyzing information to increase their competitive advantage.

29
Q

What is business analytics?

A

Uses internal company data to improve business processes and practices

30
Q

What is knowledge management (KM)?

A
  • The process of formalizing the capture, indexing, and storing of knowledge.
  • Companies and individuals accumulate knowledge.