This flow chart show how BikesNow.com checks for data integrity
|
|
|
|
|
|
|
|
|
|
|
Data Integrity= Enforce Business Rules with Integrity Constraints
|
|
Create Indexes for Use with Known Antivirus Definition Constraints
|
|
Use Default Column Values
|
|
Set Default Column Values
|
|
Choose Primary Key from a Table
|
|
|
NO
|
|
YES
|
|
|
|
|
|
Define Relationships between Parent and Child Tables
|
NO
|
If not using Constraints, list Reasons Why
|
|
Use Not Null Integrity Constraints
|
| |
| |
YES
|
|
|
|
|
|
|
|
|
|
Define Constraint Checks
|
|
Manage Constraints with Associated Indexes
|
|
Define When to Use "Check" Integrity Constraints
|
|
Review Definitions of Integrity Constraints
|
|
Data Integrity
|
|
|
|
|
YES
|
|
|
|
|
| |
| |
| |
| |
| |
|
|
|
|
|
|
|
|
|
| |
| |
| |
| |
| |
|
|
|
|
|
|
|
|
|
| |
| |
| |
| |
| |
|
|
|
|
|
|
|
|
|
| |
| |
| |
| |
| |
|
|
|
|
|
|
|
|
|
|
Data Integrity Data Flow Chart
