drop table empmast;

create table empmast (ssn char(9), name char(30), title char(30), dept char(4));

insert into empmast (ssn, name, title, dept) values ('358578983', 'NIMROD, PETER J.', 'DIRECTOR',  '0170');
insert into empmast (ssn, name, title, dept) values ('384873903', 'JETSON, JANET', 'SECRETARY',  '0140');
insert into empmast (ssn, name, title, dept) values ('399283838', 'BILLIBUT, BUFORD',  'PROGRAMMER/ANALYST II',  '0500');
insert into empmast (ssn, name, title, dept) values ('473838213', 'WILSON, WAYNE', 'CARPENTER',  '0890');
insert into empmast (ssn, name, title, dept) values ('482819283', 'LUGNUT, SLUGGO', 'SENIOR ACCOUNTANT',  '0100');
insert into empmast (ssn, name, title, dept) values ('485829838', 'BERGER, PAUL',  'ADMINISTRATIVE ASSISTANT',  '0320');
insert into empmast (ssn, name, title, dept) values ('583834733', 'FARKEL, FRITZ', 'SYSTEMS PROGRAMMER II',  '0500');
insert into empmast (ssn, name, title, dept) values ('674385833', 'COWPEPPER ,CLEM', 'SENIOR SECRETARY',  '0680');
insert into empmast (ssn, name, title, dept) values ('682839383', 'APPLEBAUM, ANDY',  'ASSISTANT DIRECTOR',  '0200');
insert into empmast (ssn, name, title, dept) values ('868399283', 'FRUMP, FREDDIE',  'DATA ENTRY OPERATOR',  '0140');

