construct a 3nf using sql queries

UNA Doctor Nurse Doctorid INT Nurseid INT Nursename VARCHAR(45) Nurse_phoneno. INT(10) Nurse address VARCHAR (45) Doctorname VARCHAR(45) Doctoraddress VARCHAR(45) Doctor phnoneno. INT(10) Department name VARCHAR(45) room no. INT Department alloted VARCHAR(45) Department_room no, INT(100) Doctor_supervisor VARCHAR(45) Indexes Indes Room Patient Patient_id INT | Roos 1. INT Department_Name VARCHAR(45) I Doctor id INT G Nurse id INT Patient id INT Patient_name VARCHAR(45) Patient address VARCHAR (SD) Patient phoneno. INT(10) Hospita_arrivadate DATE Hospita_departuredate DATE Roomno. _alloted INT(100) Department_name VARCHAR(45) Doctor alloted VARCHAR(45) D