Consider the following scenario:

We are going to design a database for a small clinic. The clinic just has primary care physicians at the present time. Since there are no specialists, each patient must be assigned to one and only one primary care physician.

The physicians have an ID number, a name $($first and last$),$ a home address made up of street address, city, state and zip code, a license number and one or more phone numbers $($home$,$ business and mobile$)$ and one or more email addresses.

The patients have an ID$,$ first and last names, a home address made up of street address, city, state and zip code, one or more phone numbers $($home$,$ business and mobile$)$ and one or more email addresses.

Questions$/$Tasks:

What are the attributes of this database?

Determine the relations involved in this database.

Normalize the relations to $4$NF$.$

Show all foreign key relationships.

$($Bonus$)$ Draw the normalized ER diagram for this database $($using MySQL Workbench, LucidChart or any other tool$)$ and embed it in your answer here.