Labels:text | screenshot | diagram | parallel OCR: Node B Employee Table Detail) Enp. No. Employee Name Dept No Filed linked through Node A Purchasing referential integrity - 5 2 Payroll 5 Department Table 3 Develcoment 5 (Master) 4 Support Dept. No. Name Purchasing Master row 10 Payroll being locked during detail 15 Development insert 20 Support Detail row being inserted FIGURE 1 Distributed referential integrity. In a master- detail relationship with insert and update restrictions on the detail table, and delete and update restrictions on the master table, a transaction that adds a row to the detail table must lock the corresponding row in the master table until the transaction completes.
