Create the relationships between the tables

Reference no: EM133414783

Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in.The organization has many teams of workers who travel from location to location picking or harvesting different crops, such as strawberries, grapes, watermelons, cantaloupe, oranges, grapefruit, and apples, among others.Unlimited Pickers has been in business for a few years, but has seen demand skyrocket in recent months (because of recent Executive Action to reduce the number of undocumented foreign workers).

Customers, i.e., the farms who want to hire Unlimited Pickers teams, pay a small fee to the organization to reserve one or more teams of pickers.The workers are paid based on the quantity of the produce that they harvest, typically by the pound.(Note that some customers are large organizations, while others are quite small in the amount of produce grown.)

Unlimited Pickers would like for you to assist with the creation of a database program to help better manage their data and will include several queries.Some test data has been pulled from their paper-based business records and placed into a spreadsheet for you to use in designing and building the database.(The spreadsheet file is: HW 6 _ Unlimited Packers_data.)

Specifically they need for you to do the following:

Create the table(s), field(s), data type(s), primary key(s), etc. for the database and populate it with the data provided in the Excel file.
Create the relationship(s) between/among the tables, as appropriate.
Label the database with your last name and HW#6
Create a query that will select records for customers who had their first pickup in May 2011. Sort into alphabetical order by Business Name. Save the query as July 2011 - First Picking Query.
Create a query that will select customers who had less than 50 pounds of produce picked for Grapes, Apples, Strawberries or Watermelon.The query should include the Service Date, Customer Number, Business Name, and the Weight fields from those attributes. Sort into descending order by Business Name.Save the query as Low Volume Query.
Create a query to determine the total weights (summation) for each type of produce (five products-grapes, apples, grapefruit, watermelon, strawberries) picked by each customer.Sort by Business Name.Save the query as Customer Total Weight Query.
Create a query to calculate the payment for each picking for grapefruit and strawberries.Include the Business Name, Picking Date (descending), the weight and product payment for both types of produce.Value should be in currency.Save the query as Produce Value Query.
Create a query and a report to calculate the total payment (e.g. total by company) for grapes and watermelon (two columns) for each customer.Include the Business Name (ascending) and the payments (in currency format).In the report, break it out by state. Save the query as Grapes-Watermelon Query.The report should subsequently also be named.In the report, execution a summation by state

Reference no: EM133414783

Questions Cloud

Event you attended or the podcast to which you listened : Event you attended or the podcast to which you listened. Your presentation must include a presentation (PowerPoint, Google Slides, Prezi) or any other software

What are the implications for future research : What were the results? What are the implications for future research? For a non-research article, what where the major findings or points that the author

Criminal justice their is racial disparity in sentencing : In criminal justice their is racial disparity in sentencing. How will the program or policy be set up? What training and qualifications are required for staff?

Explain why each is significant : What were the three most historically significant things that struck you about this short video? List them

Create the relationships between the tables : Create the relationships between the tables, as appropriate. Label the database with your last name and HW#6

Offense punishable by incarceration : An offense punishable by incarceration, usually in a local confinement facility, for a period whose upper limit is prescribed by statute in a given jurisdiction

Describe the two presidents and the two leadership theories : Describe the two presidents and the two leadership theories you selected for this assignment. Discuss the characteristics and behaviors of the selected

What is the plan to handle the burglary : What should be done about the truck? What is the plan to handle the burglary. How would you tactically deploy and resolve this incident?

Develop a hypothetical study of communication : Develop a hypothetical study of communication, with a well-defended thesis, and apply at least one of the theories from your textbook in the paper

User Account

All Pages