Książki

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.     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. Time limit The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

Database Concepts, Global Edition

• Brief Contents


• Contents


• Part I: Database Fundamentals


• Chapter 1: Getting Started: An Overview of Databases


• Why Use a Database?


• Problems with Lists


• Using Relational Database Tables


• Processing Relational Tables


• What Is a Database System?


• The Database


• The DBMS


• Personal Versus Enterprise-Class Database Systems


• What Is a NoSQL Database?


• The Access Workbench Section 1?Getting Started with Microsoft Access


• Summary


• Key Terms


• Review Questions


• Exercises


• Access Workbench Key Terms


• Access Workbench Exercises


• San Juan Sailboat Charters Case Questions


• Garden Glory Project Questions


• James River Jewelry Project Questions (See Online Appendix D)


• The Queen Anne Curiosity Shop Project Questions


• Chapter 2: The Relational Model and Database Normalization


• Relations


• A Sample Relation and Two Nonrelations


• A Note on Presenting Relation Structures


• A Note on Terminology


• Types of Keys


• Composite Keys


• Candidate and Primary Keys


• Surrogate Keys


• Foreign Keys and Referential Integrity


• The Problem of Null Values


• Functional Dependencies and Normalization


• Functional Dependencies


• Primary and Candidate Keys Revisited


• Normalization


• Relational Design Principles


• The Normalization Process


• Normalization Examples


• Eliminating Anomalies from Multivalued Dependencies


• Normal Forms: One Step at a Time


• The Access Workbench Section 2?Working with Multiple Tables in Microsoft Access


• Summary


• Key Terms


• Review Questions