Untitled

create table Staffs
( 
StaffID varchar (11) primary key,
Gender char (1),
Name nvarchar (50),
Department nvarchar (50)
)

create table Nurses
(
StaffID varchar (11) primary key,
foreign key (StaffID) references Staffs(StaffID)
)
create table Rooms
(
RoomID int,
Type nvarchar (50),
StaffID varchar (11) primary key,
foreign key (StaffID) references Nurses(StaffID)
)
create table Doctors
(
Specialty nvarchar (50),
StaffID varchar (11) primary key,
foreign key (StaffID) references Staffs(StaffID)
)