Database design, application development, and administration /
Mannino, Michael V.
Database design, application development, and administration / Michael V. Mannino. - 3rd edition. - Boston : McGraw-Hill Irwin, c2007. - xxiii, 712 p. : ill. ; 27 cm.
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.
9780072942200 (alk. paper) 0072942207 (alk. paper)
2005044402
Database design.
Application software--Development.
Database management.
005.74 / MAN
Database design, application development, and administration / Michael V. Mannino. - 3rd edition. - Boston : McGraw-Hill Irwin, c2007. - xxiii, 712 p. : ill. ; 27 cm.
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.
9780072942200 (alk. paper) 0072942207 (alk. paper)
2005044402
Database design.
Application software--Development.
Database management.
005.74 / MAN