Produce an ERD that portrays the relationships listed below. Where you see $$FK#$,$ provide an

appropriate FK attribute name.

$$ An ATTORNEY $($AttorneyID$,$Name,Status, FK$1)$

$$ Works in exactly $1$ department

$$ Can be on multiple teams at the same time but doesn$$t have to be on

any team.

$$ A DEPARTMENT$($DeptID$,$DeptName$)$

$$ May have many attorneys

$$ You can have a department without any attorneys

$$ A TEAM$($TeamName$,$Description, FK$2)$

$$ Is in only one office locations

$$ You can$$t have a team without at least one attorney

$$ An OFFICE$($OfficeID$,$Description,Type, FK$3)$

$$ Can have zero or more teams

$$ Can be in a building or be fully remote $($work from home$)$

$$ A BUILDING$($BldgID$,$Address,Owner$)$

$$ Has at least $1$ but may have many offices

$$ Do not leave any N:M relationships in your model