Kroenke D.M., Auer D.J. Database Processing: Fundamentals, Design, and Implementation

14th ed. — Pearson Education Ltd., 2016. — 638 p. in color. — ISBN: 1292107634, 9781292107639For 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.FeaturesSpiral 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 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.
NEW! 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).New to this Edition
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).