,TABLE OF CONTENTS
Chapter 01: Database Systems
Chapter 02: Data Models
Chapter 03: The Relational Database Model
Chapter 04: Entity Relationship (ER) Modeling
Chapter 05: Advanced Data Modeling
Chapter 06: Normalization of Database Tables
Chapter 07: Introduction to Structured Query Language (SQL)
Chapter 08: Advanced SQL
Chapter 09: Database Design
Chapter 10: Transaction Management and Concurrency Control
Chapter 11: Database Performance Tuning and Query Optimization
Chapter 12: Distributed Database Management Systems
Chapter 13: Business Intelligence and Data Warehouses
Chapter 14: Big Data Analytics and NoSQL
Chapter 15: Database Connectivity and Web Technologies
Chapter 16: Database Administration and Security
ScholarSource
,CHAPTER 01: DATABASE SYSTEMS
TRUE / FALSE
1. Data and information are essentially the same thing.
a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
RATIONALE: Data is raw, unprocessed facts, whereas information is data that has been
processed and given meaning. They are fundamentally different concepts.
2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
RATIONALE: Even a simple action like sorting or organizing data qualifies as a form of
data processing. This organization can reveal underlying patterns, transforming raw data
into meaningful information.
3. Data is the result of processing raw facts to reveal its meaning.
ScholarSource
, a. True
b. False
ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
RATIONALE: The statement reverses the correct definition. Information is the result of
processing raw data. Data itself is the unprocessed input.
4. When data are entered into a form and saved, they are placed in the underlying database
as knowledge.
a. True
b. False
ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information
RATIONALE: When data is saved to a database, it is stored as data. "Knowledge" is a
higher-level concept that involves applying information, experience, and context to make
decisions. The stored data is the building block, not knowledge itself.
5. Data constitute the building blocks of information.
a. True
b. False
ANSWER: True
ScholarSource