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, 21.06.2019 14:20
Xt year baldwin plans to include an additional performance bonus of 0.25% in its compensation plan. this incentive will be provided in addition to the annual raise, if productivity goals are reached. assuming the goals are reached, how much will baldwin pay its employees per hour?
Answers: 2
question
Business, 22.06.2019 04:50
Problem 9-5. net present value and taxes [lo 1, 2] penguin productions is evaluating a film project. the president of penguin estimates that the film will cost $20,000,000 to produce. in its first year, the film is expected to generate $16,500,000 in net revenue, after which the film will be released to video. video is expected to generate $10,000,000 in net revenue in its first year, $2,500,000 in its second year, and $1,000,000 in its third year. for tax purposes, amortization of the cost of the film will be $12,000,000 in year 1 and $8,000,000 in year 2. the company’s tax rate is 35 percent, and the company requires a 12 percent rate of return on its films. required what is the net present value of the film project? to simplify, assume that all outlays to produce the film occur at time 0. should the company produce the film?
Answers: 2
question
Business, 22.06.2019 11:50
Select the correct answer. ramon applied to the state university in the city where he lives, but he was denied admission. what should he do now? a.change his mind about graduating and drop out of high school so he can start working right away. b. decide not to go to college, because he didn’t have a backup plan. c.stay positive and write a mean letter to let the college know that they made a bad decision. d. learn from this opportunity, reevaluate his options, and apply to his second and third choices.
Answers: 2
question
Business, 22.06.2019 14:20
In canada, the reference base period for the cpi is 2002. by 2012, prices had risen by 21.6 percent since the base period. the inflation rate in canada in 2013 was 1.1 percent. calculate the cpi in canada in 2013. hint: use the information that “prices had risen by 21.6 percent since the base period” to find the cpi in 2012. use the inflation rate formula (inflation is the growth rate of the cpi) to find cpi in 2013, knowing the cpi in 2012 and the inflation rate. the cpi in canada in 2013 is round up your answer to the first decimal. 122.9 130.7 119.6 110.5
Answers: 1
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, 01.04.2021 20:10
question
Social Studies, 01.04.2021 20:10
question
Mathematics, 01.04.2021 20:10
Questions on the website: 13722361