Question: which ones would be the foreign and Primary Keys in the following: CLIENTS ( ClientID , ClientName, ClientAddress ) ENGAGEMENTS ( EngageID , EngageTypeID, ClientID,

which ones would be the foreign and Primary Keys in the following:
CLIENTS (ClientID, ClientName, ClientAddress)
ENGAGEMENTS (EngageID, EngageTypeID, ClientID, EngageManagerID, EngageFee)--->main table
Engagetype(engagetypeid, description)
ENGAGEACCOUNTANT(engageID, acctID, hours, billable hours)
ACCOUNTANTS (AcctID, AcctName, BillingRate)
CERTIFICATIONS (CertificationCode , Description)
ACCOUNTANT_CERTIFICATIONS (AcctID, CertificationCode)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!