home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 3 / Developers_Source_Vol_03_1996.iso / dbmsa / mar95 / pric11.gif < prev    next >
Graphics Interchange Format  |  1995-08-06  |  84.5 KB  |  425x384  |  8-bit (164 colors)
   ocr: Node B Employee Table Detail Emp.No. Employee Name Dept. No Filed referential linked integrity through Node A Purchesing 5 2 Payroll 5 Department Table Develcpment a (Master) Support 10 Dept No. Name 5 Perchasing Master row 10 Payroll being locked 15 Development during detail 20 Suppot insert 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 m ...