Database design, application development, and administration / Michael V. Mannino.

Contents;

PART ONE: INTRODUCTION TO DATABASE ENVIRONMENTS

Chapter 1: Introduction to Database Management
1.1 Database Characteristics
1.2 Features of Database Management System
1.3 Development of Database Technology and Market Structure
1.4 Architectures of Database Management Systems
1.5 Organizational Impacts of Database Technology
1.6 Etc.

Chapter 2: Introduction to Database Development
2.1 Information Systems
2.2 Goals of Database Development
2.3 Database Development Process
2.4 Tools of Database Development

PART TWO: UNDERSTANDING RELATIONAL DATABASE

Chapter 3: The Relational Data Model
3.1 Basic Elements
3.2 Integrity Rules
3.3 Delete and Update Actions for Referenced Rows
3.4 Operators of Relational Algebra

Chapter 4: Query Formulation with SQL
4.1 Background
4.2 Getting Started with the SELECT Statement
4.3 Conceptual Evaluation Process for SELECT Statements
4.4 Critical Questions for Query Formulation
4.5 Refining Query Formulation Skills with Examples
Etc.

PART THREE: DATA MODELING

Chapter 5: Understanding Entity Relationship Diagrams
5.1 Introduction to Entity Relationships Diagrams
5.2 Understanding Relationships
5.3 Classification in the Entity Relationship Model
5.4 Notational Summary and Diagram Rules
5.5 Comparison to other Notations

Chapter 6: Developing Data Models for Business Databases
6.1 Analyzing Business Data Modeling Problems
6.2 Refinements to an ERD
6.3 Finalizing an ERD
6.4 Converting an ERD TO Relational Tables

PART FOUR: RELATIONAL DATABASE DESIGN

Chapter 7: Normalization of Relational Tables
7.1 Overview of Relational Tables
7.2 Normal Forms
7.3 Refining M-Way Relationships
7.4 Higher Level Normal Forms
7.5 Practical Concerns about Normalization

Chapter 8: Physical Database Design
8.1 Overview of Physical Database Design
8.2 Inputs of Physical Database Design
8.3 File Structure
8.4 Query Optimization
8.5 Index Selection
Etc.

PART FIVE: APPLICATION DEVELOPMENT WITH RELATIONAL DATABASES

Chapter 9: Advanced Query Formulation with SQL
9.1 Outer Join Problems
9.2 Understanding Nested Queries
9.3 Formulating Division Problems
9.4 Null Value Considerations

Chapter 10: Application Development with Views
10.1 Background
10.2 Using Views for Retrieval
10.3 Updating Using Views
10.4 Using Views in Hierarchical Forms
10.5 Using Views in Reports

Chapter 11: Stored Procedures and Triggers
11.1 Database Programming Language PL/SQL
11.2 Stored Procedures
11.3 Triggers

PART SIX: ADVANCED DATABASE DEVELOPMENT

Chapter 12: View Design and Integration
12.1 Motivation for Design and Integration
12.2 View Design with Forms
12.3 View Integration

Chapter 13: Database Development for Student Loan Limited
13.1 Case Description
13.2 Conceptual Data Modeling
13.3 Refining the Conceptual Schema
13.4 Physical Database Design and Application Development

PART SEVEN: MANAGEMENT DATABASE ENVIRONMENT

Chapter 14: Data and Database Administration
14.1 Organizational Context for Managing Databases
14.2 Tools for Database Administration
14.3 Processes for Database Specialists
14.4 Managing Database Environments

Chapter 15: Transaction Management
15.1 Basics of Database Transactions
15.2 Concurrency Control
15.3 Recovery Management
15.4 Transaction Design Issues
15.5 Workflow Management

Chapter 16: Data warehouse Technology and Management
16.1 Basic Concepts
16.2 Multidimensional Representation of Data
16.3 Relational DBMS Support for Data Warehouse
16.4 Maintaining a Data Warehouse

Chapter 17: Client-Server Processing, Parallel Database Processing, and Distributed Databases
17.1 Overview of Distributed Processing and Distributed Data
17.2 Client-Server Database Architectures
17.3 Parallel Database Processing
17.4 Architectures for Distributed Database Processing
17.5 Transparency for Distributed Database Processing
Etc.

Chapter 18: Object Database Management Systems
18.1 Motivation for Object Database Management
18.2 Object-Oriented Principles
18.3 Architectures for Object Database Management
18.4 Object Database Features in SQL: 2003
18.5 Object Database Features in Oracle 10g

Glossary : p.679-695 . _ References : p. 696-697. _ Index : p.698-712.