i want you to draw the er and eer and the connection traps of these data element :

$1.$ Appointment:

o appointment$\_$id $($Primary Key, NUMBER$).$

o patient$\_$id $($Foreign Key, NUMBER$).$

o type $($VARCHAR$2).$

o date.

o time $.$

o doctor$\_$id $($Foreign Key, NUMBER$)$:

$2.$ Doctor:

o employee$\_$id $($Primary Key, NUMBER$).$

o specialist $($VARCHAR$2).$

$3.$ Patient:

o patient$\_$id $($Primary Key, NUMBER$).$

o first$\_$name $($VARCHAR$2).$

o last$\_$name $($VARCHAR$2).$

o phone $($VARCHAR$2).$

$4.$ Bill:

o bill$\_$no $($Primary Key, NUMBER$).$

o doc$\_$charge $($NUMBER$)$: Doctor's consultation charge.

o med$\_$charge $($NUMBER$)$: Charge medicines.

o nursing$\_$charge $($NUMBER$).$

o lab$\_$charge $($NUMBER$)$:$.$

$5.$ Employee:

o employee$\_$id $($Primary Key, NUMBER$).$

o first$\_$name $($VARCHAR$2).$

o last$\_$name $($VARCHAR$2).$

o gender $($VARCHAR$2).$

o phone $($VARCHAR$2).$

o email $($VARCHAR$2).$

o department$\_$id $($Foreign Key, NUMBER$).$

$6.$ Department:

o department$\_$id $($Primary Key, NUMBER$).$

o dep$\_$name $($VARCHAR$2).$

o dep$\_$manager $($VARCHAR$2).$

and the relations are : $1.$ Appointment$-$Patient Relationship:

o The patient$\_$id in the Appointment table references the patient$\_$id in the Patient table.

$2.$ Appointment$-$Doctor Relationship:

o The doctor$\_$id in the Appointment table references the employee$\_$id in the Doctor table.

$3.$ Bill$-$Patient Relationship:

o The patient$\_$id in the Bill table references the patient$\_$id in the Patient table.

$4.$ Employee$-$Department Relationship:

o The department$\_$id in the Employee table references the department$\_$id in the Department table.

$5.$ Department$-$Manager Relationship:

o The dep$\_$manager in the Department table references the employee$\_$id in the Employee table.