Match the following with respect to RDBMS : \(\begin{array}{clcl} \text{(a)} &…
2017
Match the following with respect to RDBMS :
\(\begin{array}{clcl} \text{(a)} & \text{Entity integrity} & \text{(i)} & \text{enforces some specific business rule that do not} \\ &&& \text{fall into entity or domain} \\ \text{(b)} & \text{Domain integrity} & \text{(ii)} & \text{Rows can’t be deleted which are used by} \\ &&& \text{other records} \\ \text{(c)} & \text{Referential integrity} & \text{(iii)} & \text{enforces valid entries for a column} \\ \text{(d)} & \text{Userdefined integrity} & \text{(iv)} & \text{No duplicate rows in a table} \end{array}\)
Code :
- A.
(a)-(iii); (b)-(iv); (c)-(i); (d)-(ii)
- B.
(a)-(iv); (b)-(iii); (c)-(ii); (d)-(i)
- C.
(a)-(iv); (b)-(ii); (c)-(iii); (d)-(i)
- D.
(a)-(ii); (b)-(iii); (c)-(iv); (d)-(i)
Attempted by 692 students.
Show answer & explanation
Correct answer: B
Correct matching and brief explanations:
Entity integrity → No duplicate rows in a table. Ensures each row can be uniquely identified (primary key).
Domain integrity → Enforces valid entries for a column. Controls data type, permissible values, and value ranges for attributes.
Referential integrity → Rows can’t be deleted which are used by other records. Maintains consistency of foreign key relationships between tables.
User-defined integrity → Enforces some specific business rules that do not fall into entity or domain constraints. Used for application-specific or organization-specific constraints.
So the correct mapping is: (a) Entity integrity → No duplicate rows; (b) Domain integrity → Enforces valid entries for a column; (c) Referential integrity → Rows referenced by other records cannot be deleted; (d) User-defined integrity → Enforces specific business rules.
A video solution is available for this question — log in and enroll to watch it.