Instructor's Manual for Database Processing: Fundamentals, Design, and Implementation, 16th Edition (Kroenke, Auer, Vandenberg & Yoder, 2021) | All Chapters 1–13 Covered

?? ??
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