Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Creating Databases » Ensuring data integrity


How your data can become invalid

Data in your database may become invalid if proper checks are not made. You can prevent each of these examples from occurring using facilities described in this chapter.

Incorrect information
  • An operator types the date of a sales transaction incorrectly.

  • An employee's salary becomes ten times too small because the operator missed a digit.

Duplicated data
  • Two different employees add the same new department (with DepartmentID 200) to the Departments table of the organization's database.

Foreign key relations invalidated
  • The department identified by DepartmentID 300 closes down and one employee record inadvertently remains unassigned to a new department.