SQL DDL File
DROP TABLE DEPARTMENT;
DROP TABLE EMPLOYEE;
CREATE TABLE DEPARTMENT
(
D_ID INT,
D_NAME VARCHAR(20) NOT NULL,
CONSTRAINT DEPRT_ID_PK PRIMARY KEY (D_ID)
);
INSERT INTO DEPARTMENT VALUES (20,'TRAINING');
INSERT INTO DEPARTMENT VALUES (21,'SALES');
INSERT INTO DEPARTMENT VALUES (22,'DIGITAL MARKETING');
INSERT INTO DEPARTMENT VALUES (23,'OPERATIONS');
INSERT INTO DEPARTMENT VALUES (24,'CREATIVE TEAM');
INSERT INTO DEPARTMENT VALUES (25,'BUssiness Dev');
INSERT INTO DEPARTMENT VALUES (26,'FINANCE');
SQL DDL File
CREATE TABLE EMPLOYEE
(
E_ID int,
E_FNAME VARCHAR(15) NOT NULL,
E_LNAME VARCHAR(15) NOT NULL,
E_EMAIL VARCHAR(25),
E_PHONE_NO int,
HIRE_DATE DATE NOT NULL,
SALARY FLOAT,
COMMISSION_PCT FLOAT,
D_ID INT,
CONSTRAINT EMPL_EMP_ID_PK PRIMARY KEY (E_ID),
CONSTRAINT EMP_DEPAT_FK FOREIGN KEY (D_ID) REFERENCES
DEPARTMENT(D_ID)
);
INSERT INTO EMPLOYEE VALUES
(1,'Michael','Smith','michael@gmail.com',9997766,'2012-03-29',34000.00,1.0,22);
INSERT INTO EMPLOYEE VALUES
(2,'William','taylor','william@gmail.com',77665522,'2012-05-25',45000.00,2.0,23);
INSERT INTO EMPLOYEE VALUES
(3,'Richard','Miller','richard@gmail.com',876297,'2012-04-19',55000.00,0.4,24);
INSERT INTO EMPLOYEE VALUES
(4,'Joseph','K','joseph@gmail.com',66554433,'2013-02-27',36000.00,0.5,22);
INSERT INTO EMPLOYEE VALUES
(5,'John','Williams','john@gmail.com',7456465,'2010-12-15',18000.00,1.5,25);
SQL DDL File
INSERT INTO EMPLOYEE VALUES
(6,'Thomas','Raj','thomas@gmail.com',9575673,'2010-08-25',85000.00,0.6,26);
INSERT INTO EMPLOYEE VALUES
(7,'Andy','Smith','andy@gmail.com',8579452,'2012-08-28',28500.00,0.9,22);
INSERT INTO EMPLOYEE VALUES
(8,'Aaron','Samuels','araon@gmail.com',5423424,'2014-06-24',12000.00,5.5,26);
INSERT INTO EMPLOYEE VALUES
(9,'Adam','Sam','adam@gmail.com',325674,'2015-04-16',53000.00,1.2,26);
INSERT INTO EMPLOYEE VALUES
(10,'Nancy','A','nancy@gmail.com',3453424,'2016-10-25',53000.00,1.2,22);
INSERT INTO EMPLOYEE VALUES
(11,'Madavan','Manish','madavan@gmail.com',4353213,'2016-12-
30',25000.00,0.3,21);
INSERT INTO EMPLOYEE VALUES
(12,'Jennifer','Anderson','jenni@gmail.com',12342231,'2018-09-
27',45500.00,0.2,21);
INSERT INTO EMPLOYEE VALUES
(13,'Mamatha','T','mamatha@gmail.com',53434334,'2019-07-25',46000.00,1.2,21);
INSERT INTO EMPLOYEE VALUES
(14,'Savitha','Singh','savi@gmail.com',3443333,'2022-03-23',12000.00,0.15,23);
INSERT INTO EMPLOYEE VALUES
(15,'Susan','Kumar','mru@gmail.com',322378445,'2023-04-30',19500.00,1.2,25);
SQL DDL File
