project

profilearlr
Project_Part_2_ERD.pdf

Consultant SkillsConsultant_Skill

Client

Project Project_Skills

SubProject

C_FName

C_MI

C_IDPK

C_LName

C_Address

C_City

C_State

C_Zip

C_Phone

C_Email

S_IDPK

S_Desc

C_IDFKPK

S_IDFKPK

CL_IDPK

CL_Name

CL_Phone

CL_Contact

P_IDPK

P_Name

C_IDFK

CL_IDFK

P_IDFKPK

S_IDFKPK

SP_IDPK

P_IDFK

SP_Name

Project_Consultant

Project_Eval

C_IDFKPK

PC_StartDate

PC_EndDate

P_IDFKPK

PC_TotalHours

P_IDFKPK

C_IDFK

PE_Date

C_IDFKPK

PE_Score

PE_Comment

The PK C_ID  references the  consultant 

being  evaluated.  The 

FK is the  manager doing  the evaluation.