Data-Integrity
- Anomalies: Error in data integrity.
- Entity Integrity
- uniqueness (ID's)
- Referential Integrity
- reference ID from one table in another table
- foreign key
- Domain Integrity
- Each rows values should have validation (column: phone number value: cake should not be allowed because cake is not a 10 digit number)
- Data types
- Foreign Key
- Normalization: Process of insuring Data Integrity
Backlinks