Concepts of Database Management

Cover
Brief Contents
Contents
Preface
Module 1: Introduction to Database Management
	Introduction
	JC Consulting Company Background
	Selecting a Database Solution
	Storing Data
	Identifying Database Management Systems
	Advantages of a Properly Designed Relational Database
	Big Data
	Preparing for a Career in Database Administration and Data Analysis
	Introduction to the Pitt Fitness Database Case
	Introduction to the Sports Physical Therapy Database Case
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 2: The Relational Model: Introduction, QBE, and Relational Algebra
	Introduction
	Examining Relational Databases
	Creating Simple Queries and Using Query-By-Example
	Using Simple Criteria
	Using Compound Criteria
	Creating Computed Fields
	Summarizing with Aggregate Functions and Grouping
	Sorting Records
	Joining Tables
	Using an Update Query
	Using a Delete Query
	Using a Make-Table Query
	Optimizing Queries
	Examining Relational Algebra
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises: QBE
	JC Consulting Case Exercises: Relational Algebra
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 3: The Relational Model: SQL
	Introduction
	Getting Started with SQL
	Creating a Table
	Selecting Data
	Using Compound Conditions: AND Criteria
	Using Compound Conditions: OR Criteria
	Using the BETWEEN Operator
	Using the NOT Operator
	Creating Calculated Fields
	Using Wildcards and the LIKE Operator
	Using the IN Operator
	Sorting Records
	Using Aggregate Functions
	Grouping Records
	Writing Subqueries
	Joining Tables with the WHERE Clause
	Using the UNION Operator
	Updating Values with the SQL UPDATE Command
	Inserting a Record with the SQL INSERT Command
	Deleting Records with the SQL DELETE Command
	Saving Query Results as a Table
	Developing Career Skills: SQL
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 4: The Relational Model: Advanced Topics
	Introduction
	Creating and Using Views
	Using Indexes
	Examining Database Security Features
	Enforcing Integrity Rules
	Changing the Structure of a Relational Database
	Using SQL JOIN Commands
	Using the System Catalog
	Using Stored Procedures and Triggers
	Career Skills: Database Administrators
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 5: Database Design: Normalization
	Introduction
	Case Study: Faculty/Student Advising Assignments
	Data Modification Anomalies
	Functional Dependence
	Keys
	First Normal Form
	Atomic Values
	Algorithms
	Creating Fields
	Updating Fields
	Creating the 1NF Table
	Using Atomic Values for Quantities
	Finding Duplicate Records
	Second Normal Form
	Benefits of Normalization
	Third Normal Form
	Fourth Normal Form
	Beyond Fourth Normal Form
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 6: Database Design: Relationships
	Introduction
	User Views
	Documenting a Relational Database Design
	Setting Keys and Indexes
	Entity-Relationship (E-R) Diagrams
	The Entity-Relationship Model (ERM)
	Exploring One-to-Many Relationships in Access
	Working with One-to-Many Relationships in Query Datasheet View
	Other Relationship Types
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 7: Database Management Systems Processes and Services
	Introduction
	Create, Read, Update, and Delete Data
	Provide Catalog Services
	Support Concurrent Updates
	Recover Data
	Provide Security Services
	Provide Data Integrity Features
	Support Data Independence
	Support Data Replication
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 8: Database Industry Careers
	Introduction
	Careers in the Database Industry
	Role of a Database Administrator
	Database Policy Formulation and Enforcement
	Database Technical Functions
	Database Administrative Functions
	Professionals Reporting to the DBA
	Responsibilities of a Data Analyst
	Responsibilities of a Data Scientist
	Database Industry Certifications
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Module 9: Database Industry Trends
	Introduction
	Database Architectures
	Personal Computer Revolution
	Client/Server Architecture
	Data Warehouses
	Distributed Databases
	Selecting a Relational Database System
	NoSQL Database Management Systems
	Object-Oriented Database Management Systems
	Big Data
	Data Formats
	Data Visualization Tools
	Summary
	Key Terms
	Module Review Questions
	JC Consulting Case Exercises
	Pitt Fitness Case Exercises
	Sports Physical Therapy Case Exercises
Appendix A: Comprehensive Design Example: Douglas College
Appendix B: SQL Reference
Appendix C: FAQ Reference
Appendix D: Introduction To MySQL
Appendix E: A Systems Analysis Approach to Information-Level Requirements
Glossary
Index