Draw an E.R.D with connectivity and cardinalities for the following narrative:

You want to track information about 10 departments in your company. Each department has a unique name, is located on a specific floor and has a phone number. Within each department there is a department head and a range of additional employees. For all employees we want to track their name, who their boss is, their salary as well as the unique employee number each had assigned to them when they started the company. Each employee also has a set of skills. You need to track this set of skills so you can locate employees with the right skill set to be part of various cross department project teams. You need to also track information about all of the projects that are under taken by these various departments. Each project has a unique id, a name, a start date, and at least 3 employees on it. All projects have a project leader and a project coordinator. Any employee can be a project leader but they can only lead one project. Furthermore any employee can be a project coordinator and they can coordinate any number of projects.

The attributes given are meant to help you understand the scenario. Dont include them on your ERD.