Match the following with respect to RDBMS: A. Entity integrity 1. Application-specific business rules beyond the general entity, domain and referential constraints B. Domain integrity 2. Foreign-key values must match a referenced key, except where NULL is permitted C. Referential integrity 3. Column values must satisfy the defined domain D. User defined integrity 4. Primary-key values must be unique and non-NULL
A - 4, B - 3, C - 2, D - 1
The matching is A–4, B–3, C–2, D–1. Entity integrity requires a unique, non-NULL primary key; domain integrity constrains column values; referential integrity maintains valid foreign-key references; user-defined integrity enforces additional business rules. Referential integrity can be maintained by actions such as cascading deletion, so it does not always prohibit deleting a referenced row.
Important Questions from Integrity Constraints and Normal Form
- The ________ normal form is based on the concept of transitive dependency.
- In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as :
- In a relational database model, NULL values can be used for all but which one of the following ?
