Use the following business rules to create a Crow$$s Foot ERD. Include all appropriate connectivities and primary$/$foreign keys in your ERD.

Whw

w

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.$)$ What does the ERD look like?