design some tables (giving table name and column names) that can hold items for an online shopping cart. The cart should indicate what from inventory is being ordered and the quantity and the customer. The inventory table should contain the number of items in stock, a description and the price. Customers should be identified by name and email address.

Write a SELECT statement that will print out all shopping cart items for a single customer in your tables from question above

Write an INSERT statement to insert a purchase of a quantity of 5 of some item from the inventory