Scenario:
Sehome Medical Center is based in northwestern Washington. Mr. Scott Hagopian, a systems analyst at Sehome Medical Center has developed an entity relationship diagram (ER diagram) for the Medical Center's new Client Care Database System.

Notes:
1. If a medical office procedure is associated with a medical report, then the Sehome Medical Center wants to keep track of the number of instances of a specific type of medical office procedure that are associated with a medical report. For example, if a client has been treated for two sprained ankles during a medical visit, then the Medical Center would want to record that two "treat sprained ankle" medical office procedures were performed. As indicated on the ER diagram, the "number of instances of procedure" attribute is used to keep track of this number.

2. With regard to the Medical Assistant entity, Mr. Hagopian has learned that the Assistant Job Code determines the Assistant Hourly Wage (i.e., all assistants who have the same job code get paid the same hourly wage).

Using the information provided below and the conversion principles discussed in class, please convert the ER Diagram into a set of relations in third normal form. Express each relation using relational notation (e.g.. PRODUCT (Product ID. Product Name. ... ) ).