create table Dept(
  DeptName varchar(16),
  Manager varchar(16)
);

create table Employee(
  Name varchar(16),
  EmpId int,
  DeptName varchar(16)
);

insert into Dept values('Sales', 'Harriet');
insert into Dept values('Production', 'Charles');

insert into Employee values('Harry', 3415, 'Finance');
insert into Employee values('Sally', 2241, 'Sales');
insert into Employee values('George', 3401, 'Finance');
insert into Employee values('Harriet', 2202, 'Sales');
insert into Employee values('Tim', 1123, 'Executive');