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 Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter5: Advanced Data Modeling

Section: Chapter Questions

Problem 9C

See similar textbooks