?? ??
EK ED
GE OV
ED PR
AP
M
?_
?_ IA
IA UV
UV ST
ST
, TABLE OF CONTENTS
Instructor's Manual: Database Processing: Fundamentals, Design,
and Implementation, 16th Edition
Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder
ST
??
PART 1: Getting Started
UV
EK
Chapter 1. Introduction
Chapter 2. Introduction to Structured Query Language
GE
IA
PART 2: Database Design
Chapter 3. The Relational Model and Normalization
Chapter 4. Database Design Using Normalization
?_
ED
Chapter 5. Data Modeling with the Entity-Relationship Model
Chapter 6. Transforming Data Models into Database Designs
AP
PART 3: Database Implementation
_M
Chapter 7. SQL for Database Construction and Application Processing
Chapter 8. Database Redesign
PR
PART 4: Enterprise Database Processing
A?
Chapter 9. Managing Enterprise Databases
OV
Chapter 10. Managing Databases with Microsoft SQL Server 2019, Oracle Database, MySQL
8.0, and ArangoDB
VI
Online 10A. Managing Databases with Microsoft SQL Server 2019
Online 10B. Managing Databases with Oracle Database
ED
U
Online 10C. Managing Databases with MySQL 8.0
Online 10D. Managing Document Databases with ArangoDB
ST
PART 5: Database Access Standards and Technology
?
Chapter 11. The Web Server Environment
?
Chapter 12. Data Warehouses, Business Intelligence Systems
Chapter 13. Big Data, NoSQL, and the Cloud
, Chapter 1 – Introduction
CHAPTER OBJECTIVES
To understand the importance of databases in Internet Web applications and
smartphone apps
To understand the nature and characteristics of databases
ST
??
To survey some important and interesting database applications
To gain a general understanding of tables and relationships
UV
To describe the components of a Microsoft Access database system and explain the
EK
functions they perform
To describe the components of an enterprise-class database system and explain the
functions they perform
To define the term database management system (DBMS) and describe the
GE
IA
functions of a DBMS
To define the term database and describe what is contained within the database
To define the term metadata and provide examples of metadata
?_
ED
To define and understand database design from existing data
To define and understand database design as new systems development
AP
To define and understand database redesign of an existing database
To understand the history and development of database processing
M
ERRATA
PR
?_
There are no known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the Online DBP e16 Errata document, which will be
available at http://www.pearsonhighered.com/kroenke .
IA
OV
TEACHING SUGGESTIONS
A basic knowledge of Microsoft Access is necessary for this chapter—particularly for
UV
the Project Questions at the end of the chapter. If your students need an introduction
to Microsoft Access, either teach or have them work through Appendix A – Getting
ED
Started with Microsoft Access 2019.
Introduce the course by explaining the basic characteristics of a database and that
database processing is the heart of all applications today, even for smartphones and
ST
tablets.
??
Use the Microsoft Access database shown in Figures 1-4 and 1-5 to discuss the
basic characteristics of a database. A copy of this database is available as the
database DBP-e16-IM-CH01-Student-Class-Grade.accdb, which is available in the
Page 1-3
, Chapter 1 – Introduction
Instructor’s Resource Center on the text’s Web site
(www.pearsonhighered.com/kroenke) if you want to use it in class.
Use the examples in the Database Examples section (Figure 1-7) to discuss the
types of database uses from single-user applications to complex e-commerce
applications. The demand for knowledgeable people (both users and technicians)
still exists. The knowledge gained in this course will be valuable at job-hunting time.
ST
Internet technology has tremendously amplified the need for database knowledge –
??
that technology can be used inside organizations as well as outside for e-commerce
applications. New Web 2.0 applications, including social media, have created a
strong demand for database developers.
UV
EK
Make sure students understand the difference between the components of a
Microsoft Access DBMS and the components of an enterprise-class DBMS such as
SQL Server 2019, Oracle Database XE, or MySQL 8.0. Use Figures 1-8, 1-9, 1-17,
and 1-19 which are also in the PowerPoint presentation for this chapter.
GE
Make sure students understand the difference between a database and the DBMS
IA
software that manages it.
The book is structured around the three types of database design. Be sure your
students understand these three types of design problems, and relate them to future
?_
chapters. You can use Figure 1-23 (also in the PowerPoint presentation) to illustrate
this part of your lecture. ED
This is a good place to start separating the concepts of design and the concepts of
implementation. The history of most students is that they spend about 10% of their
AP
time in design and 90% in implementation and testing (debugging). Now is the time
M
to convince them that about 75% of their time should be spent in database design
and 25% in implementation. History tells us that systems do not fail because of faulty
implementation, they fail because of poor design.
PR
Cover the section on What You Need to Learn to give your students a good
?_
perspective on the roles they may have in working with databases. Use Figure 1-29
(also in the PowerPoint presentation) to tie these roles to the content of the book,
emphasizing those chapters you will be teaching if you are not covering the entire
book.
IA
OV
Cover the section on A Brief History of Database Processing to help students
understand the historical context of today’s DBMSs.
UV
ED
ST
??
Page 1-4
EK ED
GE OV
ED PR
AP
M
?_
?_ IA
IA UV
UV ST
ST
, TABLE OF CONTENTS
Instructor's Manual: Database Processing: Fundamentals, Design,
and Implementation, 16th Edition
Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder
ST
??
PART 1: Getting Started
UV
EK
Chapter 1. Introduction
Chapter 2. Introduction to Structured Query Language
GE
IA
PART 2: Database Design
Chapter 3. The Relational Model and Normalization
Chapter 4. Database Design Using Normalization
?_
ED
Chapter 5. Data Modeling with the Entity-Relationship Model
Chapter 6. Transforming Data Models into Database Designs
AP
PART 3: Database Implementation
_M
Chapter 7. SQL for Database Construction and Application Processing
Chapter 8. Database Redesign
PR
PART 4: Enterprise Database Processing
A?
Chapter 9. Managing Enterprise Databases
OV
Chapter 10. Managing Databases with Microsoft SQL Server 2019, Oracle Database, MySQL
8.0, and ArangoDB
VI
Online 10A. Managing Databases with Microsoft SQL Server 2019
Online 10B. Managing Databases with Oracle Database
ED
U
Online 10C. Managing Databases with MySQL 8.0
Online 10D. Managing Document Databases with ArangoDB
ST
PART 5: Database Access Standards and Technology
?
Chapter 11. The Web Server Environment
?
Chapter 12. Data Warehouses, Business Intelligence Systems
Chapter 13. Big Data, NoSQL, and the Cloud
, Chapter 1 – Introduction
CHAPTER OBJECTIVES
To understand the importance of databases in Internet Web applications and
smartphone apps
To understand the nature and characteristics of databases
ST
??
To survey some important and interesting database applications
To gain a general understanding of tables and relationships
UV
To describe the components of a Microsoft Access database system and explain the
EK
functions they perform
To describe the components of an enterprise-class database system and explain the
functions they perform
To define the term database management system (DBMS) and describe the
GE
IA
functions of a DBMS
To define the term database and describe what is contained within the database
To define the term metadata and provide examples of metadata
?_
ED
To define and understand database design from existing data
To define and understand database design as new systems development
AP
To define and understand database redesign of an existing database
To understand the history and development of database processing
M
ERRATA
PR
?_
There are no known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the Online DBP e16 Errata document, which will be
available at http://www.pearsonhighered.com/kroenke .
IA
OV
TEACHING SUGGESTIONS
A basic knowledge of Microsoft Access is necessary for this chapter—particularly for
UV
the Project Questions at the end of the chapter. If your students need an introduction
to Microsoft Access, either teach or have them work through Appendix A – Getting
ED
Started with Microsoft Access 2019.
Introduce the course by explaining the basic characteristics of a database and that
database processing is the heart of all applications today, even for smartphones and
ST
tablets.
??
Use the Microsoft Access database shown in Figures 1-4 and 1-5 to discuss the
basic characteristics of a database. A copy of this database is available as the
database DBP-e16-IM-CH01-Student-Class-Grade.accdb, which is available in the
Page 1-3
, Chapter 1 – Introduction
Instructor’s Resource Center on the text’s Web site
(www.pearsonhighered.com/kroenke) if you want to use it in class.
Use the examples in the Database Examples section (Figure 1-7) to discuss the
types of database uses from single-user applications to complex e-commerce
applications. The demand for knowledgeable people (both users and technicians)
still exists. The knowledge gained in this course will be valuable at job-hunting time.
ST
Internet technology has tremendously amplified the need for database knowledge –
??
that technology can be used inside organizations as well as outside for e-commerce
applications. New Web 2.0 applications, including social media, have created a
strong demand for database developers.
UV
EK
Make sure students understand the difference between the components of a
Microsoft Access DBMS and the components of an enterprise-class DBMS such as
SQL Server 2019, Oracle Database XE, or MySQL 8.0. Use Figures 1-8, 1-9, 1-17,
and 1-19 which are also in the PowerPoint presentation for this chapter.
GE
Make sure students understand the difference between a database and the DBMS
IA
software that manages it.
The book is structured around the three types of database design. Be sure your
students understand these three types of design problems, and relate them to future
?_
chapters. You can use Figure 1-23 (also in the PowerPoint presentation) to illustrate
this part of your lecture. ED
This is a good place to start separating the concepts of design and the concepts of
implementation. The history of most students is that they spend about 10% of their
AP
time in design and 90% in implementation and testing (debugging). Now is the time
M
to convince them that about 75% of their time should be spent in database design
and 25% in implementation. History tells us that systems do not fail because of faulty
implementation, they fail because of poor design.
PR
Cover the section on What You Need to Learn to give your students a good
?_
perspective on the roles they may have in working with databases. Use Figure 1-29
(also in the PowerPoint presentation) to tie these roles to the content of the book,
emphasizing those chapters you will be teaching if you are not covering the entire
book.
IA
OV
Cover the section on A Brief History of Database Processing to help students
understand the historical context of today’s DBMSs.
UV
ED
ST
??
Page 1-4
