Computer Science Assignment - Database Project

profileAmazingExpert
 (Not rated)
 (Not rated)
Chat

CSCI 2215 | Databases | 13 Fall | Course Project, Due: 12/4/13 Wednesday DUE 12/4/13, LATE SUBMISSIONS ACCEPTED TILL START OF CLASS ON 12/11/13 NOT ACCEPTED AFTER START OF CLASS ON 12/11/13 The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many dierent 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.

Document Preview:

CSCI 2215 | Databases | 13 Fall | Course Project, Due: 12/4/13 Wednesday DUE 12/4/13, LATE SUBMISSIONS ACCEPTED TILL START OF CLASS ON 12/11/13 NOT ACCEPTED AFTER START OF CLASS ON 12/11/13 The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many dierent 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 dierent orders). 6. List the names and zipcode of all customers who spent more than $300 (this could have been done over dierent 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. Please turn over to the other side for further instructions. 1 You need to turn in a hard copy (paper copy) of the following: 1. A description of any assumptions you are making in designing this database. 2. An...

  • 8 years ago
Database Project - Solution A+ Tutorial use as Guide
NOT RATED

Purchase the answer to view it

blurred-text
  • attachment
    database_project_-_solution.zip