SQL Distributed Databases

Assume the Customer table exists as follows: cust_id name 1 Smith 2 Mou 3 Golub 4 Chin 5 Harris 6 Bjorn 7 Kumar 8 Swenson credit_limit 10,000 15,000 5,000 10,000 15,000 10,000 5,000 12,000 balance state 7,000 TX 2,000 MD 0 MD 3,000 NY 10,000 MD 3,000 NY 4,000 TX 1,000 TX The primary key of Customer is cust_id. The following queries are executed from sites S1, S2, and S3: q1: SELECT FROM WHERE cust_id, name Customer state = - 'TX' q2: SELECT FROM WHERE name, balance Customer state = 'MD' q3: SELECT FROM WHERE cust_id, name, balance Customer state = 'NY' 94: SELECT FROM WHERE cust_id, balance, credit limit Customer credit_limit > 11,000 95: SELECT FROM WHERE cust_id, balance, credit_limit, state Customer credit limit 11,000 95: SELECT FROM WHERE cust_id, balance, credit_limit, state Customer credit limit