Draw a crows Foot ERD for

Division $$ Department:

Division has as PK$.$

Department has department$\_$id as PK$,$ and division$\_$id as FK$.$

Department $$ Employee:

Department has department$\_$id as PK$.$

Employee has employee$\_$id as PK$,$ and

as FK$.$

Employee harr Project $($via Assignment$)$:

Employee has employee$\_$id as PK$.$

Project has project$\_$id as PK$.$

Assignment has employee$\_$id and project$\_$id as composite PKs$,$ both acting as FKs to connect Employee and Project.

Each entity should have a $1$

relationship line for Division to Dedarrdarr ment and Department to Employee, and

M lines connecting Employee to Project through the Assignment table. The Assignment table creates the necessary bridge for the many$-$to$-$many relationship between Employee and Project.

$$