drop sequence seq_employee_id;
drop table employee;

create sequence seq_employee_id;

create table employee
(
  id int DEFAULT nextval('seq_employee_id'),
  name varchar(60),
  department int,
  title varchar(60),
  salary numeric
);


INSERT INTO employee (id, name, department, title, salary) VALUES (1, 'Mike Carling', 1, 'Lead Guru', 45000.00);  
INSERT INTO employee (id, name,  department, title, salary) VALUES (2, 'Moe Carling', 2, 'Lead Programmer', 55000.00);  
INSERT INTO employee (id, name,  department, title, salary) VALUES (3, 'Marvin Carling', 3, 'Lead Chump', 455000.00);  
INSERT INTO employee (id, name,  department, title, salary) VALUES (4, 'Merlin Carling', 4, 'Lead Magician', 400.00);  
select setval('seq_employee_id', 5);

drop sequence seq_department_id;
drop table department;

create sequence seq_department_id;

create table department
(
  id int DEFAULT nextval('seq_department_id'),
  name varchar(60),
  manager int
);

INSERT INTO department (id, name) VALUES (1, 'Risk Management');  
INSERT INTO department (id, name) VALUES (2, 'Information Technology');  
INSERT INTO department (id, name) VALUES (3, 'Human Resources');  
INSERT INTO department (id, name) VALUES (4, 'Accounting');  
INSERT INTO department (id, name) VALUES (5, 'Customer Support');  

select setval('seq_department_id', 6);