Given the following narrative description for Do-it-all Enterprises:
a. Create a business process level REA model in either grammar or diagram format, for Do-it-all Enterprise's sales/collection process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Do-it-all 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 Do-it-all'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 Do-it-all must allow for that possibility in its database. Each client payment is processed by exactly one of Do-it-all's three cashiers and is deposited in full into one of Do-it-all's two bank accounts. Cash receipts cannot be recorded in the database without being associated with a valid bank account. Although bank accounts cannot be established without immediately depositing one or more cash receipts into them, CC must be able to enter the account information into the database before entering the related cash receipts. Employees and clients are entered into the database before any transactions involving them occur.
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-accounts-receivable-balance
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

Question

Quizplus · Accepted Answer

The Answer of Given the following narrative description for Do-it-all Enterprises:
a. Create a business process level REA model in either grammar or diagram format, for Do-it-all Enterprise's sales/collection process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Do-it-all 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 Do-it-all'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 Do-it-all must allow for that possibility in its database. Each client payment is processed by exactly one of Do-it-all's three cashiers and is deposited in full into one of Do-it-all's two bank accounts. Cash receipts cannot be recorded in the database without being associated with a valid bank account. Although bank accounts cannot be established without immediately depositing one or more cash receipts into them, CC must be able to enter the account information into the database before entering the related cash receipts. Employees and clients are entered into the database before any transactions involving them occur.
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-accounts-receivable-balance
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

Given the Following Narrative Description for Do-It-All Enterprises