The following are some additional data for the company database.
Please add this data to your database and then run your queries
for Home Work 4.


INSERT INTO employee VALUES ('John', 'V', 'Hammond', '111111111', '29-MAR-59', 'Houston,TX', 'M', 25000, '333445555', 5);

INSERT INTO dependent VALUES ('111111111','John','M','05-APR-76','Son');
INSERT INTO dependent VALUES ('111111111','Donald','M','05-APR-78','Son');

INSERT INTO works_on VALUES ('111111111', 1, 20);
INSERT INTO works_on VALUES ('111111111', 2, 4);
INSERT INTO works_on VALUES ('111111111', 3, 4);
INSERT INTO works_on VALUES ('111111111', 10, 4);
INSERT INTO works_on VALUES ('111111111', 20, 4);
INSERT INTO works_on VALUES ('111111111', 30, 4);

INSERT INTO employee VALUES ('Ian', 'N', 'Malcolm', '222222222', '29-MAR-59', 'Houston,TX', 'M', 25000, '333445555', 5);
INSERT INTO dependent VALUES ('222222222','Ian','M','05-APR-86','Son');
INSERT INTO dependent VALUES ('222222222','Ronald','M','05-APR-88','Son');