I need some help with defining a recursive relationship in a ER diagram. It is a part of my assignment and the below is quoted in the case study.
Admin staffs are in-charge admitting inpatient to the hospital.
Several nurses work in each ward and one of them is in charge of the ward.
I have created entities with attributes as below but I'm not sure if it is correct
NURSE (Nurse_ID, Nurse_In_Charge)
WARD (Ward ID, Ward_Name, Main_Treatment, Nurse_In_Charge, Number_Of_Bed)
I have also attached the ER diagram for the recursive relationship with this post, please have a look and comment.