Database Concepts, Global 7th Edition

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.

• 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

• 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 cov