Question: Apply each transaction shown in the table on the figure to the population shown on the diagram and indicate whether the transaction is accepted (A)
Apply each transaction shown in the table on the figure to the population shown on the diagram and indicate whether the transaction is accepted (A) or rejected (R). If a transaction is rejected, indicate which constraint has been violated
| TRANSACTION | Acc/Rej |
| Example: Add (d1, e3) to F3 | R c3 |
| Delete (a2,b1,b1) from F4 |
|
| Add (a2, a2, d4) to F5 |
|
| Delete (a3, b1, b3) from F4 |
|
| Add (a1, b3, b4) to F4 and (b4, e2) to F2 | |
| Change (a1, b2) to (a2, b1) in F1 |
|
| Add (a1, b3, b2) to F4 |
|
| Add (a1, b2, b2) to F4 and (b2, e1) to F2 |
|
| Change (a3, b2, b1) to (a3, b2, b2) in F4 and add (b2, e3) to F2 |
|
| Delete all instances of all fact types that contain b2 | |
| Delete (a1, b1) from F1 |
|
OPTIONS for every answer:
Accepted
Rejected c1
Rejected c2
Rejected c3
Rejected c4
Rejected c5
Rejected c6
Rejected c7
Rejected c8
Rejected c9
Rejected c10
Rejected c11
Rejected c12
d1 e4 d2 e2 d3 e1 F5 c11 D D# F3 c3 a2 b1 b1 a3 b2 b1 a3 b1 b3 F4 04 11 c10 c12 F2 B B# E# c7 F1 c1 c2 A# b3 e2 b3 e1 b1 e1 a3 b3Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts