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?
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?
You've reached the end of your free preview.
Want to read all 4 pages?
- Summer '19
- Foreign key, ALTER USER command