Part 1: Entity Relationship Diagram

Please create an Entity Relationship Diagram ERD) for the below scenario. Be sure to identify the entity name, the primary key, attributes that make sense and the cardinality.

You have been hired to develop an ERD for a start-up company that wants to track employee and project assignments. The company has several departments. Each department has a supervisor and at least one employee. Employees must be assigned to at least one, but possibly more departments. At least one employee is assigned to a project, but an employee may not be assigned to any projects.

Part 2: Database Design

Please convert your ERD done for the above scenario into a database design. What are the necessary primary keys, foreign keys and fields? What are the relationships?