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)

You are assisting the database administrators to build the SQL database:

Write SQL statements to create the complete database presented in the schema above. Make appropriate domain and constraint assumptions.