Chapters

Question 1

What is Data?

Answer 1

Raw facts that have not yet been processed.

Question 2

What is Information?

Answer 2

The result of processing raw data to reveal its meaning.

Question 3

What is Knowledge?

Answer 3

The body of information and facts about a specific subject.

Question 4

What are the key characteristics of Knowledge?

Answer 4

Implies familiarity, awareness, and understanding of information as it applies to an environment. New knowledge can be derived from old knowledge.

Question 5

What constitutes the building blocks of information?

Answer 5

Data.

Question 6

How is Information produced?

Answer 6

By processing data.

Question 7

What is the key to good decision-making?

Answer 7

Accurate, relevant, and timely information.

Question 8

What is Data Management?

Answer 8

A process that focuses on data collection, storage, and retrieval.

Question 9

What is a Database?

Answer 9

A shared, integrated computer structure that houses a collection of related data.

Question 10

What are the two types of data in a Database?

Answer 10

End-user Data (raw facts) and Metadata (data about data characteristics and relationships).

Question 11

What is a Database Management System (DBMS)?

Answer 11

The collection of programs that manages the database structure and controls access to the data stored in the database.

Question 12

What role does a DBMS serve?

Answer 12

It serves as the intermediary between the user and the database.

Question 13

What are some advantages of using a DBMS?

Answer 13

Improved data sharing, security, integration, minimized data inconsistency, improved access, decision making, and increased end-user productivity.

Question 14

What is Data Inconsistency?

Answer 14

A condition in which different versions of the same data yield different results.

Question 15

What is a Query?

Answer 15

A specific request issued to the DBMS for data manipulation.

Question 16

What is an Ad Hoc Query?

Answer 16

An unplanned and flexible request for specific information from a database.

Question 17

What is a Query Result Set?

Answer 17

The collection of data rows returned by a query.

Question 18

What is Data Quality?

Answer 18

A comprehensive approach to ensuring the accuracy, validity, and timeliness of data.

Question 19

What is a Single-User Database?

Answer 19

A database that supports only one user at a time.

Question 20

What is a Desktop Database?

Answer 20

A single-user database that runs on a personal computer.

Question 21

What is a Multiuser Database?

Answer 21

A database that supports multiple concurrent users.

Question 22

What is an Enterprise Database?

Answer 22

The overall company data representation, which provides support for present and expected future needs.

Question 23

What is a Cloud Database?

Answer 23

A database that is created and maintained using cloud services.

Question 24

What is an Operational Database?

Answer 24

A database designed primarily to support a company’s day-to-day operations.

Question 25

What is an Analytical Database?

Answer 25

A database focused primarily on storing historical data and business metrics used for decision-making.

Question 26

What is Unstructured Data?

Answer 26

Data that exists in its original, raw state.

Question 27

What is Structured Data?

Answer 27

Data that has been formatted to facilitate storage, use, and information generation.

Question 28

What is Extensible Markup Language (XML)?

Answer 28

A metalanguage used to represent and manipulate data elements.

Question 29

What is a NoSQL Database?

Answer 29

A new generation of DBMS that is not based on the traditional relational database model.

Question 30

What is Data Redundancy?

Answer 30

Exists when the same data is stored unnecessarily at different places.

Question 31

What are the major parts of a Database System?

Answer 31

Hardware, Software, People, Procedures, and Data.

Question 32

What is Data Dictionary Management?

Answer 32

Stores definitions of the data elements and their relationships in a data dictionary.

Question 33

What is Data Manipulation Language (DML)?

Answer 33

The set of commands that allows an end user to manipulate the data in the database.

Question 34

What is Data Definition Language (DDL)?

Answer 34

The language that allows a database administrator to define the database structure.

Question 35

What is a Relational Database Management System (RDBMS)?

Answer 35

A collection of programs that manages a relational database.

Question 36

What is an Entity Relationship Model (ERM)?

Answer 36

A data model that describes relationships among entities.

Question 37

What is an Entity Relationship Diagram (ERD)?

Answer 37

A diagram that depicts an entity-relationship model’s entities, attributes, and relations.

Question 38

What is Connectivity in data models?

Answer 38

The type of relationship between entities, classified as 1:1, 1:M, and M:N.