Database Design - Application - Development & Administration

Curriculum Design and Instruction To Teach

Database Design, Application, Development,

and Administration:



Author: Charles Hayes:




In computing, a database can be defined

as a structured collection of records or

data that is stored in a computer so that

a program can consult it to answer queries.

The records retrieved in answer to queries

become information that can be used to make

decisions.






Special Features Include:

Phases For Conducting a Needs Assessment:
Curriculum Design Supplement:
|a|. Subject-Questions-Answers:
Curriculum Design Plan:
Curriculum Design Goals:
Curriculum Design Objectives:
Instructional Goals:
Instructional Objectives:
Instructional Activities:
Instructional Evaluation Techniques:
Lesson Plans:
Standard Vocabulary:
Learning Objectives:
A Limited Glimpse:


Topics Include:

* Introduction:

@ Introduction To Database

Environments:

A. Introduction To Database

Management:

1. Data Characteristics:

2. Features of Database Management

Systems:

a. Database Definition:

b. Nonprocedural Access:

c. Application Development and Procedural

Language Interface:

d. Features to Support Database Operations:

e. Third-Party Features:

3. Development of Database Technology and

Market Structure:

a. Evolution of Database Technology:

b. Current Market for Database Software:

4. Architectures of Database Management

Systems:

a. Data Independence and the Three Schema

Architecture:

b. Distributed Processing and the Client-Server

Architecture:

5. Organizational Impacts of Database Technology:

a. Interacting with Databases:

b. Information Resource Management:

* Introduction:

@ Introduction To Database

Environments:

A. Introduction To Database

Development:

1. Information Systems:

a. Components of Information Systems:

b. Information Systems Development Process:

2. Goals of Database Development:

a. Develop a Common Vocabulary:

b. Define the Meaning Of Data:

c. Ensure Data Quality:

d. Find an Efficient Implementation:

3. Database Development Process:

a. Phases of Database Development:

b. Skills in Database Development:

4. Tools of Database Development:

a. Diagramming:

b. Documentation:

c. Analysis:

d. Prototyping Tools:

e. Commercial CASE Tools:

* Introduction:

@ Understanding Relational Database:

A. The Relational Data Model:

1. Basic Elements:

a. Tables:

b. Connections among Tables:

c. Alternative Terminology:

2. Integrity Rules:

a. Definition of the Integrity Rules:

b. Application of the Integrity Rules:

c. Graphical Representation of Referential

Integrity:

3. Delete and Update Actions for Referenced

Rows:

a. Restrict (Select) Project Operators:

b. Extended Cross Product Operator:

c. Join Operator:

d. Outer Join Operator:

e. Union, Intersection, and Difference

Operators:

f. Summarize Operator:

g. Divide Operator:

h. Summary of Operators:

+ CREATE TABLE Statements for the

University Database Tables:

+ SQL: 2003 Syntax Summary:

+ Generation of Unique Values for

Primary Keys:

* Introduction:

@ Understanding Relational Databases:

A. Query Formulation With SQL:

1. Background:

a. Brief History of SQL:

b. Scope of SQL:

2. Getting Started with the SELECT

Statement:

a. Single Table Problems:

b. Joining Tables: Summarizing Table with

GROUP BY and HAVING:

c. Improving the Appearance of Results:

3. Conceptual Evaluation Process for SELECT

Statements:

4. Critical Questions for Query Formulation:

5. Refining Query Formulation Skills with

Examples:

a. Joining Multiple Tables with the Cross

Product Style:

b. Joining Multiple Tables with the Join

Operator Style:

c. Self-Joins and Multiple Joins between

Two Tables:

d. Combining Joins and Grouping:

e. Traditional Set Operators in SQL:

6. SQL Modification Statements:

+ SQL: 2003 Syntax Summary:

+ Syntax Differences among Major DRMS Products:

* Introduction:

@ Data Modeling:

A. Understanding Entity Relationship

Diagrams:

1. Introduction to Entity Relationship

Diagrams:

a. Basic Symbols:

b. Relationship Cardinality:

c. Comparison to Relational Database

Diagrams:

2. Understanding Relationships:

a. Identification Dependency (Weak

Entities and Identifying Relationships):

b. Relationship Patterns:

c. Equivalence between 1-M and M-N

Relationships:

3. Classification in the Entity

Relationship Model:

a. Generalization Hierarchies:

b. Disjointness and Completeness

Constraints:

c. Multiple Levels of Generalization:

4. Notation Summary and Diagram Rules:

a. Notation Summary:

b. Diagram Rules:

5. Comparison to Other Notations:

a. ERD Variations:

b. Class Diagram Notation of the Unified

Modeling Language:

* Introduction:

@ Data Modeling:

A. Developing Data Models for Business

Databases:

1. Analyzing Business Data Modeling

Problems:

a. Guidelines for Analyzing Business

Information Needs:

b. Analysis of the Information Requirements

for the Water Utility Database:

2. Refinements to an ERD:

a. Transforming Attributes into Entity Types:

b. Splitting Compound Attributes:

c. Expanding Entity Types:

d. Transforming a Weak Entity into A Strong

Entity:

e. Adding History:

f. Adding Generalization Heirarchies:

g. Summary of Transformations:

3. Finalizing an ERD:

a. Documenting an ERD:

b. Detecting Common Design Errors:

4. Converting an ERD to Relational Tables:

a. Basic Conversion Rules:

b. Converting Optional 1-M Relationships:

c. Converting Generalization Hierarchies:

d. Converting 1-1 Relationships:

e. Comprehensive Conversion Example:

* Introduction:

@ Relational Database Design:

A. Normalization of Relational Tables:

1. Overview of Relational Database

Design:

a. Avoidance of Modification Anomalies:

b. Functional Dependencies:

2. Normal Forms:

a. First Normal Form:

b. Second and Third Normal Forms:

c. Boyce-Codd Normal Form:

d. Simple Synthesis Procedure:

3. Refining M-Way Relationships:

a. Relationship Independence:

b. Multivalued Dependencies and

Fourth Normal Form:

4. Higher Level Normal Forms:

a. Fifth Normal Form:

b. Domain Key Normal Form:

5. Practical Concerns about

Normalization:

a. Role of Normalization in the Database

Development Process:

b. Analyzing the Normalization Objective:

* Introduction:

@ Relational Database Design:

A. Physical Database Design:

1. Overview of Physical Database Design:

a. Storage Level of Databases:

b. Objectives and Constraints:

c. Input, Outputs, and Environment:

d. Difficulties:

2. Inputs of Physical Database Design:

a. Table Profiles:

b. Application Profiles:

3. File Structures:

a. Sequential Files:

b. Hash Files:

c. Multiway Tree (Birees) Files:

d. Bitmap Indexes:

e. Summary of File Structures:

4. Query Optimization:

a. Translation Tasks:

b. Improving Optimization Decisions:

5. Index Selection:

a. Problem Definition:

b. Trade-Offs and Diffuculties:

c. Selection Rules:

6. Additional Choices in Physical Database

Design:

a. Denormalization:

b. Record Formatting:

c. Parallel Processing:

d. Other Ways to Improve Performance:

* Introduction:

@ Application Development with

Relational Databases:

A. Advanced Query Formulation with

SQL:

1. Outer Join Problems:

a. SQL Support for Outer Join Problems:

b. Mixing Inner and Outer Joins:

2. Understanding Nested Queries:

a. Type I Nested Queries:

b. Limited SQL Formulations for

Difference Problems:

c. Using Type II Nested Queries for

Difference Problems:

d. Nested Queries in the FROM Clause:

4. Formulating Division Problems:

a. Review of the Divide Operator:

b. Simple Division Problems:

c. Advanced Division Problems:

5. Null Value Considerations:

a. Effect On Simple Conditions:

b. Effect on Compound Conditions:

c. Effect on Aggregate Calculations

and Grouping:

+ Usage of Multiple Statements in

Microsoft Access:

+ SQL: 2003 Syntax Summary:

+ Oracle 8i Notation For Outer Joins:

* Introduction:

@ Application Development with

Relational Databases:

A. Application Development With Views:

1. Background:

a. Motivation:

b. View Definition:

2. Using Views for Retrieval:

a. Using Views in SELECT Statements:

b. Processing Queries with View References:

3. Updating Using Views:

a. Single-Table Updatable Views:

b. Multiple-Table Updatable Views:

4. Using Views in Hierarchical Forms:

a. What Is a Hierarchical Form?

b. Relationship between Hierarchical

Forms and Tables:

c. Query Formulation Skills for

Hierarchical Forms:

5. Using Views in Reports:

a. What Is a Hierarchical Report?

b. Query Formulation Skills for

Hierarchical Reports:

+ SQL: 2003 Syntax Summary:

+ Rules for Updatable Join Views in Oracle:

* Introduction:

@ Application Development with

Relational Databases:

A. Stored Procedures and Triggers:

1. Database Programming Languages and PL/SQL:

a. Motivation for Database Programming

Languages:

b. Design Issues:

c. PL/SQL Statements:

d. Executing PL/SQL Statements in Anonymous

Blocks:

2. Stored Procedures:

a. PL/SQL Procedures:

b. PL/SQL Functions:

c. Using Cursors:

d. PL/SQL Packages:

3. Triggers:

a. Motivation and Classification of

Triggers:

b. Oracle Triggers:

c. Understanding Trigger Execution:

+ SQL: 2003 Syntax Summary:

* Introduction:

@ Advanced Database Development:

A. View Design and Integration:

1. Motivation for View Design and

Integration:

2. View Design with Forms:

a. Form Analysis:

b. Analysis of M-Way Relationships

Using Forms:

3. View Integration:

a. Incremental and Parallel Integration

Approaches:

b. View Integration Examples:

* Introduction:

@ Advanced Database Development:

A. Database Development for Student

Loan Limited:

1. Case Description:

a. Overview:

b. Flow of Work:

2. Conceptual Data Modeling:

a. ERD for the Loan Origination Form:

b. Incremental Integration after Adding

The Disclosure Letter:

c. Incremental Integration after Adding

the Statement of Account:

d. Incremental Integration after Adding

the Loan Activity Report:

3. Refining the Conceptual Schema:

a. Schema Conversion:

b. Normalization:

4. Physical Database Design and Application

Development:

a. Application and Table Profiles:

b. Index Selection:

c. Derived Data and Denormalization

Decisions:

d. Other Implementation Decisions:

e. Application Development:

+ Glossary of Form and Report Fields:

+ Create Table Statements:

* Introduction:

@ Managing Database Environments:

A. Data and Database Administration:

1. Organizational Context for Managing

Databases:

a. Database Support for Management

Decision Making:

b. Information Resource Management

to Knowledge Management:

c. Responsibilities of Data Administrators

and Database Administration:

2. Tools of Database Administration:

a. Security:

b. Integrity Constraints:

c. Management Of Triggers and Stored

Procedures:

d. Data Dictionary Manipulation:

3. Processess for Database Specialists:

a. Data Planning:

b. Selection and Evaluation of Database

Management Systems:

4. Managing Database Environments:

a. Transaction Processing:

b. Data Warehouse Processing:

c. Distributed Environments:

d. Object Database Management:

+ SQL: 2003 Syntax Summary:

* Introduction:

@ Managing Database Environments:

A. Transaction Management::

1. Basics of Database Transactions:

a. Transaction Examples:

b. Transaction Peoperties:

2. Concurrency Control:

a. Objective of Concurrency Control:

b. Interference Problems:

c. Concurrency Control Tools:

3. Recovery Management:

a. Data Storage Devices and Failure Types:

b. Recovery Tools:

c. Recovery Processes:

4. Transaction Design Issues:

a. Transaction Boundary and Hot Spots:

b. Isolation Levels:

c. Timing of Integrity Constraint

Enforcement:

d. Save Points:

5. Workflow Management:

a. Characterizing Workflows:

b. Enabling Technologies:

+ SQL: 2003 Syntax Summary:

* Introduction:

@ Managing Database Environments:

A. Data Warehouse Technology and

Management:

1. Basic Concepts:

a. Transaction Processing versus

Decision Support:

b. Characteristics of Data Warehouses:

c. Architectures for Data Warhouses:

d. Data Mining:

e. Applications of Data Warehouses:

2. Multidimensional Representation of Data:

a. Example of a Multidimensional Data Cube:

b. Multidimensional Terminology:

c. Time-Series Data:

d. Data Cube Operations:

3. Relational DBMS Support for Data Warehouses:

a. Relational Data Modeling for Multidimensional

Data:

b. Dimension Representation:

c. Extensions to the GROUP BY Clause for

Multidimensional Data:

d. Materialized Views and Query Rewriting:

e. Storage and Optimization Technologies:

5. Maintaining a Data Warehouse:

a. Sources of Data:

b. Workflow for Maintaining a Data Warehouse:

c. Managing the Refresh Process:

* Introduction:

@ Managing Database Environments:

A. Client-Server Processing, Parallel

Database Processing, and Distributed

Databases:

1. Overview of Distributed Processing and

Distributed Data:

a. Motivation for Client-Server

Processing:

b. Motivation for Parallel Database

Processing:

c. Motivation for Distributed Data:

d. Summary of Advantages and Disadvantages:

2. Client-Server Database Architectures:

a. Design Issues:

b. Description of Architectures:

3. Client-Server Database Architectures:

a. Design Issues:

b. Description of Architectures:

4. Parallel Database Processing:

a. Architectures and Design Issues:

b. Commercial Parallel Database

Technology:

5. Architectures for Distributed Database

Management Systems:

a. Component Architecture:

b. Schema Architectures:

6. Transparency for Distributed Database

Processing:

a. Motivating Example:

b. Fragmentation Transparency:

c. Location Transparency:

d. Transparency in Oracle Distributed

Databases:

7. Distributed Database Processing:

a. Distributed Query Processing:

b. Distributed Transaction Processing:

* Introduction:

@ Managing Database Environments:

A. Object Database Management Systems:

1. Motivation for Object Database

Management:

a. Complex Data:

b. Type System Mismatch:

c. Application Examples:

2. Object-Oriented Principles:

a. Encapsulation:

b. Inheritance:

c. Polymorphism:

d. Programming Languages versus DBMSs:

3. Architectures for Object Database

Management:

a. Large Objects and External Software:

b. Specialized Media Servers:

c. Object Database Middleware:

d. Object Relational Database Management

Systems for User-Defined Types:

e. Object-Oriented Database Management

Systems:

f. Summary of Object Database Architectures:

4. Object Database Features in SQL: 2003:

a. User-Defined Types:

b. Table Definitions:

c. Subtable Families:

d. Manipulating Complex Objects and

Subtable Families:

5. Object Database Features in Oracle 10g:

a. Defining User-Defined Types and Typed

Tables in Oracle 10g:

b. Using Typed Tables in Oracle 10g:

c. Other Object Features in Oracle 10g:

* STATE OF THE ART CURRICULUM DESIGN:

* NEW:

* ILLUSTRATIONS:

* GLOSSARY:

* BIBLIOGRAPHICAL REFERENCES & INDEX:

* PAPERBACK:

* PHOTOS:

* LEARNING OBJECTIVES:

* GLOSSARY:

* TRANSPARENT FRONT PAGE:

* BLACK-WHITE-RED OR BLUE BACK PAGE COVER:

* BINDED WIRE-0: BLACK-WHITE-RED OR BLUE:

* 500 WHITE PAGES: 8x11"

* ALLOW 4 TO 6 WEEKS TO RECEIVE ITEM:

* ORDER EARLY WHILE SUPPLIES LAST: