Example of the basic look your ERD should have $($not all ERD shapes and symbols

shown$)$:

A$.$ 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$($OfficelD$,$Description,Type, FK$3)$

Can have zero or more teams

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

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

Has at least $1$ but may have many offices

Do not leave any N:M relationships in your model