ALO (Anderson-left-overs) Enterprises is an organization that provides a wide variety of service offerings for clients....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ALO (Anderson-left-overs) Enterprises is an organization that provides a wide variety of service offerings for clients. Service types available include bookkeeping, computer installation, computer repair, software installation, taxes, advertising, market surveys, etc. Each service engagement may involve multiple types of service and may include multiple employees. Each type of service has a standard hourly billing rate and can not be entered into the database unless at least one of ALO's employees is capable of performing that type of service. Employees are trained to perform multiple types of services and can work on multiple service engagements. Employees earn a contracted annual salary based on their credentials, regardless of what services they actually end up performing. Clients are required to pay for a given service engagement in full (with just one check) within two weeks of the completion date. It is possible for a client to pay for more than one service engagement with just one check, so ALO must allow for that possibility in its database. Each client payment is processed by exactly one of ALO's three cashiers and is deposited in full into one of AlQ's two bank accounts. Employees and clients are entered into the database before any transactions involving them occur. Draw an E-R diagram for ALO Enterprises, including cardinalities and attributes. The following attributes must be accounted for in your model. 1. Service-type-ID-number 2. Name-of-Client 3. Invoice-number-for-service-engagement 4. Dollar-amount-of-cash-receipt 5. Cash-receipt-ID-number 6. Location-of-cash-account 7. Cash-account-ID-number 8. Client-ID-number 9. Employee-phone-number 10. Employee-ID-number 11. Highest-degree-of-an-employee 12. Employee-annual-salary-amount 13. Standard-hourly-billing-rate-for-a-service-type 14. Total-charge-for-service-engagement 15. Number-of-hours-of-each-service-type-performed-on-each-service-engagement ALO (Anderson-left-overs) Enterprises is an organization that provides a wide variety of service offerings for clients. Service types available include bookkeeping, computer installation, computer repair, software installation, taxes, advertising, market surveys, etc. Each service engagement may involve multiple types of service and may include multiple employees. Each type of service has a standard hourly billing rate and can not be entered into the database unless at least one of ALO's employees is capable of performing that type of service. Employees are trained to perform multiple types of services and can work on multiple service engagements. Employees earn a contracted annual salary based on their credentials, regardless of what services they actually end up performing. Clients are required to pay for a given service engagement in full (with just one check) within two weeks of the completion date. It is possible for a client to pay for more than one service engagement with just one check, so ALO must allow for that possibility in its database. Each client payment is processed by exactly one of ALO's three cashiers and is deposited in full into one of AlQ's two bank accounts. Employees and clients are entered into the database before any transactions involving them occur. Draw an E-R diagram for ALO Enterprises, including cardinalities and attributes. The following attributes must be accounted for in your model. 1. Service-type-ID-number 2. Name-of-Client 3. Invoice-number-for-service-engagement 4. Dollar-amount-of-cash-receipt 5. Cash-receipt-ID-number 6. Location-of-cash-account 7. Cash-account-ID-number 8. Client-ID-number 9. Employee-phone-number 10. Employee-ID-number 11. Highest-degree-of-an-employee 12. Employee-annual-salary-amount 13. Standard-hourly-billing-rate-for-a-service-type 14. Total-charge-for-service-engagement 15. Number-of-hours-of-each-service-type-performed-on-each-service-engagement
Expert Answer:
Related Book For
Business Communication Essentials a skill based approach
ISBN: 978-0132971324
6th edition
Authors: Courtland L. Bovee, John V. Thill
Posted Date:
Students also viewed these accounting questions
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Coral Divers Resort Jonathon Greywell locked the door on the equipment shed and began walking back along the boat dock to his office. He was thinking about the matters that had weighed heavily on his...
-
Graph the sets of points whose polar coordinates satisfy the equations and inequalitie. 0 , r = 1
-
Could any of them be adapted given what occurs with the others?
-
How are businesses using cryptocurrencies today? Which is one cryptocurrency that is most popular among businesses?
-
What can be used for a velocity output without the negative aspects of a seismic transducer?
-
Franklin purchases 40 percent of Johnson Company on January 1 for $500,000. Although Franklin did not use it, this acquisition gave Franklin the ability to apply significant influence to Johnsons...
-
Norma Electronics sell its products for cash and on credit. It usually provides 6 % of its credit sales as allowance for bad and doubtful debts. In the month of April 2 0 x 1 , Norma Electronics...
-
Commentary assignment Description: In this assignment you are to following up on identifying with the kinds of decisions that are made at different levels of management with respect to information...
-
Q4: Solve the second order differential equation: 6y+5y+y=2x-1
-
A pitot tube with a coefficient of 0.95 is used to measure the velocity of air in a ventilation duct. The differential pressure head measured by the pitot tube is 1 ft. What is the air velocity
-
ABC co. has the following data for the month ended January 31, 2021. ABC uses periodic inventory system: Date Units Unit cost or selling price 1/1 Beginning Inventory 110 $ 78 1/8 Purchase 190 81...
-
Estimate the convection heat flow to a 2.0 m high and 1.2 m wide glass window. The average inside surface temperature is 5 C. Room air temperature is 25 C. 2. Though it may be classified as a rather...
-
A college textbook publisher sells a certain e-book for $39.75. For the current process, the publisher has fixed cost of $350,000 and a variable cost per book of $32.00. a. What is the break-even...
-
What is Oppression? Explain.
-
A container holds 2.0 mol of gas. The total average kinetic energy of the gas molecules in the container is equal to the kinetic energy of an 8.0 10-3-kg bullet with a speed of 770 m/s. What is the...
-
What is an overnight reverse repurchase agreement (ON RRP)? What role does the interest on ON RRP play in the way the Fed hits its target for the federal funds rate in the current ample-reserves...
-
A Federal Reserve publication observed that today, the The Feds primary tool for adjusting the federal funds rate is interest on reserve balances. a. Briefly explain the reasoning behind this...
-
In the following graph of the federal funds market, briefly explain whether the banking system is in a scarce reserves regime or an ample-reserves regime. In this situation, briefly explain whether...
Study smarter with the SolutionInn App