SOLUTIONS MANUAL
** All Chapters included
** Review Quiz
** Answers to Review Questions
** Problems Solutions
,Table of Contents are given below
Chapter 1. Database Systems
Chapter 2. Data Models
Chapter 3. The Relational Database Model
Chapter 4. Introduction to Structured Query Language (SQL)
Chapter 5. Advanced SQL
Chapter 6. Entity Relationship (ER) Modeling
Chapter 7. Advanced Data Modeling
Chapter 8. Normalization of Database Tables
Chapter 9. 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 and NoSQL
Chapter 15. Database Connectivity and Web Technologies
Chapter 16. Database Administration and Security
,Solution and Answer Guide
CORONEL /MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT 15E ©27,
9798214410241; CHAPTER 1: DATABASE SYSTEMS
TABLE OF CONTENTS
Review Quiz .......................................................................................................................................1
Choose the correct answer ....................................................................................................................... 1
Answers to Review Questions ............................................................................................................4
Problems Solutions .......................................................................................................................... 13
REVIEW QUIZ
CHOOSE THE CORRECT ANSWER
1. Referencing the CUSTOMER table shown in Figure R1.1, the fact that there are 9 columns in the
CUSTOMER table is an example of what?
FIGURE R1-1 CUSTOMER table
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: b
1
, 2. Referencing the CUSTOMER table shown in Figure R1.1, the fact that customer Alfred A. Ramas has the
phone number 615-844-2573 is an example of what?
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: a
3. Referencing the CUSTOMER table shown in Figure R1.1, the fact that the customer phone number column
stores values as text data, not numeric data, is an example of what?
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: b
4. Which of the following is not an example of a DBMS?
a) Oracle
b) SQL Server
c) Java
d) MySQL
Answer: c
5. If the database programmer changes the structure of a table, these changes are reflected by the DBMS in
the metadata. This is an example of which DBMS function?
a) Data integrity management
b) Security management
c) Data dictionary management
d) Data transformation and presentation
2
** All Chapters included
** Review Quiz
** Answers to Review Questions
** Problems Solutions
,Table of Contents are given below
Chapter 1. Database Systems
Chapter 2. Data Models
Chapter 3. The Relational Database Model
Chapter 4. Introduction to Structured Query Language (SQL)
Chapter 5. Advanced SQL
Chapter 6. Entity Relationship (ER) Modeling
Chapter 7. Advanced Data Modeling
Chapter 8. Normalization of Database Tables
Chapter 9. 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 and NoSQL
Chapter 15. Database Connectivity and Web Technologies
Chapter 16. Database Administration and Security
,Solution and Answer Guide
CORONEL /MORRIS, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION AND MANAGEMENT 15E ©27,
9798214410241; CHAPTER 1: DATABASE SYSTEMS
TABLE OF CONTENTS
Review Quiz .......................................................................................................................................1
Choose the correct answer ....................................................................................................................... 1
Answers to Review Questions ............................................................................................................4
Problems Solutions .......................................................................................................................... 13
REVIEW QUIZ
CHOOSE THE CORRECT ANSWER
1. Referencing the CUSTOMER table shown in Figure R1.1, the fact that there are 9 columns in the
CUSTOMER table is an example of what?
FIGURE R1-1 CUSTOMER table
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: b
1
, 2. Referencing the CUSTOMER table shown in Figure R1.1, the fact that customer Alfred A. Ramas has the
phone number 615-844-2573 is an example of what?
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: a
3. Referencing the CUSTOMER table shown in Figure R1.1, the fact that the customer phone number column
stores values as text data, not numeric data, is an example of what?
a) End user data
b) Metadata
c) Management control data
d) Information
Answer: b
4. Which of the following is not an example of a DBMS?
a) Oracle
b) SQL Server
c) Java
d) MySQL
Answer: c
5. If the database programmer changes the structure of a table, these changes are reflected by the DBMS in
the metadata. This is an example of which DBMS function?
a) Data integrity management
b) Security management
c) Data dictionary management
d) Data transformation and presentation
2
