ConsultCo

Use the following Business Rules to create the ERD (using the Crow’s Foot model) for a small consulting company named ConsultCo. Show all entities, relationships, optionalities, connectivities, and cardinalities.

A client can contract many projects, but each project is contracted by one client. Some clients in the ConsultCo client list have not (yet) contracted any project(s). A project may have many (consulting company) employees assigned to it and each

employee may be assigned to many projects. Some employees are not assigned to any project. (Such employees run the consulting

company’s daily operations.) Many of the consulting company employees have multiple job skills that are applicable to

the consulting work. (For example, an employee may be qualified as a Systems Analyst and as a Network Administrator.)

Each job description – Systems Analyst, Database Designer, Accountant, etc. – can fit many employees. (For example, ConsultCo is likely to employ several Database Designers, Systems Analysts, and so on.)

Some job descriptions are not yet filled. (ConsultCo is trying to recruit people who fit those job descriptions!)

Some employees do not have a specific job classification. For example, ConsultCo does not assign a job code to employees who help run its daily operations and who are not assigned to specific projects.

All work done by the employees assigned to any project are charged to that project, using an hourly charge based on the job skill applied by the employee to that project. Each charge to a project must be documented by the date, the employee who performed the work, the job skill applied, the hourly rate for that job skill application, the number of hours – to the nearest tenth of an hour – and the total charge for that work. (The total charge, a derived attribute, is computed by multiplying the hours worked and the hourly charge.)