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

Other questions on the subject: Business

image
Business, 21.06.2019 14:00, pennstatealum
After creating an organizational strategy based on porter’s models, a company can a) create process models. b) calculate inputs and outputs. c) examine market structure. d) develop information systems. only answer if you're positive! you!
Answers: 2
image
Business, 22.06.2019 10:30, cocoapop
You meet that special person and get married. amazingly your spouse has exactly the same income you do 47,810. if your tax status is now married filing jointly what is your tax liability
Answers: 2
image
Business, 22.06.2019 12:30, ash011519
On june 1, 2017, blossom company was started with an initial investment in the company of $22,360 cash. here are the assets, liabilities, and common stock of the company at june 30, 2017, and the revenues and expenses for the month of june, its first month of operations: cash $4,960 notes payable $12,720 accounts receivable 4,340 accounts payable 840 service revenue 7,860 supplies expense 1,100 supplies 2,300 maintenance and repairs expense 700 advertising expense 400 utilities expense 200 equipment 26,360 salaries and wages expense 1,760 common stock 22,360 in june, the company issued no additional stock but paid dividends of $1,660. prepare an income statement for the month of june.
Answers: 3
image
Business, 22.06.2019 13:30, Geo777
You operate a small advertising agency. you employ two secretaries, a graphic designer, three sales representatives, and an office coordinator. 1. what types of things would you consider when determining how to compensate each position? describe two (2) considerations. 2. what type of compensation plan would you use for each position?
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 in other subjects: