use company
go

create procedure ADD_EMPLOYEE
@EMP_ID char(8),
@LASTNAME varchar (15),
@FIRSTNAME varchar (15),
@SALARY money, 
@E_ADDRESS varchar (30),
@SEX char,
@BDATE datetime, 
@SUPERVISOR_ID char(8),
@DNUMBER int
as
begin
insert into EMPLOYEE (EMP_ID, LASTNAME, FIRSTNAME, SALARY, E_ADDRESS, SEX, BDATE, SUPERVISOR_ID, DNUMBER)
values (@EMP_ID, @LASTNAME, @FIRSTNAME, @SALARY, @E_ADDRESS, @SEX, @BDATE, @SUPERVISOR_ID, @DNUMBER)
end
go

create procedure ADD_DEPARTMENT
@DNUMBER int,
@DNAME varchar (15),
@MANAGER_ID char(8),
@MNG_STARTDATE datetime
as
begin
insert into DEPARTMENT (DNUMBER, DNAME, MANAGER_ID, MNG_STARTDATE)
values (@DNUMBER, @DNAME, @MANAGER_ID, @MNG_STARTDATE)
end
go

create procedure ADD_DEP_LOCATION
@DNUMBER int,
@LOCATIONS varchar (15)
as
begin
insert into DEP_LOCATION (DNUMBER,LOCATIONS)
values (@DNUMBER, @LOCATIONS)
end
go

create procedure ADD_PROJECT
@PNUMBER int,
@PNAME varchar (30),
@PLOCATION varchar (15),
@DNUMBER int 
as
begin
insert into PROJECT (PNUMBER,PNAME,PLOCATION,DNUMBER)
values (@PNUMBER,@PNAME,@PLOCATION,@DNUMBER)
end
go

create procedure ADD_WORKS_ON
@EMP_ID char(8),
@PNUMBER int,
@HOURS decimal(3,1)
as
begin
insert into WORKS_ON (EMP_ID,PNUMBER,HOURS)
values (@EMP_ID,@PNUMBER,@HOURS)
end
go

create procedure ADD_DEPENDENT
@EMP_ID char(8),
@DNAME varchar(15),
@SEX char,
@BDATE datetime,
@RELATIONSHIP varchar(10)
as
begin
insert into DEPENDENT (EMP_ID,DNAME,SEX,BDATE,RELATIONSHIP)
values (@EMP_ID,@DNAME,@SEX,@BDATE,@RELATIONSHIP)
end
go