Description

For undergraduate database management students or business professionals Here’s practical help for understanding, creating, and managing small databases—from two of the world’s leading database authorities. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.

Features

• Provides information on how to create a database management system, regardless of the specific software involved.
• Helps students absorb the process of database creation and implementation, rather than simply the steps in one program.
• Includes Chapter Independent Case Question sets in each chapter that do not require working on the same case as in a previous chapter.
• Three projects run throughout the text, encouraging students to apply the concepts they earn in the chapters to real-life business situations.
• Material to illustrate the concepts of SQL joins has been added to Chapter 3, to make this material easier for students to understand.
• Microsoft Office 2013, and particularly Microsoft Access 2013, are now the basic software used in the book, and are shown running on Microsoft Windows 8.1.
• Access Workbench topics start by creating a database and a single table in Section 1, and move through various topics, finishing with Web database processing against an Access database in Section 7, and using Access, together with Excel, to produce PivotTable OLAP reports in Section 8.
• Includes Microsoft Access switchboard forms, which are used to build menus for database applications, allowing database applications to be built with a user-friendly main menu to display forms, print reports, and run queries.
• The conceptual nature of the text allows students to focus on database concepts rather than the features and functions of a particular product.
• Fully developed data sets for three example databases run throughout various portions of the book, including: Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors.
• Coverage of Web database applications in Chapter 7 includes data input Web form pages, allowing Web database applications to be built with both data input and data reading Web pages.
• Support for Oracle Database 11g Release 2 Express Edition. In an Appendix B, Getting Started with Oracle Database 11g Release 2 Express Edition, shows how to use the product and Oracle SQL Developer GUI utility. Developer screenshots are used in the book to illustrate specific concepts.
• The use of the new Microsoft SQL Server 2012 Express edition: Although most of the topics covered are backward compatible with Microsoft SQL Server 2008 R2 Express Edition, all material in the book now uses SQL Server 2012 in conjunction with Office 2010 exclusively.
• DBMS software coverage has been updated to include Microsoft SQL Server 2014 Express Edition, and Oracle MySQL 5.7 Community Server.
• Material on SQL programming via SQL/Persistent Stored Modules (SQL/PSM) has been added to Appendix E to provide a better-organised and expanded discussion of this material, which had previously been spread among other parts of the book.
• Material on big data and the evolving NoSQL movement is now briefly introduced in Chapter 1, while the main, expanded discussion of this material is still in Chapter 8. Big data remains the theme for Chapter 8, and includes the material on the development of nonrelational unstructured data stores (such as Cassandra and HBase) and the Hadoop Distributed File System (HDFS) first introduced in DBC e06.

New to this Edition

Provides a firm understanding of the concepts behind the software:
• NEW! Material to illustrate the concepts of SQL joins has been added to Chapter 3, to make this material easier for students to understand.
Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class:
• NEW! Microsoft Office 2013, and particularly Microsoft Access 2013, are now the basic software used in the book, and are shown running on Microsoft Windows 8.1.
Includes coverage of some of the latest information available:
• NEW! DBMS software coverage has been updated to include Microsoft SQL Server 2014 Express Edition, and Oracle MySQL 5.7 Community Server.
• NEW! Material on SQL programming via SQL/Persistent Stored Modules (SQL/PSM) has been added to Appendix E to provide a better-organized and expanded discussion of this material, which had previously been spread among other parts of the book. This material also provides additional SQL topics for instructors.
• NEW! Material on big data and the evolving NoSQL movement is now briefly introduced in Chapter 1, while the main, expanded discussion of this material is still in Chapter 8. Big data remains the theme for Chapter 8, and includes the material on the development of nonrelational unstructured data stores (such as Cassandra and HBase) and the Hadoop Distributed File System (HDFS) first introduced in DBC e06.
• NEW! A new online appendix–Appendix K, 'Big Data'–has been added to provide new, more detailed material on the NoSQL databases used in big data setups than that included in Chapter 8 for those instructors who still want to cover this topic in depth.
• NEW! The Oracle NetBeans IDE is used in Chapter 7 in place of the Eclipse PDT IDE. Since an integrated downloadable installation file for both the Java JDK and NetBeans is available, this results in a much easier software installation of these products in Appendix I. The NetBeans IDE is also arguably easier to use then the Eclipse PDT, which will make it easier for students to create the HTML and PHP Web pages used in Chapter 7.

Table of Contents

• Part I. Database Fundamentals
• 1. Getting Started
• 2. The Relational Model
• 3. Structured Query Language
• Part II. Database Design
• 4. Data Modeling and the Entity-Relationship Model
• 5. Database Design
• Part III. Database Management
• 6. Database Administration
• 7. Database Processing Applications
• 8. Big Data, Data Warehouses, and Business Intelligence Systems