CS540_C_HW#8_14072_LAVANYA - Course ID CS540_C Student ID 14072 Student Name Lavanya Soma Homework 08 1 Data integrity means that data in a database

CS540_C_HW#8_14072_LAVANYA - Course ID CS540_C Student ID...

This preview shows page 1 - 3 out of 4 pages.

Course ID : CS540_C Student ID : 14072 Student Name: Lavanya Soma Homework # : 08 1) Data integrity means that data in a database adheres to business rules. There are three primary ways in which data integrity can be maintained: Application Code Database triggers Declarative integrity constraints 2) An integrity constraint can be enabled (ENABLE) or disabled (DISABLE). If a constraint is enabled, data is checked as it is entered or updated in the database. If a constraint is disabled, then data that does not confirm can be entered into the database. An integrity constraint can be one of the following states: DISABLE NOVALIDATE DISABLE VALIDATE ENABLE NOVALIDATE
Image of page 1
ENABLE VALIDATE 3) Constraint checking: You can defer checking constraints for validity until the end of the transaction. Nondeferred constraints are enforced at the end of every DML statement. A constraint violation causes the statement to be rolled back. If a constraint causes an action such as cascade, the action is taken as part of the statement that caused it. A constraint that is
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '16
  • data integrity, password history

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture