Illustration repma003.gif shows four tables. The employees table at ny.com and the employees table at sf.com are replicas. Here are the tables and their contents:

employees Table at ny.com

employee_id last_name department_id salary commission_pct
100 Jones 20 55,000 .4
101 Kim 20 62,000 .25
102 Braun 20 43,500 .1

employees Table at sf.com

employee_id last_name department_id salary commission_pct
100 Jones 20 55,000 .4
101 Kim 20 62,000 .3
102 Braun 20 43,500 .1
103 Rama 20 48,750 .35

missing_rows_data Table

employee_id salary commission_pct rowid
101 62,000 .25 000015E8.0000.0002
101 62,000 .3 000015E8.0001.0002
103 48,750 .35 000015E8.0002.0002

missing_rows_location Table

present absent r_id
ny.com sf.com 000015E8.0000.0002
sf.com ny.com 000015E8.0001.0002
sf.com ny.com 000015E8.0002.0002