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:
