UNF 
 
 
Hospital Rotas
 
1. Ward Data 
 
Ward Name
Date
Ward Type
No. Beds
Sister
Nurse No.
Nurse Name
Nurse exp.
Patient No.
Patient Name 
Bed No.
Date Admitted
Date Expected Leave
 
 
2. Consultant Data
 
Consultant No.
Date
Specialism
Patient No.
Patient Name 
Bed No.
Sex
 
 
Please Normalise to 1NF, 2NF and 3NF and we will examine it in class.
 
Renaat.