Database Processing: Fundamentals, Design, and Implementation, Global Edition, 14th edition

Published by Pearson (December 11, 2015) © 2016
  • David M. Kroenke
  • David J. Auer

Title overview

For undergraduate database management courses.

Get Students Straight to the Point of Database Processing

Database Processing: Fundamentals, Design, and Implementation reflects a new teaching and professional workplace environment and method that gets students straight to the point with its thorough and modern presentation of database processing fundamentals.

The Fourteenth Edition has been thoroughly updated to reflect the latest software.

Hallmark features of this title

  • Early Introduction of SQL. This text provides an early introduction to SQL data manipulation language (DML) SELECT statements. By presenting SQL SELECT statements in Chapter 2, students learn early in the class how to query data and obtain results, seeing firsthand how database technology will be useful to them. The discussion of SQL data definition language (DDL) and additional DML statements can be found in Chapters 7 and 8.
  • Online Appendices. Online appendices cover several topics, including “Getting Started with MySQL Workbench Data Modeling Tools.”
  • An independent Case Question set (in each chapter). The Case Question sets are problem sets that generally do not require the student to have completed work on the same case in a previous chapter (there is one intentional exception that ties data modeling and database design together). Although in some instances the same basic named case may be used in different chapters, each instance is still completely independent of any other instance.
  • Microsoft Office 2013. This book references Microsoft Office 2013 products (e.g., Microsoft Excel, Access, etc.).

Spiral approach to database design. Rather than teach database design once from the data models, this text gives professors a significant pedagogical opportunity to teach database design three times—once from each of these three sources:

  • The need to integrate existing data from spreadsheets, data files, and database extracts.
  • The need to development of new information systems projects.
  • The need to redesign an existing database to adapt to changing requirements.

New to this Edition

  • NEW! Material on big data and the evolving NoSQL movement from Chapter 12 has been expanded upon in a new Appendix K. New material on virtualization and cloud computing is also included in Chapter 12.
  • NEW! The SQL topics of UNION, INTERSECTION, and EXCEPT in Chapter 2 have been reorganized and expanded to provide a more concise presentation of SQL queries, so that nearly all SQL query topics are covered in one chapter (the exception is correlated subqueries, which are still reserved for Chapter 8).
  • NEW! Microsoft SQL Server 2014. Although most of the topics covered are backward compatible with Microsoft SQL Server 2012 and Microsoft SQL Server 2008 R2 Express edition, all material in the book now uses SQL Server 2014 in conjunction with Office 2013, exclusively.
  • NEW! Oracle Database 12c and Oracle Database Express Edition 11g Release 2. The new edition has been updated to include Oracle Database 12c and Oracle Database Express Edition 11g Release 2, the preferred Oracle Database product for use on personal computers. The current version of the Oracle SQL Developer GUI tool provides a common interface to both versions of Oracle Database, and detailed examples of how to use it are provided.
  • NEW! Microsoft Windows Server 2012 R2 and Windows 8.1. The new edition has been updated with discussion and illustration of Microsoft Windows Server 2012 R2 as the server operating system and Windows 8.1 as the workstation operating system. Windows 7 material has been retained where appropriate, and in some places the authors present both the Windows 7 and Window 8.1 versions of operations and utilities.

Key features

What is a VitalSource eTextbook?

The full text downloaded to your computer.

With VitalSource eTextbooks you can:

  • search for key concepts, words and phrases
  • make highlights and notes as you study
  • share your notes with friends

eTextbooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you'll gain instant access.

Table of contents

  1. 1. Introduction
  2. 2. Introduction to Structured Query Language
  3. 3.The Relational Model and Normalization
  4. 4. Database Design Using Normalization
  5. 5. Data Modeling and the Entity-Relationship Model
  6. 6. Transforming Data Models in Database Designs
  7. 7.SQL for Database Construction and Application Processing
  8. 8. Database Redesign
  9. 9. Managing Multiuser Databases
  10. 10.Managing Databases with SQL Server 2014, Oracle Database 12c, and MySQL 5.7
  11. 11. The Web Server Environment
  12. 12. Big Data, Data Warehouses, and Business Intelligence Systems

Author bios

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.

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.

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 counselling psychology. He served as a commissioned officer in the US Air Force, and he has also worked as an organisational development specialist and therapist for an employee assistance program (EAP).

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