Need help with preparing answers for questions.
Preparation for Question 1
- You need to understand data integrity in relational database systems, which has the following three forms:
Ø Entity integrity: Primary key values must be unique.
Ø Domain Integrity: "CHECK" statements ensure plausible values are stored in data fields.
Ø Referential integrity: Values of foreign keys either (1) match values from a source table, or (2) are null.
- You need to prepare one or more scenarios to illustrate how these three forms of data integrity are help to protect data.
- You need to discuss why data integrity is important.
Prepare for Question 2
- You need to understand the four ACID properties (Atomicity, Consistent, Isolated, and Durability) of a database transaction, as listed below:
Ø Atomic:
Ø Consistency
Ø Isolation:
Ø Durability:
- You need to prepare two or more scenarios to illustrate your understanding of these ACID properties. At least one scenario should involve locking and show the differences between read and write locks.