//* Database Systems, Coronel/Morris */
/* Type of SQL : MySQL */


CREATE TABLE BENEFIT (
EMP_CODE int,
PLAN_CODE int
)
ENGINE = INNODB;

INSERT INTO BENEFIT VALUES('15','2');
INSERT INTO BENEFIT VALUES('15','3');
INSERT INTO BENEFIT VALUES('16','1');
INSERT INTO BENEFIT VALUES('17','1');
INSERT INTO BENEFIT VALUES('17','3');
INSERT INTO BENEFIT VALUES('17','4');
INSERT INTO BENEFIT VALUES('20','3');

/* -- */

CREATE TABLE EMPLOYEE (
EMP_CODE int,
EMP_LNAME varchar(12),
JOB_CODE int
)
ENGINE = INNODB;

INSERT INTO EMPLOYEE VALUES('14','Rudell','2');
INSERT INTO EMPLOYEE VALUES('15','McDade','1');
INSERT INTO EMPLOYEE VALUES('16','Ruellardo','1');
INSERT INTO EMPLOYEE VALUES('17','Smith','3');
INSERT INTO EMPLOYEE VALUES('20','Smith','2');

/* -- */


CREATE TABLE JOB (
JOB_CODE int,
JOB_DESCRIPTION varchar(20)
)
ENGINE = INNODB;

INSERT INTO JOB VALUES('1','Clerical');
INSERT INTO JOB VALUES('2','Technical');
INSERT INTO JOB VALUES('3','Managerial');



CREATE TABLE PLAN (
PLAN_CODE int,
PLAN_DESCRIPTION varchar(20)
)
ENGINE = INNODB;

INSERT INTO PLAN VALUES('1','Term life');
INSERT INTO PLAN VALUES('2','Stock purchase');
INSERT INTO PLAN VALUES('3','Long-term disability');
INSERT INTO PLAN VALUES('4','Dental');

