For the above situation create a context-level data model, a key-based data model, and fully-attributed data model using the "crow's foot" notation. Label each relationship in both directions. Show foreign keys and resolve any non-specific (many to many) relationships in the key-based model. Clearly state any assumptions made.

(50 points) Emkay Consultants, Inc. executes turnkey projects for client companies. EmKay engages one of more external contractors to work on a turnkey project. A contractor may be working on multiple projects at one time. Information about client companies and contractors may be stored in the system even if there has been no project activity for them. One or more internal consultants may be assigned to manage a project. At any time, a consultant is involved in at most one project. For each client company, EmKay assigns a unique client_number, and would like to keep track of company_name, contact_email, and contact_phone. For each external contractor, EmKay assigns a contractor_ID, and would like to keep track of contractor_name, contractor_email, and contractor_cell. For each internal consultant, EmKay assigns a consultant_ID and would like to keep track of consultant_last_name, consultant_first_name, consultant_email, consultant_cell, and last-assignment_date. For each turnkey project, EmKay assigns a project_number and would like to keep track of project_type, start_date, end- date, and budget. (50 points) Emkay Consultants, Inc. executes turnkey projects for client companies. EmKay engages one of more external contractors to work on a turnkey project. A contractor may be working on multiple projects at one time. Information about client companies and contractors may be stored in the system even if there has been no project activity for them. One or more internal consultants may be assigned to manage a project. At any time, a consultant is involved in at most one project. For each client company, EmKay assigns a unique client_number, and would like to keep track of company_name, contact_email, and contact_phone. For each external contractor, EmKay assigns a contractor_ID, and would like to keep track of contractor_name, contractor_email, and contractor_cell. For each internal consultant, EmKay assigns a consultant_ID and would like to keep track of consultant_last_name, consultant_first_name, consultant_email, consultant_cell, and last-assignment_date. For each turnkey project, EmKay assigns a project_number and would like to keep track of project_type, start_date, end- date, and budget