Written in SQL language

--13. Customer 9999 changed his mind again and stated that he will --never order from us. Please remove him from the database

/* 14. Create the following table with appropriate integrity constraints:

tblPizzaVendors

VendorID VendName VendAddress VendCity VendState VendPhone */

/* 15. Populate the table above with the following records: VendorID VendName VendAddress VendCity VendState VendPhone 100 Crystal Farms 123 First Anywhere MN 555-555-1212 150 Morrell Meats 555 Second NoWhere MN 555-222-1111 */

/* 16. Revise the PizzaShop E-R Diagram that defines how this new table will be incorporated into the relational model use the PizzaShop.vsd to add the new table. Note: Vendors supply the ingredients to make pizzas */

/*17. Create a view that displays the all customer orders (name, order date, size, ingredients and delivery type. This will be used to query customers when they call in for new orders. Name the view CustomerOrders. */

--18. Create a list of customers that ordered Anchovies.

--19. Create a list of customers that do not live in our delivery area.

--20 Create a query that displays how many pizzas we have sold/ordered by size. -- Note: Please include the full description

--21 Create a list of customers that have ordered a pizza in --January 2013 and February 2013, but did NOT order a pizza in March 2013.

CUSTOMER Orderingredients Orders Pizzalngredients CustID Orderid + PK EK Orderid ... > PK IngrediD FirstName FK Ingredienti Order Date IngredDesc Last Name Order Time Street Order Type DeliveryTime PK City PK Order Type OrderType CustID State OrderType Order Desc Phone Number SizeID PizzaCrust ZipCode Crustid >0 # PK CrustID CrustType Delivery Area PizzaSize LPK Zip Code HPK SizelD CityName SizeDesc attribute name