A department employs many employees, but each employee is employed by one department. Use department$\_$id and employee$\_$id as the primary keys. Include the correct foreign keys.

A division operates many departments, but each department is operated by one division. Use division$\_$id and department$\_$id as the primary keys. Include the correct foreign keys.

An employee may be assigned many projects, and a project may have many employees assigned to it$.$ Use employee$\_$id and project$\_$id as the primary keys. Include the correct foreign keys. $($Hint: this is a many to many relationship. You need to use a bridge or junction table to correctly model a many to many relationship. Your bridge or junction table could be called assignment. If you need a reminder on how to correctly model a many to many relationship using a bridge table go back to week two and watch the video titled $$Helpful Homework Video Two$.)$