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 ALQ'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 ALQ'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. Service-type - ID-number Name - of - Client Invoice - number - for- service - engagement Dollar - amount - of - cash - receipt Cash - receipt - ID-number Location -of-cash-account Cash - account - ID -number Client - ID -number Employee - phone - number Employee - ID-number Highest - degree - of - an - employee Employee - annual - salary - amount Standard - hourly- billing-rate-for-a- service - type Total - charge - for- service - engagement 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 ALQ'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 ALQ'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. Service-type - ID-number Name - of - Client Invoice - number - for- service - engagement Dollar - amount - of - cash - receipt Cash - receipt - ID-number Location -of-cash-account Cash - account - ID -number Client - ID -number Employee - phone - number Employee - ID-number Highest - degree - of - an - employee Employee - annual - salary - amount Standard - hourly- billing-rate-for-a- service - type Total - charge - for- service - engagement Number - of -hours-of-each- service -type - performed - on-each-service- engagement
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
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 ALQ'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 ALQ'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. Service-type - ID-number Name - of - Client Invoice -
number - for - service - engagement Dollar - amount - of - cash - receipt Cash - receipt - ID-number Location
-of-cash-account Cash - account - ID-number Client - ID-number Employee - phone - number Employee
- ID-number Highest-degree - of -an - employee Employee - annual - salary - amount Standard - hourly -
billing - rate-for-a- service - type Total - charge - for- service - engagement Number - of -hours-of-each-
service - type - performed - on - each - service - engagement
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 ALQ'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 Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education