3 Aug 2001 Due: 10 Aug 2001 ------------------------------------ Schema ------ CLIENT (client_id, name, city); PRODUCT(product_id, description, cost); SALESMAN(salesman_id, name, target, city); SALES_ORDER(order_id, date, client_id, salesman_id); ORDER_DETAILS(order_id, product_id, quantity); For each relation, the fields with _id suffix together form the primary key except in the case of SALES_ORDER where order_id is the primary key. Write SQL queries to implement the following. Make sure to eliminate duplicates where they may be generated. We have provided sample data to test your queries. The sample data should be loaded into your oracle area. Check your answers against manually calculated answers from the data. Note: Just because a query gives the correct answer on this data does not mean it is correct, so verify it logically. Zero marks for wrong queries even if they give the right answer on this data. --------------------------- Queries: 1. Print descriptions of products that have been ordered atleast once. 2. Print all cities in which atleast one client or salesman is located. 3. Print names of all salesmen in cities with more than one salesman 4. Print names of clients who have ordered products before a specified date (say 3 August 2001). 5. Print descriptions of all products ordered by leopards (client name equals leopard) 6. Print descriptions of all products ordered by leopards and sold by a saleman located in the city "IIT Powai" 7. Print the names of all salesmen who have sold leopards (product description equals leopard)