The conceptual schema diagram shown on the next page incorporates the use of var

Question

The conceptual schema diagram shown on the next page incorporates the use of various constraints to enforce the rules of a particular universe of discourse. Apply each transaction shown in the table below the diagram to the population shown in tables F1…F6 and indicate whether the transaction is accepted (A) or rejected (R). If a transaction is rejected, indicate which constraint has been violated. Each of the transactions applies to the same schema population shown in the tables. Treat each transaction as if it was the first to be made with the proposed population.

F1 0.2B 13(b) (a#) c8 F4 c6 F3 c11 (ca) (d#) (e#) F5 c7 12 F1 F2 F3 bl b1 d2 e2 c3 d3 (a2,b1)e2 (a3,b2)et F6 a2 a3 F5 c1 d1 d1 d2 Accept Constraint Reject violated TRANSACTION Example: Add (dl, e3) to F3 Remove (cl,d,el) from F6 Add (c3.d3,e2) to F6 Add (cl,d2) to F5 Add (c2.d1) to F4 Add (c3.d,e) to F6 Remove (c2,d2) from F4 Add (al,b2) to Fl and add ((al.b2), el) to F2 Remove (c2,d2,e2) from F6 Add ((a4,b2),e3) to F2 Add (c1,d2,e2) to F6

Explanation / Answer

The constraints which are violated here basically comes under two categories:
1. PrimaryKey: The primary key values are repeated
2. Foreign Key: The values under representing foreign keys are deleted

1) A
2)R C7
3)R C10
4)A
5)A
6)A
7)R C4
8)A
9)A
10)A

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.