Reference no: EM13895307
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.
|
The elementary and secondary education
: The bill that reauthorized the Elementary and Secondary Education Act, formally known as the No Child Left Behind is known as the Every Child Achieves Act. This new enactment rolls out critical improvements. In what manner can this suggestion be asse..
|
|
Prepare journal entries to record
: Prepare journal entries to record the following transactions and events applicable to the calendar year 2013 operations of Lily City:
|
|
Why do you think so many firms are concerned about logistics
: Why do you think so many firms are concerned about logistics issues when they move into new markets such as China and Russia?
|
|
Are there obstacles to implementing this program
: Are there obstacles to implementing this program? If so, how might they be overcome?
|
|
Create a database for use by the employees
: 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
|
|
Causes the dependent variable
: True or false? EXPLAIN all of your answers briefly. (Without explanation you will not get credit) (a) A simple linear regression equation is to see if the explanatory variable (xi) causes the dependent variable (yi) (b) SEE ATTACHMENT FOR THE REST
|
|
What are critical trade-off involve in logistic postponement
: What are the critical trade-offs involved in logistics postponement? What are the critical linkages between the logistics management system and other functions such as production and purchasing?
|
|
The following information is available
: The following information is available from the financial statements of Rawhide Industries Inc.:
|
|
Should jones choose the consolidated shipment alternative
: However, one carrier quoted a transportation cost of $20 per hundredweight for a consolidated shipment, with an additional charge of $200 for each stop on the delivery. Should Jones choose consolidated shipment alternative?
|