Database Concepts, 9th Edition By David Kroenke, David Auer, Scott Vandenberg, Robert Yoder [PDF] [eBook]

Database Concepts Brief Contents Contents Preface New to this Edition The Need for Essential Concepts Teaching Concepts Independent of DBMS Products Working with Microsoft Access Working with MySQL Key Terms, Re ...

Database Concepts Brief Contents Contents Preface New to this Edition The Need for Essential Concepts Teaching Concepts Independent of DBMS Products Working with Microsoft Access Working with MySQL Key Terms, Review Questions, Exercises, Cases, and Projects Software Used in the Book Changes from the Eighth Edition Book Overview Keeping Current in a Rapidly Changing World About the Authors Part 1 Database Fundamentals Chapter 1 Getting Started Chapter Objectives The Importance of Databases in the Internet and Mobile App World Why Use a Database? What are the Problems with Using Lists? Using Relational Database Tables A Relational Design for the Student with Adviser List A Relational Design for the Student with Adviser and Department List A Relational Design for Art Course Enrollments A Relational Design for Parts and Prices How do I Process Relational Tables Using SQL? What is a Database System? The Database The DBMS Application Programs Personal Versus Enterprise-Class Database Systems MySQL Community Server 8.0 Microsoft SQL Server 2017 Oracle Database XE What is a Web Database Application? What are Data Warehouses and Business Intelligence (BI) Systems? What is Big Data? What is Cloud Computing? Summary Key Terms Review Questions Exercises Case Questions San Juan Sailboat Charters Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 2 The Relational Model Chapter Objectives 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 To Key or Not to Key—That Is the Question! Functional Dependencies and Normalization Functional Dependencies Primary and Candidate Keys Revisited Normalization Relational Design Principles The Normalization Process Step 1 of the Normalization Process Step 2 of the Normalization Process Step 3 of the Normalization Process Normalization Examples Normalization Example 1 Normalization Example 2 Normalization Example 3 Normalization Example 4 Eliminating Anomalies from Multivalued Dependencies Summary Key Terms Review Questions Exercises Case Questions Regional Labs Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 3 Structured Query Language Chapter Objectives Wedgewood Pacific “Does Not Work with Microsoft Access ANSI-89 SQL” SQL for Data Definition (DDL)—Creating Tables and Relationships Defining Primary Keys with Table Constraints Defining Foreign Keys with the Table Constraints Submitting SQL to the DBMS SQL for Data Manipulation (DML)—Inserting Data Inserting Data SQL for Data Manipulation (DML)—Single Table Queries The SQL SELECT/FROM/WHERE Framework Reading Specified Columns from a Single Table Specifying Column Order in SQL Queries from a Single Table Submitting SQL Statements to the DBMS SQL Enhancements for Single Table Queries Reading Specified Rows from a Single Table Reading Specified Columns and Rows from a Single Table Sorting the Results of a Query SQL WHERE Clause Options Compound SQL WHERE Clauses Using Logical Operators SQL WHERE Clauses Using Sets of Values SQL WHERE Clauses Using Ranges of Values SQL WHERE Clauses That Use Character String Patterns SQL WHERE Clauses That Use NULL Values SQL Queries that Perform Calculations Using SQL Built-in Aggregate Functions Using SQL Expressions in SQL SELECT Statements Grouping Rows using SQL SELECT Statements SQL for Data Manipulation (DML)—Multiple Table Queries Querying Multiple Tables with Subqueries Querying Multiple Tables with Joins The SQL JOIN ON Syntax Comparing Subqueries and Joins Inner Joins and Outer Joins Using SQL Set Operators SQL for Data Manipulation (DML)—Data Modification and Deletion Modifying Data Deleting Data SQL for Data Definition (DDL)—Table and Constraint Modification and Deletion The SQL DROP TABLE Statement The SQL ALTER TABLE Statement The SQL TRUNCATE TABLE Statement SQL Views Summary Key Terms Review Questions Exercises Case Questions Heather Sweeney Designs Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Part 2 Database Design Chapter 4 Data Modeling and the Entity-Relationship Model Chapter Objectives Systems Development and Analysis What is an Information System? What is a Business Process? How Do Information Systems Support Business Processes? What Is Systems Analysis and Design? What Are the Steps in the SDLC? The System Definition Step The Requirements Analysis Step The Component Design Step The Implementation Step The System Maintenance Step What are the Steps in the Database Development Process? Requirements Analysis The Entity-Relationship Data Model Entities Attributes Identifiers Relationships Three Types of Binary Relationships Maximum Cardinality Minimum Cardinality Entity-Relationship Diagrams Variations of the E-R Model The IE Crow’s Foot E-R Model Weak Entities ID-Dependent Entities Non–ID-Dependent Weak Entities Associative Entities Subtype Entities Recursive Relationships Developing an Example E-R Diagram Heather Sweeney Designs The Seminar Customer List The Customer Form Letter The Sales Invoice Attribute Specifications Business Rules Validating the Data Model Summary Key Terms Review Questions Exercises Case Questions Highline University Mentor Program Writer’s Patrol Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 5 Database Design Chapter Objectives The Purpose of a Database Design Transforming a Data Model into a Database Design Representing Entities with the Relational Model Representing the ITEM Entity Surrogate Keys Column Properties Data Types NULL Status Default Values Data Constraints Verifying Normalization Representing the CUSTOMER Entity Denormalization A Relational Design for the SALES_COMMISSION Entity Representing Weak Entities Representing Relationships Relationships Between Strong Entities Representing 1:1 Strong Entity Relationships Representing 1:N Strong Entity Relationships Representing N:M Strong Entity Relationships Relationships Using Weak Entities Relationships with Subtypes Representing Recursive Relationships Database Design at Heather Sweeney Designs Weak Entities Verifying Normalization Specifying Column Properties Relationships Enforcing Referential Integrity Summary Key Terms Review Questions Exercises Case Questions Writer’s Patrol Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Part 3 Database Management Chapter 6 Database Administration Chapter Objectives The Heather Sweeney Designs Database The Need for Control, Security, and Reliability Concurrency Control The Need for Atomic Transactions Concurrent Transaction Processing The Lost Update Problem Resource Locking Serializable Transactions Deadlock Optimistic Versus Pessimistic Locking SQL Transaction Control Language and Declaring Lock Characteristics Consistent Transactions Transaction Isolation Level Cursor Types Database Security User Accounts User Processing Rights and Responsibilities DBMS-Level Security Application-Level Security Database Backup and Recovery Recovery via Reprocessing Recovery via Rollback and Rollforward Physical Database Design and Optimization Additional DBA Responsibilities Summary Key Terms Review Questions Exercises Case Questions Marcia’s Dry Cleaning Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Chapter 7 Data Warehouses, Business Intelligence Systems, and Big Data Chapter Objectives Business Intelligence Systems The Relationship Between Operational and BI Systems Reporting Systems and Data Mining Applications Reporting Systems Data Mining Applications Data Warehouses and Data Marts The Components of a Data Warehouse Data Warehouses Versus Data Marts Dimensional Databases The Star Schema Illustrating the Dimensional Model Multiple Fact Tables and Conformed Dimensions OLAP Distributed Database Processing Types of Distributed Databases Challenges of Distributed Databases Object-Relational Databases Virtualization Cloud Computing Big Data and the not only SQL Movement Design Decisions and the CAP Theorem Categories of NoSQL Database Management Systems Document Databases and JSON MapReduce Hadoop Summary Key Terms Review Questions Exercises Case Questions Marcia’s Dry Cleaning Garden Glory Project Questions James River Jewelry Project Questions The Queen Anne Curiosity Shop Project Questions Online Extensions Glossary