Complete Test Bank for Database Systems Design, Implementation & Management (13th Edition by Coronel & Morris)

Test Bank for Database Systems Design Implementation and
Management 13th Edition

by Carlos Coronel Steven Morris.

All Chapters (1-16) |Q&A Verified | Graded A+

ISBN 9781337627900




~1~

,TABLE OF CONTENTS
Chapter 1: Database Systems .................................................................................... 3
Chapter 2: Data Models ........................................................................................... 26
Chapter 3: The Relational Database Model ............................................................ 49
Chapter 4: Entity Relationship (ER) Modeling ........................................................ 72
Chapter 5: Advanced Data Modeling ....................................................................... 95
Chapter 6: Normalization of Database Tables ...................................................... 120
Chapter 7: Introduction to Structured Query Language (SQL) ............................. 144
Chapter 8: Advanced SQL ...................................................................................... 168
Chapter 9: Database Design .................................................................................. 191




~2~

,Chapter 1: Database Systems
True / False


1. Data and information are essentially the same thing.
a. True
b. False
CORRECT ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information


2. Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
CORRECT ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information


3. Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
CORRECT ANSWER: False
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information


4. When data are entered into a form and saved, they are placed in the underlying
database as knowledge.
a. True
b. False
~3~

, CORRECT ANSWER: False
DIFFICULTY: Moderate
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information


5. Data constitute the building blocks of information.
a. True
b. False
CORRECT ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-2 Data versus Information
LEARNING OBJECTIVES: 01.01 - Define the difference between data and information


6. Metadata describe the data characteristics and the set of relationships that links
the data found within the database.
a. True
b. False




CORRECT ANSWER: True
DIFFICULTY: Easy
REFERENCES: 1-3 Introducing the Database
LEARNING OBJECTIVES: 01.02 - Describe what a database is, the various types of
databases, and why they are valuable assets for decision making


7. The only way to access the data in a database is through the DBMS.
a. True
b. False
CORRECT ANSWER: True
DIFFICULTY: Moderate
REFERENCES: 1-3a Role and Advantages of the DBMS

~4~