/*
drop table employee
go

create table employee
(
firstname varchar(100),
secondname varchar(100),
emp_id int,
pay_date datetime
)
go

drop table department
go

create table department
(
emp_id int,
pay_date datetime
)
go

drop table sales
go

create...