-- additional table to hold employee qualifications

create table qualification (
       ssn       char(9)  primary key not null,
       qual     varchar(20) not null,
       foreign key (ssn) references employee(ssn)
);

insert into qualification values ('123456789', 'bachelors');
insert into qualification values ('333445555', 'masters');
insert into qualification values ('987654321', 'masters');
insert into qualification values ('666884444', 'doctorate');
insert into qualification values ('987987987', 'ccie');
insert into qualification values ('888665555', 'doctorate');