The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many different vegetables, including onions, tomatoes, carrots, potatoes, squash, eggplants and zuchini. Among the queries your database should be capable of handling are:
1. List the customerid and names of all customers in the 06222 zip code.
2. List the names of all customers who bought more than 7 lbs of eggplants in a single order.
3. Get a count of the number of orders which included both squash and zuchini.
4. Get a count of the number of customers in the 06513 zip code who bought both carrots and cucumbers in a single order.
5. List the names of all customers who bought both tomatoes and potatoes (possibly in different orders).
6. List the names and zipcode of all customers who spent more than $300 (this could have been done over different orders).
7. List the name of the customer or customers who spent the most money in a single order.
8. Get the customerid, names and zipcode of all customers who did not buy anything.
9. Get a count of the number of customers who placed at least one order.
10. List the zipcodes in which at least one customer bought onions.
11. The basic information about customers (customer id, name and zipcode ) has to be entered using forms. For this query, you have to also give a printout showing what the form looks like i.e. what would it look like to the user who is using the form to enter the customer data.
12. You have to print out a report containing, for each zip code, a list of all the vegetable sold in that zip code.