Data Integrity - Volume 8

Curriculum Design and Instruction To Teach

The Fundamentals Of Structured Query

Language (SQL): Data Integrity: Volume 8:



Author: Charles Hayes:


SQL commonly expanded as Structured Query

Language, is a computer language designed

for the retrieval and management of data in

relational database management systems,

database schema creation and modification,

and database object access control management.

SQL has been standardized by both ANSI and ISO.






Special Features Include:


Phases For Conducting A Needs Assessment:

Curriculum Design Supplement:

Curriculum Design Plan:

Lesson Plans:

Test:

Instructional Goals:

Instructional Objectives:

Instructional Activities:

Instructional Evaluation Techniques:

Standard Vocabulary:

A Limited Glimpse:



Topics Include:

@. Data Integrity:

A. Introduction:

1. Referential Integrity:

A. The concept of Referential Integrity:

B. An example of Referential Integrity:

C. Inserts and updates to the data table

prevented by RI:

D. Inserts and updates to the data

table allowed by RI:

E. Updates and deletes to the lookup

table prevented by RI:

F. How to delete a code from the

lookup table:

G. How to change a code in the

lookup table:

H. RI as a relationship between

the tables:

I. Setting up RI in the Access GUI:

2. The Delete Options and Update

Options Of RI:

A. The three options for deletes and

updates to the lookup table:

B. The delet rule: set null:

C. The delete rule: cascade:

D. The update rule: cascade:

3. Variations of referential

Integrity:

A. The two meanings of primary key:

B. Using two or more columns for

the primary key:

C. The lookup and data tables can

be the same table:

4. Other types of Constraints:

A. Check constraints:

B. Unique constraints

C. Not null constraints:

D. Primary key constraints:

E. Restrictions on the datatype and

length of fields:

F. Constraints are often coded in the

create table statement:

5. Summary:

* STATE OF THE ART CURRICULUM:

* NEW:

* BIBLIOGRAPHICAL REFERENCES & INDEX:

* ILLUSTRATIONS:

* PHOTOS:

* PAPERBACK:

* TRANSPARENT FRONT PAGE:

* BLACK OR WHITE BACK PAGE COVER:

* BINDED: BLACK OR WHITE COIL:

* 150 PAGES: 8x11"

* ALLOW 10 TO 14 DAYS TO RECEIVE ITEM:

* ORDER EARLY WHILE SUPPLIES LAST: