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