This illustration shows four tables. The employees table at ny.example.com and the employees table at sf.example.com are replicas. Here are the tables and their contents:

employees table at ny.example.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