INSTRUCTOR MANUAL
Database Processing: Fundamentals, Design, and Implementation, 16th Edition
by David Kroenke, David Auer, Scott Vandenberg
TU
TO
R
G
U
R
U
, TABLE OF CONTENT
PART 1: Getting Started
Introduction
Introduction to Structured Query Language
PART 2: Database Design
The Relational Model and Normalization
Database Design Using Normalization
Data Modeling with the Entity-Relationship Model Transforming Data Models into Database
Designs
TU
Transforming Data Models into Database Designs
PART 3: Database Implementation
SQL for Database Construction and Application Processing Database Redesign
TO
Database Redesign
PART 4: Enterprise Database Processing
Managing Enterprise Databases
Managing Databases with Microsoft SQL Server 2019, Oracle Database, MySQL 8.0,
R
andArangoDB
Online 10A. Managing Databases with Microsoft SQL Server 2019
G
Online 10B. Managing Databases with Oracle Database
Online 10C. Managing Databases with MySQL 8.0
U
Online 10D. Managing Document Databases with ArangoDB
PART 5: Database Access Standards and Technology
R
The Web Server Environment
Data Warehouses, Business Intelligence Systems
U
Big Data, NoSQL, and the Cloud
, classmerit.com — The Marketplace to Buy and Sell Study Materials
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
• To survey some important and interesting database applications
• To gain a general understanding of tables and relationships
• To describe the components of a Microsoft Access database system and explain the
TU
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
functions of a DBMS
•
TO
To define the term database and describe what is contained within the database
• To define the term metadata and provide examples of metadata
• To define and understand database design from existing data
• To define and understand database design as new systems development
• To define and understand database redesign of an existing database
R
• To understand the history and development of database processing
❖ ERRATA
G
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 .
U
❖ TEACHING SUGGESTIONS
R
• A basic knowledge of Microsoft Access is necessary for this chapter—particularly for
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
U
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
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
Copyright
Downloaded © 2022 Pearson Education,
by: Inc. Want to earn $1,500
Distribution of this document is illegal extra per year?
, classmerit.com — The Marketplace to Buy and Sell Study Materials
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.
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.
TU
• 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.
• Make sure students understand the difference between a database and the DBMS
software that manages it.
TO
• 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.
• 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
time in design and 90% in implementation and testing (debugging). Now is the time
R
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.
G
• 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
U
book.
• Cover the section on A Brief History of Database Processing to help students
understand the historical context of today’s DBMSs.
R
U
Page 1-4
Copyright
Downloaded © 2022 Pearson Education,
by: Inc. Want to earn $1,500
Distribution of this document is illegal extra per year?
Database Processing: Fundamentals, Design, and Implementation, 16th Edition
by David Kroenke, David Auer, Scott Vandenberg
TU
TO
R
G
U
R
U
, TABLE OF CONTENT
PART 1: Getting Started
Introduction
Introduction to Structured Query Language
PART 2: Database Design
The Relational Model and Normalization
Database Design Using Normalization
Data Modeling with the Entity-Relationship Model Transforming Data Models into Database
Designs
TU
Transforming Data Models into Database Designs
PART 3: Database Implementation
SQL for Database Construction and Application Processing Database Redesign
TO
Database Redesign
PART 4: Enterprise Database Processing
Managing Enterprise Databases
Managing Databases with Microsoft SQL Server 2019, Oracle Database, MySQL 8.0,
R
andArangoDB
Online 10A. Managing Databases with Microsoft SQL Server 2019
G
Online 10B. Managing Databases with Oracle Database
Online 10C. Managing Databases with MySQL 8.0
U
Online 10D. Managing Document Databases with ArangoDB
PART 5: Database Access Standards and Technology
R
The Web Server Environment
Data Warehouses, Business Intelligence Systems
U
Big Data, NoSQL, and the Cloud
, classmerit.com — The Marketplace to Buy and Sell Study Materials
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
• To survey some important and interesting database applications
• To gain a general understanding of tables and relationships
• To describe the components of a Microsoft Access database system and explain the
TU
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
functions of a DBMS
•
TO
To define the term database and describe what is contained within the database
• To define the term metadata and provide examples of metadata
• To define and understand database design from existing data
• To define and understand database design as new systems development
• To define and understand database redesign of an existing database
R
• To understand the history and development of database processing
❖ ERRATA
G
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 .
U
❖ TEACHING SUGGESTIONS
R
• A basic knowledge of Microsoft Access is necessary for this chapter—particularly for
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
U
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
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
Copyright
Downloaded © 2022 Pearson Education,
by: Inc. Want to earn $1,500
Distribution of this document is illegal extra per year?
, classmerit.com — The Marketplace to Buy and Sell Study Materials
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.
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.
TU
• 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.
• Make sure students understand the difference between a database and the DBMS
software that manages it.
TO
• 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.
• 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
time in design and 90% in implementation and testing (debugging). Now is the time
R
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.
G
• 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
U
book.
• Cover the section on A Brief History of Database Processing to help students
understand the historical context of today’s DBMSs.
R
U
Page 1-4
Copyright
Downloaded © 2022 Pearson Education,
by: Inc. Want to earn $1,500
Distribution of this document is illegal extra per year?
