Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
You have been hired as an intern in the Oxford office of Emerson and Faulkner, a regional accounting firm operating in Alabama, Mississippi, and Tennessee.
You have been hired as an intern in the Oxford office of Emerson and Faulkner, a regional accounting firm operating in Alabama, Mississippi, and Tennessee. Ralph Waldo, the managing partner of the firm, knows that you have completed the undergraduate AIS course at BGSU. RW as he likes to be called, wants you to build a database to keep track of the accountants working on various engagements. RW currently uses the following form to keep track of engagements. Each client may have multiple engagements. The table names are all in CAPS followed by the list of field names between parentheses. The primary keys are in Bold and Underlined. The foreign keys are in italic. Copy and use the following starting table: ENGAGEMENT EngageID PK EngageTypeID, EngageDescription, EngageManagerID, EngageManagerName, ClientID, ClientName, ClientAddress, AcctID, AcctName, AcctCertifications, Hours, BillableHours, BillingRate, EngageFeecreate a fully normalized data model for the Client Engagements application.Please take into account the following INFO regarding the Normalization Homework Client Engagement: The engagement Manager is an accountant The EngageManagerID field will store the same value as the AcctID field You will have an ACCOUNTANTS table with the AcctID as the primary key PK field. The EngageManagerID will be the foreign key FK field in the ENGAGEMENTS table determining which accountant will be the manager for the engagement. The EngageManagerName field is the same as the AcctName field and it is already stored in the ACCOUNTANTS table. Thus, do not create an ENGAGEMANAGER table. It will be redundant because all the info would already be stored in the ACCOUNTANTS table. EngageFee is NOT derivedcomputed based on other fields SUM of the Hours Billing Rate Thus, you need to keep it in the ENGAGEMENTS table. Each accountant will have a series of certifications. This is another case of repeating groups. You will need to apply rule # again to handle this situation. Create another table with a composite key AcctID AcctCertifications You will also create a table CERTIFICATIONS to store the description of each certification code is CPA, is CMA,
You have been hired as an intern in the Oxford office of Emerson and Faulkner, a regional accounting firm operating in Alabama, Mississippi, and Tennessee. Ralph Waldo, the managing partner of the firm, knows that you have completed the undergraduate AIS course at BGSU. RW as he likes to be called, wants you to build a database to keep track of the accountants working on various engagements. RW currently uses the following form to keep track of engagements. Each client may have multiple engagements.
The table names are all in CAPS followed by the list of field names between parentheses. The primary keys are in Bold and Underlined. The foreign keys are in italic.
Copy and use the following starting table:
ENGAGEMENT EngageID PK EngageTypeID, EngageDescription, EngageManagerID, EngageManagerName, ClientID, ClientName, ClientAddress, AcctID, AcctName, AcctCertifications, Hours, BillableHours, BillingRate, EngageFeecreate a fully normalized data model for the Client Engagements application.Please take into account the following INFO regarding the Normalization Homework Client Engagement:
The engagement Manager is an accountant The EngageManagerID field will store the same value as the AcctID field You will have an ACCOUNTANTS table with the AcctID as the primary key PK field. The EngageManagerID will be the foreign key FK field in the ENGAGEMENTS table determining which accountant will be the manager for the engagement. The EngageManagerName field is the same as the AcctName field and it is already stored in the ACCOUNTANTS table. Thus, do not create an ENGAGEMANAGER table. It will be redundant because all the info would already be stored in the ACCOUNTANTS table.
EngageFee is NOT derivedcomputed based on other fields SUM of the Hours Billing Rate Thus, you need to keep it in the ENGAGEMENTS table.
Each accountant will have a series of certifications. This is another case of repeating groups. You will need to apply rule # again to handle this situation. Create another table with a composite key AcctID AcctCertifications You will also create a table CERTIFICATIONS to store the description of each certification code is CPA, is CMA,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started