Create an ER Diagram based off this code:

$--$ Create the database

CREATE DATABASE HospitalDB;

USE HospitalDB;

$--$ Create the Patient table

CREATE TABLE Patient $($

PatientID INT AUTO$\_$INCREMENT PRIMARY KEY,

Name VARCHAR$(100)$ NOT NULL,

ContactInfo VARCHAR$(150),$

Address VARCHAR$(255),$

Age INT,

Weight DECIMAL$(5,2),$

Height DECIMAL$(5,2),$

InsuranceInfo VARCHAR$(150),$

SSN VARCHAR$(11)$ UNIQUE

$)$;

$--$ Create the Doctor table

CREATE TABLE Doctor $($

DoctorID INT AUTO$\_$INCREMENT PRIMARY KEY,

Name VARCHAR$(100)$ NOT NULL,

Specialization VARCHAR$(100),$

ContactInfo VARCHAR$(150)$

$)$;

$--$ Create the Room table

CREATE TABLE Room $($

RoomNumber INT PRIMARY KEY,

RoomType VARCHAR$(50),$

Availability BOOLEAN

$)$;

$--$ Create the Staff table

CREATE TABLE Staff $($

StaffID INT AUTO$\_$INCREMENT PRIMARY KEY,

Name VARCHAR$(100)$ NOT NULL,

Role VARCHAR$(100),$

ContactInfo VARCHAR$(150)$

$)$;

$--$ Create the Treatment table

CREATE TABLE Treatment $($

TreatmentID INT AUTO$\_$INCREMENT PRIMARY KEY,

TreatmentDetails TEXT,

Date DATE,

StaffID INT,

PatientID INT,

FOREIGN KEY $($StaffID$)$ REFERENCES Staff$($StaffID$),$

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$)$

$)$;

$--$ Create the Patient$\_$Doctor table for the many$-$to$-$many relationship

CREATE TABLE Patient$\_$Doctor $($

PatientID INT,

DoctorID INT,

PRIMARY KEY $($PatientID$,$ DoctorID$),$

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$),$

FOREIGN KEY $($DoctorID$)$ REFERENCES Doctor$($DoctorID$)$

$)$;

$--$ Create the Patient$\_$Room table for the one$-$to$-$one relationship

CREATE TABLE Patient$\_$Room $($

PatientID INT,

RoomNumber INT,

AdmissionDate DATE,

DischargeDate DATE,

PRIMARY KEY $($PatientID$,$ RoomNumber$),$

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$),$

FOREIGN KEY $($RoomNumber$)$ REFERENCES Room$($RoomNumber$)$

$)$;

$--$ Create the Patient$\_$Treatment table for the one$-$to$-$many relationship

CREATE TABLE Patient$\_$Treatment $($

PatientID INT,

TreatmentID INT,

PRIMARY KEY $($PatientID$,$ TreatmentID$),$

FOREIGN KEY $($PatientID$)$ REFERENCES Patient$($PatientID$),$

FOREIGN KEY $($TreatmentID$)$ REFERENCES Treatment$($TreatmentID$)$

$)$;

$--$ Create the Staff$\_$Treatment table for the one$-$to$-$many relationship

CREATE TABLE Staff$\_$Treatment $($

StaffID INT,

TreatmentID INT,

PRIMARY KEY $($StaffID$,$ TreatmentID$),$

FOREIGN KEY $($StaffID$)$ REFERENCES Staff$($StaffID$),$

FOREIGN KEY $($TreatmentID$)$ REFERENCES Treatment$($TreatmentID$)$

$)$;

Use entites with the bubbles and lines.