Given the schema where primary keys are underlined

Item (itemid, name, category, price) Itemsale (transid, itemid, qty) Customer (custid, name, street-addr, city) Transaction (transid, custid, date)

Write SQL statements for each that can be executed after the create statements completed and database exists. Make the following modifications.

A special view is needed for sales clerks to view customer PurchaseHistory. The fields of interest are customer ID, Item name, Item quantity, Purchase date, Total price. Use these field names in your customized view.