Reference no: EM13762695
Using the Relationship-Entity-Attribute modeling technique, create an entity relationship diagram that details this business scenario OR what would an entity-relationship (ER) diagram look like if the standard diagram included cardinalities?
Green, Inc has asked you to create a database to keep track of all details of the services (lawn care) performed as well as the payments. Green, Inc has requested that the database not be designed to track purchases or company disbursements. During the course of business, Green gets requests through the website and when Tom, Abu, or Jean are contacted. When the request is received a work order then begins. The work order lists the services the client is requesting (which can be one or many).
All field workers (#1-#5) perform the services and are able to do so. A particular service may be done for many work orders and a work order may require many serivces.
Green, Inc. also wants the database to keep track of the time employees spend on any type of service or task (such as weeding, mowing, etc). Thus, customer charges for services are based on a standard method of service multiplied by time. Hourly rates are fixed, and it may take many employees to do any one service or task.
Customers are charged based on estimates from sales representatives, these estimates are calculated from hourly rates and standard or average times for completion. Customers are only billed for actual time employees consume on any services provided.
Green, Inc. allows customers to pay in installments if they want to. Most customers pay in installments at regular periodic intervals for the many work orders they have recently had. Partial payments on any one or many work orders are allowed.
|
Facility layout at wheeled coach ambulance
: Facility Layout at Wheeled Coach Ambulance. Briefly describe how and where Wheeled Coach has incorporated the following psychological component of job design into its assembly line jobs:
|
|
Major disadvantages of aggregating all inventories
: List two major disadvantages of aggregating all inventories in one location? What is the most important operational decision related to transportation in a supply chain? List four auctions in supplier selection?
|
|
What is the quality level of the production process
: A producer of high-strength wire cables that are used in lifting spreaders and containers in a shipyard requires that the strength of the cables be more than 20 ton/in2 . The cost of a defective cable (200 ft in length) is $900. What is the quality l..
|
|
A robot is used in a seam welding process
: A robot is used in a seam welding process. The robot is programmed so that it tracks the product on an overhead conveyor and welds the seam. The tolerance of the deviations of the weld from the center of the seam is ? 0.005 in.
|
|
Using the relationship-entity-attribute modeling technique
: Using the Relationship-Entity-Attribute modeling technique, create an entity relationship diagram that details this business scenario OR what would an entity-relationship (ER) diagram look like if the standard diagram included cardinalities?
|
|
Motor carriers versus other modes of transportation
: What is the primary advantage of motor carriers versus other modes of transportation? Be sure to cite or include links to your sources.
|
|
Estimate the actual process capability
: A process is in statistical control with xbarbar = 199 and rbar=3.5. The control chart uses a sample size of n = 4. Specifications are at 200 +/- 8. The quality characteristic is normally distributed. Estimate the potential capability of the process...
|
|
What are the pros and what are the cons
: What are the Pros and what are the cons of the Physician-patient email communication, provide some articles?
|
|
Explain what is meant by a hierarchy of needs
: Explain what is meant by a hierarchy of needs and provide examples of one or more products that enable you to satisfy each of the four levels of need.
|