For the assignment I want you to insert the material for sale and saledetail. Use the data in the page Data Samples for Co-op. Remember you will need to reorganize it some. Look at the script I provided, especially the part for purchase and purchasedetail. The assignment is very similar to that part of the script.

You will need to look up the memberid and employeeid. You will also need to look up the inventoryid for salesdetail. You can use these queries to look up the id that goes with the name:

elect memberid, Lastname, firstname from person join coopmember using(personid); Select employeeid, lastname, firstname from person Join employee using(personid); Select * from inventory;