Concepts of database management

Table of Contents
Preface
Chapter 1 Introduction to Database Management
	Introduction
	BITS Company Background
	Database Solution
		Database Terminology
		Storing Data
	Database Management Systems
	Advantages of Database Processing
	Disadvantages of Database Processing
	Big Data
	Introduction to the Colonial Adventure Tours Database Case
	Introduction to the Sports Physical Therapy Database Case
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 2 The Relational Model 1: Introduction, QBE, and Relational Algebra
	Introduction
	Relational Databases
		Relational Database Shorthand
	Query-By-Example
	Simple Queries
		Choosing Fields and Running the Query
	Simple Criteria
		Parameter Queries
		Operators
	Compound Criteria
	Computed Fields
	Functions
	Grouping
	Sorting
		Sorting on Multiple Keys
	Joining Tables
	Joining Multiple Tables
	Using an Update Query
	Using a Delete Query
	Using a Make-Table Query
	Query Optimization
	Relational Algebra
		Selection
		Projection
		Joining
		Union
		Intersection
		Difference
		Product
		Division
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises: QBE
	BITS Corporation Exercises: Relational Algebra
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 3 The Relational Model 2: SQL
	Introduction
	Getting Started with SQL
		Opening an SQL Query Window in Access
	Table Creation
		Naming Conventions
		Data Types
	Simple Retrieval
		Numeric Criteria
		Character Criteria
		Date Criteria
		Comparing Two Fields
	Compound Conditions
	Computed Fields
	Using Special Operators (Like and In
	Sorting
		Sorting on Multiple Fields
	Built-in Functions
	Subqueries
	Grouping
	Joining Tables
		Complex Joins
	Union
	Updating Tables
	Creating a Table from a Query
	Summary of SQL Commands
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 4 The Relational Model 3: Advanced Topics
	Introduction
	Views
	Indexes
	Security
	Integrity Rules
		Entity Integrity
		Referential Integrity
		Legal-Values Integrity
	Structure Changes
	Making Complex Changes
	System Catalog
	Stored Procedures
	Triggers
		Triggers in Access 2016
		Before Macros
		After Macros
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 5 Database Design 1: Normalization
	Introduction
	Functional Dependence
	Keys
	First Normal Form
	Second Normal Form
	Third Normal Form
	Incorrect Decompositions
	Multivalued Dependencies and Fourth Normal Form
	Avoiding the Problem with Multivalued Dependencies
	Application to Database Design
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 6 Database Design 2: Design Method
	Introduction
	User Views
	Information-Level Design Method
		Step 1: Represent the User View as a Collection of Tables
		Step 2: Normalize the Tables
		Step 3: Identify All Keys
	Database Design Language (DBDL
		Entity-Relationship (E-R) Diagrams
		Step 4: Merge the Result into the Design
	Database Design Examples
	Physical-Level Design
	Top-Down versus Bottom-Up Design
	Survey Form
	Obtaining Information from Existing Documents
	One-to-One Relationship Considerations
	Many-to-Many Relationship Considerations
	Nulls and Entity Subtypes
	Avoiding Problems with Third Normal Form When Merging Tables
	The Entity-Relationship Model
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 7 DBMS Functions
	Introduction
	Update and Retrieve Data
	Provide Catalog Services
	Support Concurrent Update
		The Concurrent Update Problem
		Avoiding the Lost Update Problem
		Two-Phase Locking
		Deadlock
		Locking on PC-Based DBMSs
		Timestamping
	Recover Data
		Journaling
		Forward Recovery
		Backward Recovery
		Recovery on PC-Based DBMSs
	Provide Security Services
		Encryption
		Authentication
		Authorizations
		Views
		Privacy
	Provide Data Integrity Features
	Support Data Independence
		Adding a Field
		Changing the Length of a Field
		Creating an Index
		Adding or Changing a Relationship
	Support Data Replication
	Provide Utility Services
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 8 Database Administration
	Introduction
	The Role of the Database Administrator
		Education and Qualifications
		Duties and Responsibilities
	Database Policy Formulation and Enforcement
		Access Privileges
		Grant and Revoke
		Security
		Disaster Planning
		Archiving
	Other Database Administrative Functions
		DBMS Evaluation and Selection
		DBMS Maintenance
		Data Dictionary Management
		Training
	Technical Functions
		Database Design
		Testing
		Performance Tuning
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Chapter 9 Database Management Approaches
	Introduction
	Distributed Databases
	Characteristics of Distributed Systems
		Location Transparency
		Replication Transparency
		Fragmentation Transparency
	Advantages of Distributed Databases
	Disadvantages of Distributed Databases
	Rules for Distributed Databases
	Client/Server Systems
		Advantages of Client/Server Systems
	Web Access to Databases
	XML
	Data Warehouses
		Data Warehouse Structure and Access
		Rules for OLAP Systems
	Object-Oriented Systems
		What Is an Object-Oriented DBMS
		Objects and Classes
		Methods and Messages
		Inheritance
		Unified Modeling Language (UML
		Rules for OODBMSs
	Summary
	Key Terms
	Review Questions
	BITS Corporation Exercises
	Colonial Adventure Tours Case
	Sports Physical Therapy Case
Appendix A Comprehensive Design Example: Douglas College
	Douglas College Requirements
		General Description
		Report Requirements
		Update (Transaction) Requirements
	Douglas College Information-Level Design
	Final Information-Level Design
	Exercises
Appendix B SQL Reference
	ALTER TABLE
	Column or Expression List (SELECT Clause
		Computed Fields
		Functions
	Conditions
		Simple Conditions
		Compound Conditions
			BETWEEN Conditions
			LIKE Conditions
			IN Conditions
		CREATE INDEX
		CREATE TABLE
		CREATE VIEW
		Data Types
		DELETE Rows
		DROP INDEX
		DROP TABLE
		GRANT
		INSERT
		Integrity
		Join
		REVOKE
		SELECT
		SELECT INTO
		Subqueries
		UNION
		UPDATE
Appendix C “How Do I” Reference
Appendix D Introduction to MySQL
	Introduction
	Downloading and Installing MySQL
	Running MySQL
		Opening an SQL File in MySQL
		Creating a Query in MySQL
		Managing the MySQL Window
	Running MySQL from the Command Line
		Opening a Command Prompt Window
		Starting the MySQL Command Line
	Summary
	Key Terms
Appendix E A Systems Analysis Approach to Information-Level Requirements
	Introduction
	Information Systems
	System Requirement Categories
		Output Requirements
		Input Requirements
		Processing Requirements
		Technical and Constraining Requirements
	Determining System Requirements
		Interviews
		Questionnaires
		Document Collection
		Observation
		Research
	Transitioning from Systems Analysis to Systems Design
	Key Terms
	Exercises
Glossary
Index