worker

-- worker table
Create table worker(
Worker_Id int ,
FirstName varchar(20) not null,
 Last_name varchar(20) ,
Salary int not null,
Joining_Date date not null,
Department varchar(10) not null);

-- Bonus table
Create table Bonus(Worker_Ref_Id int,Bonus_Date date not null,Bonus_Amount int not null);

-- Title table
Create table Title(Worker_Ref_Id int,Worker_Title varchar(10) not null,Affected_From date not null);

Comments