Database processing : fundamentals, design, and implementation / David M. Kroenke, David J. Auer.
Saved in:
Main Author: | |
---|---|
Other Authors: | |
Format: | Book |
Language: | English |
Published: |
Boston :
Pearson,
[2016]
|
Edition: | 14th edition. |
Subjects: |
Table of Contents:
- Machine generated contents note: ch. 1 Introduction
- Chapter Objectives
- The Importance of Databases in the Internet and Smartphone World
- The Characteristics of Databases
- A Note on Naming Conventions
- A Database Has Data and Relationships
- Databases Create Information
- Database Examples
- Single-User Database Applications
- Multiuser Database Applications
- E-Commerce Database Applications
- Reporting and Data Mining Database Applications
- The Components of a Database System
- Database Applications and SQL
- The DBMS
- The Database
- Personal Versus Enterprise-Class Database Systems
- What Is Microsoft Access?
- What Is an Enterprise-Class Database System?
- Database Design
- Database Design from Existing Data
- Database Design for New Systems Development
- Database Redesign
- What You Need to Learn
- A Brief History of Database Processing
- The Early Years
- The Emergence and Dominance of the Relational Model
- Post-Relational Developments
- Note continued: Summary
- Key Terms
- Review Questions
- Project Questions
- ch. 2 Introduction to Structured Query Language
- Chapter Objectives
- Cape Codd Outdoor Sports
- Business Intelligence Systems and Data Warehouses
- The Cape Codd Outdoor Sports Extracted Retail Sales Data
- RETAIL_ORDER Data
- ORDER_ITEM Data
- SKU_DATA Table
- CATALOG_SKU_20## Tables
- The Complete Cape Codd Data Extract Schema
- Data Extracts Are Common
- SQL Background
- 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
- Using SQL in Microsoft Access 2013
- Using SQL in Microsoft SQL Server 2014
- Using SQL in Oracle Database
- Using SQL in Oracle MySQL 5.6
- SQL Enhancements for Querying a Single Table
- Reading Specified Rows from a Single Table
- Reading Specified Columns and Rows from a Single Table
- Note continued: Sorting the SQL Query Results
- SQL WHERE Clause Options
- Performing Calculations in SQL Queries
- Using SQL Built-in Aggregate Functions
- SQL Expressions in SQL SELECT Statements
- Grouping Rows in SQL SELECT Statements
- Querying Two or More Tables with SQL
- Querying Multiple Tables with Subqueries
- Querying Multiple Tables with Joins
- Comparing Subqueries and Joins
- The SQL JOIN ON Syntax
- Outer Joins
- Using SQL Set Operators
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 3 The Relational Model and Normalization
- Chapter Objectives
- Relational Model Terminology
- Relations
- Characteristics of Relations
- Alternative Terminology
- To Key, or Not to Key-That Is the Question!
- Functional Dependencies
- Finding Functional Dependencies
- Keys
- Normal Forms
- Modification Anomalies
- A Short History of Normal Forms
- Note continued: Normalization Categories
- From First Normal Form to Boyce-Codd Normal Form Step by Step
- Eliminating Anomalies from Functional Dependencies with BCNF
- Eliminating Anomalies from Multivalued Dependencies
- Fifth Normal Form
- Domain/Key Normal Form
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 4 Database Design Using Normalization
- Chapter Objectives
- Assess Table Structure
- Designing Updatable Databases
- Advantages and Disadvantages of Normalization
- Functional Dependencies
- Normalizing with SQL
- Choosing Not to Use BCNF
- Multivalued Dependencies
- Designing Read-Only Databases
- Denormalization
- Customized Duplicated Tables
- Common Design Problems
- The Multivalue, Multicolumn Problem
- Inconsistent Values
- Missing Values
- The General-Purpose Remarks Column
- Summary
- Key Terms
- Review Questions
- Project Questions
- Note continued: Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 5 Data Modeling with the Entity-Relationship Model
- Chapter Objectives
- The Purpose of a Data Model
- The Entity-Relationship Model
- Entities
- Attributes
- Identifiers
- Relationships
- Maximum Cardinality
- Minimum Cardinality
- Entity-Relationship Diagrams and Their Versions
- Variations of the E-R Model
- E-R Diagrams Using the IE Crow's Foot Model
- Strong Entities and Weak Entities
- ID-Dependent Entities
- Non-ID-Dependent Weak Entities
- The Ambiguity of the Weak Entity
- Subtype Entities
- Patterns in Forms, Reports, and E-R Models
- Strong Entity Patterns
- ID-Dependent Relationships
- Mixed Identifying and Nonidentifying Patterns
- The For-Use-By Pattern
- Recursive Patterns
- The Data Modeling Process
- The College Report
- The Department Report
- The Department/Major Report
- The Student Acceptance Letter
- Summary
- Key Terms
- Note continued: Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 6 Transforming Data Models into Database Designs
- Chapter Objectives
- The Purpose of a Database Design
- Create a Table for Each Entity
- Selecting the Primary Key
- Specifying Alternate Keys
- Specifying Column Properties
- Verify Normalization
- Create Relationships
- Relationships Between Strong Entities
- Relationships Using ID-Dependent Entities
- Relationships with a Weak Non-ID-Dependent Entity
- Relationships in Mixed Entity Designs
- Relationships Between Supertype and Subtype Entities
- Recursive Relationships
- Representing Ternary and Higher-Order Relationships
- Relational Representation of the Highline University Data Model
- Design for Minimum Cardinality
- Actions when the Parent Is Required
- Actions when the Child Is Required
- Implementing Actions for M-O Relationships
- Note continued: Implementing Actions for O-M Relationships
- Implementing Actions for M-M Relationships
- Designing Special Case M-M Relationships
- Documenting the Minimum Cardinality Design
- An Additional Complication
- Summary of Minimum Cardinality Design
- The View Ridge Gallery Database
- View Ridge Gallery Database Summary of Requirements
- The View Ridge Data Model
- Database Design with Data Keys
- Minimum Cardinality Enforcement for Required Parents
- Minimum Cardinality Enforcement for the Required Child
- Column Properties for the View Ridge Database Design Tables
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 7 SQL for Database Construction and Application Processing
- Chapter Objectives
- The Importance of Working with an Installed DBMS Product
- The View Ridge Gallery Database
- SQL DDL and DML
- Managing Table Structure with SQL DDL
- Note continued: Creating the VRG Database
- Using SQL Scripts
- Using the SQL CREATE TABLE Statement
- Variations in SQL Data Types and SQUPSM
- Creating the VRG Database ARTIST Table
- Creating the VRG Database WORK Table and the 1:NARTIST-to-WORK Relationship
- Implementing Required Parent Rows
- Implementing 1:1 Relationships
- Casual Relationships
- Creating Default Values and Data Constraints with SQL
- Creating the VRG Database Tables
- The SQL ALTER TABLE Statement
- The SQL DROP TABLE Statement
- The SQL TRUNCATE TABLE Statement
- The SQL CREATE INDEX Statement
- SQL DML Statements
- The SQL INSERT Statement
- Populating the VRG Database Tables
- The SQL UPDATE Statement
- The SQL MERGE Statement
- The SQL DELETE Statement
- Using SQL Views
- Using SQL Views to Hide Columns and Rows
- Using SQL Views to Display Results of Computed Columns
- Using SQL Views to Hide Complicated SQL Syntax
- Layering Built-in Functions
- Note continued: Using SQL Views for Isolation, Multiple Permissions, and Multiple Triggers
- Updating SQL Views
- Embedding SQL in Program Code
- SQL/Persistent Stored Modules (SQL/PSM)
- Using SQL User-Defined Functions
- Using SQL Triggers
- Using Stored Procedures
- Comparing User-Defined Functions, Triggers, and Stored Procedures
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 8 Database Redesign
- Chapter Objectives
- The Need for Database Redesign
- SQL Statements for Checking Functional Dependencies
- What Is a Correlated Subquery?
- How Do I Analyze an Existing Database?
- Reverse Engineering
- Dependency Graphs
- Database Backup and Test Databases
- Changing Table Names and Table Columns
- Changing Table Names
- Adding and Dropping Columns
- Changing a Column Data Type or Column Constraints
- Adding and Dropping Constraints
- Note continued: Changing Relationship Cardinalities
- Changing Minimum Cardinalities
- Changing Maximum Cardinalities
- Adding and Deleting Tables and Relationships
- Forward Engineering
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 9 Managing Multiuser Databases
- Chapter Objectives
- The Importance of Working with an Installed DBMS Product
- Database Administration
- Managing the Database Structure
- Concurrency Control
- The Need for Atomic Transactions
- Resource Locking
- Optimistic Versus Pessimistic Locking
- SQL Transaction Control Language and Declaring Lock Characteristics
- Implicit and Explicit COMMIT TRANSACTION
- Consistent Transactions
- Transaction Isolation Level
- SQL Cursors
- Database Security
- Processing Rights and Responsibilities
- DBMS Security
- DBMS Security Guidelines
- Application Security
- The SQL Injection Attack
- Note continued: Database Backup and Recovery
- Recovery via Reprocessing
- Recovery via Rollback/Rollforward
- Managing the DBMS
- Maintaining the Data Repository
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan importing
- ch. 10 Managing Databases with Microsoft SQL Server 2014, Oracle Database, and MySQL 5.6
- Chapter Objectives
- Installing the DBMS
- Using the DBMS Database Administration and Database Development Utilities
- Creating a Database
- Creating and Running SQL Scripts
- Reviewing the Database Structure in the DBMS GUI Utility
- Creating and Populating the View Ridge Gallery VRG Database Tables
- Creating SQL Views for the View Ridge Gallery VRG Database
- Database Application Logic and SQL/Persistent Stored Modules (SQL/PSM)
- DBMS Concurrency Control
- DBMS Security
- DBMS Database Backup and Recovery
- Other DBMS Topics Not Discussed
- Note continued: Choose Your DBMS Product(s)!
- Summary
- Key Terms
- Project Questions
- ch. 11 The Web Server Environment
- Chapter Objectives
- A Web Database Application for the View Ridge Gallery
- The Web Database Processing Environment
- Database Server Access Standards
- The ODBC Standard
- ODBC Architecture
- Conformance Levels
- Creating an ODBC Data Source Name
- The Microsoft .NET Framework and ADO.NET
- OLE DB
- ADO and ADO.NET
- The ADO.NET Object Model
- The Java Platform
- JDBC
- Java Server Pages (JSP) and Servlets
- Apache Tomcat
- Web Database Processing with PHP
- Web Database Processing with PHP and the NetBeans IDE
- Getting Started with HTML Web Pages
- The index.html Web Page
- Creating the index.html Web Page
- Using PHP
- Web Page Examples with PHP
- Example 1: Updating a Table
- Example 2: Using PHP Data Objects (PDO)
- Example 3: Invoking a Stored Procedure
- Challenges for Web Database Processing
- Note continued: SQL Injection Attacks
- Extensible Markup Language (XML)
- The Importance of XML
- XML as a Markup Language
- Creating XML Documents from Database Data
- Using the SQL SELECT...FOR XML Statement
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing
- ch. 12 Big Data, Data Warehouses, and Business Intelligence Systems
- 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
- Components of a Data Warehouse
- Data Warehouses Versus Data Marts
- Dimensional Databases
- Reporting Systems
- RFM Analysis
- OLAP
- Data Mining
- Distributed Database Processing
- Types of Distributed Databases
- Challenges of Distributed Databases
- Object-Relational Databases
- Virtualization
- Note continued: Cloud Computing
- Big Data and the Not Only SQL Movement
- Column Family Databases
- MapReduce
- Hadoop
- Summary
- Key Terms
- Review Questions
- Project Questions
- Case Questions
- The Queen Anne Curiosity Shop
- Morgan Importing.