Database processing : fundamentals, design, and implementation /

Database processing : fundamentals, design, and implementation / David M. Kroenke, David J. Auer.

Saved in:
Bibliographic Details
Main Author: Kroenke, David M., 1946-
Other Authors: Auer, David J.
Format: Book
Language:English
Published: Boston : Pearson, [2016]
Edition:14th edition.
Subjects:
Database management.
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.

Similar Items