Database Concepts, 10th edition

Published by Pearson (December 31, 2022) © 2023
  • David M. Kroenke
  • David J. Auer
  • Scott L. Vandenberg
  • Robert C. Yoder

Title overview

For courses in database management.

Hands-on exploration of database fundamentals

Database Concepts helps students create and manage small databases. Designed to work with your preferred software, this flexible text focuses on database concepts (not the features of any particular product). Students practice working with 3 complete sample databases that run through portions of the text; while 3 ongoing projects challenge them to apply new learning to real business situations.

The 10th Edition emphasizes the cloud's essential role in database concepts, beginning with new Chapter 1 content that places the cloud in proper context. Coverage is up-to-date with Microsoft Office 365 and Windows 11.

Hallmark features of this title

  • Critical thinking projects present illustrative cases and require that students consider how to manage the data for 3 different kinds of businesses.
  • Case questions prompt students to apply data and data management to real-world cases.
  • Review questions and exercises are included at the end of each chapter.
  • A companion website offers instructor resources, student materials, updates between editions, and easy access to the text's 3 Online Extensions:
    • Extension A introduces MySQL Community Server 8.0 and the MySQL Workbench.
    • Extension B provides coverage of advanced SQL topics, such as the SQL ALTER TABLE statement, SQL set operators (e.g., UNION), SQL views, and SQL/Persistent Stored Modules (SQL/PSM); and Extension C describes RFM reporting in detail.

New and updated features of this title

  • NEW: Emphasizes the cloud's essential role in database concepts, beginning in Ch. 1 with a thorough introduction to the cloud environment and its underlying technology (e.g., virtualization) which places the text in proper context.
  • EXPANDED: Coverage integrates the cloud environment as part of the database administration process, including basic concepts of database performance in the cloud and decisions, costs and trade-offs involved in cloud database deployment. Coverage of cloud-related topics, such as Big Data, data mining and NoSQL document databases is included.
  • UPDATED: Reflects Microsoft 365, with Access for Microsoft 365 (shown running on Microsoft Windows 11) as the basic software used. Screenshots and examples reflect the latest possible releases of Microsoft 365 (Office 2021), MySQL, Microsoft Azure and ArangoDB.
  • REVISED: Reflects the evolution of DBMSs to their current state, including data models and modes of access to data, such as virtualization.
  • REVISED: Reflects the highest standards of DEI (diversity, equity and inclusion) throughout with updated examples and figures that more fully represent a global readership.
  • REVISED: Updates to all step-by-step instructions conform to Pearson's accessibility standards, ensuring the text supports the broadest possible audience.

Key features

Features of Pearson+ eTextbook for the 10th Edition

  • UPDATED: Videos demonstrating many tasks described in the “Working with Microsoft Access” and “Working with MySQL” sections of the book (many of which have been updated) are available online to e-textbook users.
  • NEW: Videos on creating and using relational and NoSQL databases in the cloud are now available to users of the e-textbook. These involve Microsoft Azure, Oracle Cloud and ArangoDB's Oasis cloud platform.

Table of contents

PART 1: DATABASE FUNDAMENTALS

  1. Getting Started
  2. The Relational Model
  3. Structured Query Language

PART 2: DATABASE DESIGN

  1. Data Modeling and the Entity-Relationship Model
  2. Database Design

PART 3: DATABASE MANAGEMENT

  1. Database Administration and the Cloud
  2. Business Intelligence Systems, Data Warehouses, and Big Data

Glossary

Photo Index

ONLINE EXTENSIONS

  1. Working with MySQL
  2. Advanced SQL
  3. Advanced Business Intelligence, Nonrelational Databases, and the Cloud

Author bios

About our authors

David Kroenke has many years of teaching experience at Colorado State University, Seattle University, and the University of Washington. He has led dozens of seminars for college professors on the teaching of information systems and technology; in 1991, the International Association of Information Systems named him Computer Educator of the Year. In 2009, David was named Educator of the Year by the Association of Information Technology Professionals-Education Special Interest Group (AITP-EDSIG).

David worked for the US Air Force and Boeing Computer Services. He was a principal in the startup of three companies, serving as the vice president of product marketing and development for the Microrim Corporation and as chief of database technologies for Wall Data, Inc. He is the father of the semantic object data model. David's consulting clients have included IBM®, Microsoft®, and Computer Sciences Corporations, as well as numerous smaller companies. Recently, David has focused on using information systems for teaching collaboration and teamwork.

His text Database Processing was first published in 1977 and remains a current, essential resource. David has authored and coauthored many other textbooks, including Database Concepts, Experiencing MIS, SharePoint for Students, Office 365 in Business, and Processes, Systems, and Information: An Introduction to MIS.

David J. Auer is a senior instructor emeritus at the College of Business (CBE) of Western Washington University in Bellingham, WA. He served as Director of Information Systems and Technology Services at CBE from 1994 to 2014 and taught in CBE's Department of Decision Sciences from 1981 to 2015. Auer has taught CBE courses in quantitative methods, production and operations management, statistics, finance, and management information systems. Besides managing CBE's computer, network, and other technology resources, he also teaches management information systems courses. He has taught the principles of management information systems and business database development courses, and he was responsible for developing CBE's network infrastructure courses, including Computer Hardware and Operating Systems, Telecommunications, and Network Administration.

Auer has coauthored several MIS-related textbooks, including Database Processing: Fundamentals, Design, and Implementation, and Database Concepts. He holds a bachelor's degree in English literature from the University of Washington, and three degrees from Western Washington University — a bachelor's degree in mathematics and economics, a master's degree in economics, and a master's degree in counseling psychology. He served as a commissioned officer in the US Air Force, and he has also worked as an organizational development specialist and therapist for an employee assistance program (EAP). Auer and his wife, Donna, live in Bellingham, Washington. He has two children and four grandchildren.

Scott L. Vandenberg has been on the Computer Science faculty at Siena College since 1993, where he regularly teaches three different database courses at several levels to both computer science and business majors. Prior to arriving at Siena, he taught undergraduate and graduate courses in database systems at the University of Massachusetts–Amherst. Since arriving at Siena, he has also taught graduate and undergraduate database courses at the University of Washington–Seattle. He has developed five different database courses over this time. His other teaching experience includes courses in introductory computer science, introductory programming, data structures, and management information systems, as well as three years teaching Siena's required interdisciplinary freshman writing course.

Vandenberg's recent research publications are mainly in the areas of computer science education and data science applications, with earlier work on query optimization and algebraic query languages. He holds a bachelor's degree in mathematics and computer science from Cornell University and a master's degree and a PhD in computer science from the University of Wisconsin–Madison. Medieval history and playing hockey are two things that can tear him away from a database. Vandenberg lives in Averill Park, NY, with his wife, Kristin, and two children.

Robert C. Yoder began his professional career at the University at Albany as a systems programmer managing mainframes and Unix servers. He has two years of research experience working on 3-D solid modeling systems. Robert holds BS and MS degrees in computer science and a PhD in information science, all from the University at Albany. Yoder joined the Computer Science department at Siena College in 2001 and teaches business database, management information systems, geographic information systems, data structures, networks, and operating systems courses. Yoder lives in Niskayuna, NY, with his wife, Diane, and two children, and enjoys traveling, hiking, and walking his dog.

Loading...Loading...Loading...