Question

Table 1 :Salesman table
salesman_id | name | city | commission
-------------+------------+----------+------------
5001 | James Hoog | New York | 0.15
5002 | Nail Knite | Paris | 0.13
5005 | Pit Alex | London | 0.11
5006 | Mc Lyon | Paris | 0.14
5007 | Paul Adam | Rome | 0.13
5003 | Lauson Hen | San Jose | 0.12

Table 2: order
ord_no purch_amt ord_date customer_id salesman_id
---------- ---------- ---------- ----------- -----------
70001 150.5 2012-10-05 3005 5002
70009 270.65 2012-09-10 3001 5005
70002 65.26 2012-10-05 3002 5001
70004 110.5 2012-08-17 3009 5003
70007 948.5 2012-09-10 3005 5002
70005 2400.6 2012-07-27 3007 5001
70008 5760 2012-09-10 3002 5001
70010 1983.43 2012-10-10 3004 5006
70003 2480.4 2012-10-10 3009 5003
70012 250.45 2012-06-27 3008 5002
70011 75.29 2012-08-17 3003 5007
70013 3045.6 2012-04-25 3002 5001

1. Create both the tables after identifying the primary and foreign key (Marks 5)
2. In table 1, City names that are permitted are: New York, Paris, London, Rome, San Jose (2.5)
3. Commission should not be higher than .2 (2.5)

Answer 1

Answer:

he is going to be held in the morning to see how much ma and your family too a very nice pic of your to get the school to get a new one and I will be there at the same time I am not sure if you need to talk to you about it when I get home and let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else from me please let me know if you need anything else please let me know if this will work for you need to talk to you about something else from me please let me know if you need anything else from me