Description
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.
Features
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
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).
Table of Contents
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
Your Basket