Your company decides to sell toys online and ships globally. An in-house team is responsible for developing the online shopping website. A customer’s sales order is stored in a master table and several detail tables. Which of the following is least related to the data integrity across relations?
A. Clark-Wilson Model
B. ACID (Atomicity, Consistency, Isolation, Durability)
C. Entity Integrity
D. Referential Integrity
Kindly be reminded that the suggested answer is for your reference only. It doesn’t matter whether you have the right or wrong answer. What really matters is your reasoning process and justifications.
My suggested answer is C. Entity Integrity.
Entity integrity means a table cannot exist repeated or duplicated record that has the same primary key. Entity integrity doesn’t involve other tables or work across tables (relations).
A customer’s sales order stored in a master table and several detail tables involves cross-table (cross-relation) operations that require transactions to protect the data integrity.
A transaction can generally refer to any change in a database. However, A transaction, in the context of a database, features a unit of work treated in a coherent and reliable way independent of other transactions.
- The Clark-Wilson Model is the theory behind a transaction. It proposed the concept of the well-formed transaction, constrained data item (CDI), and integrity verification procedure (IVP).
- ACID (Atomicity, Consistency, Isolation, Durability) is the properties of transactions.
- Referential Integrity in the relational database refers to the integrity between the master and detail tables. The value of a foreign key in a detail-table shall exist in the master table’s primary key.