CS540_C_HW8_14223_NISHANT_PATEL.docx - CS540_C_HW8_14223_NISHANT_PATEL Course ID CS540 Student ID 14223 Section ID C Name Nishant Patel Homework-8 1

CS540_C_HW8_14223_NISHANT_PATEL.docx -...

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

CS540_C_HW8_14223_NISHANT_PATEL Course ID :- CS540 Student ID :- 14223 Section ID :- C Name :- Nishant Patel Homework :-8 1 : Briefly describe what data integrity means is and how they can be maintained?
Image of page 1
Data Integrity means data in a database adheres to business rules. There are three primary ways in which data integrity can be maintained: 1. Application Code 2. Database Triggers 3. Declarative Integrity Constraints 2 : Briefly describe what are constraint states? An integrity constraint can be enabled or disabled. If a constraint is enabled, data is checked as it is entered or updated in the database. Data that does not confirm to the constraint’s rule prevented from being entered. If a constraint is disabled, then data that does not confirm can be entered into the database. An integrity constraint can be in one of the following states: 1. DISABLE NOVALIDATE 2. DISABLE VALIDATE 3. ENABLE NOVALIDATE 4. ENABLE VALIDATE 3: Briefly describe what is constraint checking?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Summer '19
  • Foreign key, ALTER USER command

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture