Database Processing: Fundamentals, Design, and Implementation, Global Edition, 14th edition
Published by Pearson (December 11, 2015) © 2016
- David M. Kroenke Western Washington Universtiy
- David J. Auer Western Washington University
eTextbook
- Easy-to-use search and navigation
- Add notes and highlights
- Search by keyword or page
- A print text (hardcover or paperback)
- Free shipping
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.
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.
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.
The Latest Software. This edition has been updated to reflect the latest database software, including Microsoft Access 2013, Microsoft SQL Server 2014, Oracle Database 12g (and alternately Oracle Database Express Edition 11g Release 2), and MySQL 5.6.
Online Appendices. Online appendices cover several topics, including “Getting Started with MySQL Workbench Data Modeling Tools.”
NEW! Online Chapters on SQL Server 2014 (Chapter 10A), Oracle Database (Chapter 10B), and MySQL 5.6 (Chapter 10C) now have a section on importing data from Microsoft Excel 2013 worksheets.
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.
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.
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).
A discussion of user-defined functions has been added to the coverage of SQL Persistent Stored Modules (SQL/PSM) in Chapter 7, Chapter 10, Chapter 10A, Chapter 10B, and Chapter 10C.
Microsoft Office 2013. This book references Microsoft Office 2013 products (e.g., Microsoft Excel, Access, etc.).
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
Online Chapters on SQL Server 2014 (Chapter 10A), Oracle Database (Chapter 10B), and MySQL 5.6 (Chapter 10C) now have a section on importing data from Microsoft Excel 2013 worksheets.
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.
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).
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.
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.
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.
Server virtualization, cloud computing, Big Data, and the Not only SQL movement. Coverage includes server virtualization, cloud computing, Big Data, and the Not only SQL movement.
UPDATED! Online Appendix I, "Getting Started with Web Servers, PHP and the NetBeans IDE" has been updated to include NetBeans IDE instead of the Eclipse IDE.
This new material provides a simplified (but still detailed) introduction to the installation and use of the Microsoft IIS Web server, PHP, the Java JDK, and the NetBeans IDE used for Web database application development as discussed in Chapter 11.
The organization and topic selection of the Fourteenth Edition are also designed to:
- Use a consistent, generic Information Engineering (IE) Crow’s Foot E-R diagram notation for data modeling and database design.
- Provide a detailed discussion of specific normal forms within a discussion of normalization that focuses on pragmatic normalization techniques.
- Create Web database applications based on widely used Web development technology.
- Provide an introduction to business intelligence (BI) systems.
- Discuss the dimensional database concepts used in database designs for data warehouses and online analytical processing (OLAP).
The full text downloaded to your computer
With eBooks you can:
- search for key concepts, words and phrases
- make highlights and notes as you study
- share your notes with friends
eBooks 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 to this eBook.
Part I: Getting Started
1. Introduction
2. Introduction to Structured Query Language
Part II: Database Design
3.The Relational Model and Normalization
4. Database Design Using Normalization
5. Data Modeling and the Entity-Relationship Model
6. Transforming Data Models in Database Designs
Part III: Database Implementation
7.SQL for Database Construction and Application Processing
8. Database Redesign
Part IV: Multiuser Database Processing
9. Managing Multiuser Databases
10.Managing Databases with SQL Server 2014, Oracle Database 12c, and MySQL 5.7
Online Chapter: 10A.Managing Databases with SQL Server 2014
Online Chapter: 10B.Managing Databases with Oracle 12c
Online Chapter: 10C.Managing Databases with MySQL 5.7
Part V: Database Access Standards
11. The Web Server Environment
12. Big Data, Data Warehouses, and Business Intelligence Systems
Online Appendix A. Getting Started with Microsoft Access 2013
Online Appendix B. Getting Started in Systems Analysis and Design
Online Appendix C. E-R Diagrams and the IDEF1X Standard
Online Appendix D. E-R Diagrams and the UML Standard
Online Appendix E. Getting Started with MySQL Workbench Data Modeling Tools
Online Appendix F. Getting Started with Microsoft Vision 2013
Online Appendix G. Data Structures for Database Processing
Online Appendix H. The Semantic Object Model
Online Appendix I. Getting Started with Web Servers, PHP and the Eclipse PDT
Online Appendix J. Business Intelligence Systems
Online Appendix K. Big Data
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).
Need help? Get in touch
Play
Pearson eTextbook: What’s on the inside just might surprise you
They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle.