create table developers
(
emp_id integer primary key references employees(id),
bonus numeric(16, 2)
)
insert into developers values (8, 12000);
insert into developers values (9, 8000);
insert into developers values (10, 15000);
insert into developers values (11, 10000);
insert into developers values (12, 11000);
insert into developers values (13, 15000);
create table dev_skills
(
emp_id integer references developers(emp_id),
skill varchar(30),
primary key (emp_id, skill)
);
insert into dev_skills values (8, 'C++');
insert into dev_skills values (8, 'Java');
insert into dev_skills values (8, 'SQL');
insert into dev_skills values (8, 'Pascal');
insert into dev_skills values (9, 'C++');
insert into dev_skills values (9, 'Java');
insert into dev_skills values (9, 'Python');
insert into dev_skills values (9, 'SQL');
insert into dev_skills values (10, 'C');
insert into dev_skills values (10, 'Java');
insert into dev_skills values (10, 'JavaScript');
insert into dev_skills values (10, 'Python');
insert into dev_skills values (10, 'SQL');
insert into dev_skills values (11, 'Python');
insert into dev_skills values (11, 'Java');
insert into dev_skills values (11, 'JavaScript');
insert into dev_skills values (11, 'Cobol');
insert into dev_skills values (11, 'PHP');
insert into dev_skills values (12, 'Python');
insert into dev_skills values (12, 'Java');
insert into dev_skills values (12, 'JavaScript');
insert into dev_skills values (12, 'PHP');
insert into dev_skills values (13, 'Python');
insert into dev_skills values (13, 'Fortran');
insert into dev_skills values (13, 'Java');
insert into dev_skills values (13, 'Angular');