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$)$