How does a relational database ensure data integrity?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. By enforcing rules defined in the schema
Explanation
Integrity is enforced through schema constraints: domain, NOT NULL, key, entity- and referential-integrity rules.More Database Management Systems questions
- Fifth normal form is concerned with:
- Consider the transactions T1, T2, T3 and the schedules S1 and S2 given below. T1: r1(x); r1(z); w1(z) T2: r2(y); r2(z); w2(z) T3: r3(y); r3…
- Which of the following relations can NOT be decomposed into BCNF with a lossless join and dependency-preserving decomposition?
- Which of the following best describes the structure of a relational database?
- Arrange the following phases of database design in the correct order: (A) Physical Design (B) Conceptual Design (C) Logical Design (D) Requ…
- "CREATE TABLE T" in SQL is an example of: