subject
Business, 21.05.2021 03:40 Svetakotok

Urban delivery is a company that delivers packages to customers. The staff are paid an hourly rate plus a fixed dollar amount for every package delivered. You are asked to write an application for the Urban company, and you are in charge of database design and implementation. They want to track the number of packages delivered per day by each staff and the number and weight of packages delivered for customers. The company want to generate the employee paychecks as well. Business Rules:
1. The application should store the first name, last name, job rating, Social security number, employee ID, address and phone number for each employee.
2. Each employee is in a rate category and their hourly payment is based on their rating.
3. Your design should store weight and delivery date for each package.
4. For each package that they deliver they will get $1 regardless of the weight or size of package.
5. The address of customers is saved in the system, and the packages will be delivered just for the customers.
6. The number of packages delivered per day by each staff must be calculated.
7. The number of packages delivered for each customer per day must be calculated.
8. The number of hours an employee works daily must be calculated.
9. A package must have only one Delivery associated with it.

Required:
Identify the Functional Dependencies to separate the attributes into related Entities as necessary.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 03:40
2. the language of price controls consider the market for rental cars. suppose that, in a competitive market without government regulations, the equilibrium price of rental cars is $58 per day, and employees at car rental companies earn $19.50 per hour. complete the following table by indicating whether each of the statements is an example of a price ceiling or a price floor and whether it results in a shortage or a surplus or has no effect on the price and quantity that prevail in the market. statement price control effect there are many teenagers who would like to work at car rental companies, but the minimum-wage law sets the hourly wage at $23.00. the government has instituted a legal minimum price of $87 per day for rental cars. the government prohibits car rental companies from renting out rental cars for more than $87 per day.
Answers: 2
question
Business, 22.06.2019 11:20
You decided to charge $100 for your new computer game, but people are not buying it. what could you do to encourage people to buy your game?
Answers: 1
question
Business, 22.06.2019 21:10
Ahospital purchases a $500,000 magnetic resonance imaging (mri) machine that has a useful life of 9 years. the salvage value at the end of 9 years is $77,000. (a) write a linear equation that describes the value y (in dollars) of the mri machine in terms of the time t (in years), 0 ≤ t ≤ 9. (b) find the value, in dollars, of the machine after 6 years. $ (c) find the time, in years, when the value of the equipment will be $140,000. (round your answer to two decimal places.) yr
Answers: 2
question
Business, 22.06.2019 22:50
Wendy made her career planning timeline in 2010. in what year should wendy's timeline start? a. 2013 o b. 2012 oc. 2010 o d. 2011
Answers: 2
You know the right answer?
Urban delivery is a company that delivers packages to customers. The staff are paid an hourly rate p...
Questions
question
Mathematics, 10.03.2021 22:40
question
Mathematics, 10.03.2021 22:40
question
Mathematics, 10.03.2021 22:40
question
Mathematics, 10.03.2021 22:40
Questions on the website: 13722367