NOTE : that the same field name can have a different meaning in different tables. The same field may have a different name in two tables. You may NOT change the field names. You may NOT reference a field with a table name (ex CUST.C#)

CUST This is a table with information about customers of DU Corp. The attributes are: C# Customer # NAME Customer Name CITY City (where the Customer Score (number C SCORE customer is located)between O and 10) 532 John Smith Chicago 6 PROD This is a table with information about the products that the company currently sells. Product #s are unique, but names are not. The attributes are: NUM H UPRICE product) 123.56 True NEW P# Product # NAME Product Name Number on Hand Unit Price (Price of each Boolean field that (Inventory) specifies if the product is new or used 9A2B Desk ORDERS This is a table with information about the orders received by the company. Not all of the customers currently have orders placed. customer can have multiple orders. An order can have multiple products in it, but each product would only appear once. The attributes are: .NUM Customer Number P# Product Number QNTY Quantity Purchased pecial SPECIAL ORDER# Order# 238 532 9A2B Ship Frozen 1. What are the primary keys for these three tables? C# PA . ORDER# 2. Write a query to get the number and name for all customers that are located in Elgin and have scores under 6. SELECT C#, NAME FROM CUST WHERE CITY Elgin, AND C-SCORE