Assessment Challenge $2\mathrm{.}1-$ERD $($MULTIPLE ATTEMPT$)$

Please be aware that the tables for PATIENT, PHYSICIAN and TREATMENT entities in the ERD below have already been created.

Question $1-$ Create "PatientTreatment$\_$T $"$ table for the "PATIENT TREATMENT $"$ entity in the ERD.

Note: Use the following data types and names for some attributes you need:

DATE data type for PatientTreatmentDate attribute,

TIME data type for PatientTreatmentTime attribute, and

VARCHAR$(50)$ data type for PatientTreatmentResults attribute.

Question $2-$ Insert $3$ rows in the PatientTreatment$\_$T table as follows:

a row for patient $112$ that had an appointment with physician $58$ on $23$ May $2010,$ at $10$:$30$ am$,$ and he has received the treatment code TR$45($the value for the rest of the attributes need to be determined by you $)$

a row for patient $112$ that had an appointment with physician $58$ on $23$ May $2010,$ at $10$:$30$ am $($the value for the rest of the attributes need to be determined by you $)$

a row for a patient that had an appointment with physician $58$ on $23$ May $2010,$ at $10$:$30$ am and he has received the treatment code TR$45($the ID of the patient and the value for rest of the attributes need to be determined by you$)$

Note $1$: be careful about the data type of the attributes, and Pk constraints and FK constraints of the tables.

Note $2$: You need to use DATE data type $($format mm$/$dd$/$yyyy$)$ and TIME data type where required.

In your insert statement, the Date value should be $\text{'}05/23/2010\text{'}($date format mm$/$dd$/$yyyy$),$ and the Time value should be $\text{'}10$:$30$ am$\text{'}.$

Note $3$: use PatientTreatment$\_$T name for your table

Note $4$: Use the same name for your FKs and the related PKs $($e$.$g$.$ if PK of PATIENT table is a FK in your PatientTreatment$\_$T table, then use PatientID as the name for your FK$).$

Note $5$: Check the generated ERD based on your Code. The ERD will be generated under the console.