Draw an ERD for the following: A consulting company has EMPLOYEES (SSN, Name, Skills). Employees work on PROJECTS (Project_ID, Description, Cost). An employee works on at least one project at any time and a project may require more than one employee, due to its complexity. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate). Employees deal with CLIENTS (Client_ID, Name, Location). Each employee can be associated with one client or no clients, but the same client may require more than one employee. Some employees have a supervisor assigned to them, who is also an employee. However, a single employee may supervise more than one employee at any time.
Draw an ERD for the following: A consulting company has EMPLOYEES (SSN, Name, Skills). Employees work on PROJECTS (Project_ID, Description, Cost). An employee works on at least one project at any time and a project may require more than one employee, due to its complexity. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate). Employees deal with CLIENTS (Client_ID, Name, Location). Each employee can be associated with one client or no clients, but the same client may require more than one employee. Some employees have a supervisor assigned to them, who is also an employee. However, a single employee may supervise more than one employee at any time.
Step by step
Solved in 2 steps with 1 images
