Moving company main source of revenue

Assignment Help Operation Management

Reference no: EM132238650

The UR moving company’s main source of revenue is that which is generated from its drivers and trucks. The company is interested in keeping track of how many hours each driver drives each truck. A driver may drive one or more trucks, and a truck may be driven by one or more drivers. Because UR is a small venture, there are only 3 types of trucks in their fleet. These are the 15-ft, 25-ft, & 30-ft models. Each truck has a single maintenance worker permanently assigned to perform maintenance on the truck, although a maintenance worker may maintain more than one truck. Come up with the ERD Information that needs to be tracked in this database include the following: Driver ID, Driver Name, Driver Hours, Truck Type, Truck License, Driver Permit Number, Maintenance Worker Name, Maintenance Worker ID, Truck Location Add these in an appropriate fashion to your ERD model.

Reference no: EM132238650

Questions Cloud

Steps involved in staff performance appraisal process : What role change management can play in leadership and performance, management? Describe the steps involved in staff performance appraisal process.

Integrity and referential integrity important in a database : What does it mean to say that a database displays both entity integrity and referential integrity?

Staff appraisal during the project implementation phase : Discuss the advantages of performing staff appraisal during the project implementation phase.

Use of trade secrets to protect intellectual property : Are there any drawbacks with the use of trade secrets to protect intellectual property?

Moving company main source of revenue : The UR moving company’s main source of revenue is that which is generated from its drivers and trucks.

Recommend how to address the considerations : American Plastics had fared rather worse than its competitors during the economic downturn. With revenue, quality, and productivity down.

How would you measure each variable : What variables (qualitative and quantitative) do you believe are worth consideration when measuring business performance?

Determine inventory implications of the new product : Your firm is planning to introduce a new product line. Your task is to determine the inventory implications of the new product.

Why ice cream sales fluctuate in this manner : You notice that there are days when ice creams remain unsold but other days when there are not enough ice creams for the number of customers.

User Account

All Pages