Database Concepts
10th Edition
David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
Instructor’s Manual
Prepared by Scott L. Vandenberg
Chapter One
Getting Started
,Instructor’s Manual to accompany:
Database Concepts (10th Edition)
, David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder
© 2024, 2020, 2017, 2015, 2013, 2011, 2010, 2008 Pearson Education, Inc.
CHAPTER OBJECTIVES
• Understand the importance of databases today.
• Understand why and how databases are used.
• Describe the components of a database system.
• Understand the difference between personal and enterprise-class database systems.
• Describe Web database applications.
• Describe data warehouses and business intelligence (BI) systems.
• Define Big Data.
• Understand the basics of cloud computing and cloud-based databases.
• Learn to use Microsoft Access to create and implement databases.
• Gain practice with databases by working with Case Studies.
• Gain practice with databases by working with ongoing Projects.
CHAPTER ERRATA
These are the known errors at this time. Any errors that are discovered in the future will
be reported and corrected in the online DBC e10 Errata document or in this file, which
will be available at http://www.pearson.com/kroenke.
WORKING WITH MICROSOFT ACCESS
Solutions to the Working with Microsoft Access exercises may be found in Solutions to
all Sections: Working with Microsoft Access, which is a separate document within the
Instructor’s Manual.
WARNING: CHANGES IN GRAPHICAL USER INTERFACES
You and your students need to be aware that changes in graphical user interface (GUI)
designs can occur without warning, and therefore you may see slightly different user
interface colors, icons, text, and item placement than shown in the figures in this book or
instructor manual.
Until recently, changes to GUI designs only occurred when a new major version of an
application was released. For example, after Microsoft Office 2010 was released, we
would not expect to see changes to the GUI for Microsoft Excel, Microsoft Access,
Microsoft Word, Microsoft PowerPoint, and other associated Microsoft Office
applications until the next major version, Microsoft Office 2013, was released. The GUI
was stable, and screenshots of the Microsoft Office products for books using Office 2010
would be accurate.
Now, however, we have entered an era of continuously updating revisions within major
versions. The next product update, automatically scheduled and installed on your
, computer, may, without warning, change the GUI. While we have seen this happen with
MySQL, and particularly with the MySQL Workbench, we are now seeing it happen with
Microsoft 365 and Microsoft Office 2021 (which is a standardized subset of Microsoft
365).
Of particular note with Microsoft 365 and Microsoft Office 2021 is the Microsoft Office
“visual refresh”. This is a change to the interface to make it conform more closely to
Windows 11 design standards. The main differences are cosmetic, including rounded
corners and different placement of some items from the Quick Access Toolbar.
However, this visual refresh is independent of versioning: You may have a later version
than someone with the visual refresh, yet not yet have it yourself. Fortunately, for the
purposes of learning Microsoft Access, these changes are not substantive, but you and
your students should be aware of them.
Note that these changes do not affect the basic functionality of the Office
programs. The steps to use Microsoft Access and Microsoft Excel described in
Database Concepts 10th edition are still largely the same!
However, you and your students need to be aware that what you see in Microsoft
Access and Microsoft Excel may differ somewhat from what we captured in the screen
shots used in this book. And you should now expect future changes in the Microsoft
Office GUI, and in the GUIs for other products (MySQL Workbench is an example), to
occur without warning. It is simply a consequence of the new “constant update” system
of delivering software as well as the subscription-based (versus locally-installed and
license-based) nature of software. This is especially true of cloud-based software, which
often changes without warning.
We recommend that you cover this topic with your students!
TEACHING SUGGESTIONS
• The Art Course database discussed in Chapter One is a good database to use for an
in-class demo of the concepts in this chapter. Note that this 10th edition emphasizes
Access and MySQL, with less support for Microsoft SQL Server and Oracle
Database Express Edition. See the list, data, and database files supplied, and use
the following material:
• Microsoft Access 2021:
• DBC-e10-Art-Course-Database-CH01.accdb
• MySQL 8.0:
• DBC-e10-MySQL-Art-Course-Database-Create-Tables.sql
• DBC-e10-MySQL-Art-Course-Database-Insert-Data.sql
• DBC-e10-MySQL-Art-Course-Database-SQL-Queries-CH01.sql
• Introduce the course by explaining that database processing is at the heart of all
applications today. Use the material in the section “The Importance of Databases
