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, EngageFee$)$create a fully normalized data model for the Client Engagements application.Please take into account the following INFO regarding the Normalization Homework Client Engagement$)$:

$1.$ 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.

$2.$ EngageFee is NOT derived$/$computed based on other fields $($SUM of the Hours $*$ Billing Rate$).$ Thus, you need to keep it in the ENGAGEMENTS table.

$3.$ Each accountant will have a series of certifications. This is another case of repeating groups. You will need to apply rule #$2$ 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 $(1$ is CPA, $2$ is CMA, $...).$