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.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 03:30

In return for their with optimizing his painting project, the castle servant informed poly and digit that he saw someone dressed as the king leaving behind a trail of crumbs as he walked into the jester's room late last night. poly and digit have finally found the crisp-collecting culprit â€” it turns out the jester's shoe size and hair color match the clues that were found! in gratitude, poly and digit agree to the servant with his current task of replacing all of the tables and chairs in the castle. his goal is to determine which furniture company should produce the new furniture. he receives information from a company that customizes elegant furniture, and he wants to analyze the company's production process in order to calculate some problems about cost and availability. read the following scenario, and assist poly and digit as they the servant with his calculations. the fit for a king furniture company requires 2020 hours of labor to produce a standard table, and a chair requires 1212 hours of labor. the labor available is 565565 hours per week. the company can produce at most 3535 chairs per week.

Answers: 1

Answer

Business, 22.06.2019 10:00

Employees at a library check out books to patrons. books have an isbn and a name. the library sometimes has multiple copies of the same book. books have one or more authors. a patron is an individual who has an active (non-expired) library card. for each library card, we store the person's first and last names and their address. for each employee, we store their employee id, current salary, first and last name and their address. we also store the employee id of their current manager. each time we check out a book to a patron we need to store the date of the transaction, the employee who checked out the book to the patron, and the library card of the patron. some employees have library cards. if an employee patron turns in a book late, the fine that they pay is a percentage of their salary. some employees are authors who have library cards—they are allowed to check out as many books as they like.

Answers: 1

Answer

Business, 22.06.2019 20:00

In myanmar, six laborers, each making the equivalent of $ 2.50 per day, can produce 40 units per day. in china, ten laborers, each making the equivalent of $ 2.25 per day, can produce 48 units. in billings comma montana, two laborers, each making $ 60.00 per day, can make 102 units. based on labor cost per unit only, the most economical location to produce the item is china , with a labor cost per unit of $ . 05. (enter your response rounded to two decimal places.)

Answers: 3

Answer

Business, 22.06.2019 20:50

Which of the statements best describes why the aggregate demand curve is downward sloping? an increase in the aggregate price level causes consumer and investment spending to fall, because consumer purchasing power decreases and money demand increases. as the aggregate price level increases, consumer expectations about the future change. as the aggregate price level decreases, the stock of existing physical capital increases. as a good's price increases, holding all else constant, the good's quantity demanded decreases.

Answers: 2

Answer

You know the right answer?

Urban delivery is a company that delivers packages to customers. The staff are paid an hourly rate p...

Questions