SQL Assignment Help on Oracle Environment

• 31st Mar, 2022
• 16:23 PM

-------CREATE TABLE DEPARTMENT
CREATE TABLE DEPARTMENT(DEPARTMENT_ID INT PRIMARY KEY, DEPARTMENT_Name VARCHAR(50));
-----INSERT
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(101,'MARKETING');
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(102,'SALES');
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(103,'ADVERTISING');
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(104,'MANUFACTURING');
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(105,'PRODUCE');
INSERT INTO DEPARTMENT(DEPARTMENT_ID, DEPARTMENT_Name)VALUES(106,'MARKETING');
-------DROP  TABLE DEPARTMENT
DROP TABLE DEPARTMENT;
-------CREATE TABLE JOB
CREATE TABLE JOB(JOB_ID INT PRIMARY KEY, JOB_TITLE VARCHAR(50));
---INSERT
INSERT INTO JOB(JOB_ID, JOB_TITLE )VALUES(111,'SUPERVISOR');
INSERT INTO JOB(JOB_ID, JOB_TITLE )VALUES(112,'ADMIN');
INSERT INTO JOB(JOB_ID, JOB_TITLE )VALUES(113,'EMPLOYEE');
INSERT INTO JOB(JOB_ID, JOB_TITLE )VALUES(114,'MANAGER');
INSERT INTO JOB(JOB_ID, JOB_TITLE )VALUES(115,'SUPERVISOR');
-------DROP  TABLE JOB
DROP  TABLE JOB;
-------CREATE TABLE EMPLOYEE
CREATE TABLE EMPLOYEE(EMPLOYEE_ID INT PRIMARY KEY, EMPLOYEE_NAME VARCHAR(50));
-------INSERT
INSERT INTO EMPLOYEE(EMPLOYEE_ID ,EMPLOYEE_NAME)VALUES(1,'BROWN MIKE');
INSERT INTO EMPLOYEE(EMPLOYEE_ID, EMPLOYEE_NAME)VALUES(2,'LUCY MIKE');
INSERT INTO EMPLOYEE(EMPLOYEE_ID ,EMPLOYEE_NAME)VALUES(3,'TOM ROY');
INSERT INTO EMPLOYEE(EMPLOYEE_ID ,EMPLOYEE_NAME)VALUES(4,'JOHN SMITH');
INSERT INTO EMPLOYEE(EMPLOYEE_ID ,EMPLOYEE_NAME)VALUES(5,'PUPPY TOM');
-------DROP TABLE EMPLOYEE
DROP TABLE EMPLOYEE;
-------CREATE TABLE CUSTOMER
CREATE TABLE CUSTOMER(CUSTOMER_ID INT PRIMARY KEY, CUSTOMER_NAME VARCHAR(50));
-----INSERT
INSERT INTO CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME)VALUES(1,'SWEETY ALFREDS');
INSERT INTO CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME)VALUES(2,'HUMA KURESHI');
INSERT INTO CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME)VALUES(3,'TOM CRUZE');
INSERT INTO CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME)VALUES(4,'HALLOW POM');
INSERT INTO CUSTOMER(CUSTOMER_ID, CUSTOMER_NAME)VALUES(5,'SWEETY ALFREDS');
-------DROP TABLE CUSTOMER
DROP TABLE CUSTOMER;
-------CREATE TABLE SUPPLIER
CREATE TABLE SUPPLIER(SUPPLIER_ID INT PRIMARY KEY, SUPPLIER_NAME VARCHAR(50));
------INSERT
INSERT INTO SUPPLIER(SUPPLIER_ID, SUPPLIER_NAME)VALUES(101,'SUPPLIER 1');
INSERT INTO SUPPLIER(SUPPLIER_ID, SUPPLIER_NAME)VALUES(102,'SUPPLIER 2');
INSERT INTO SUPPLIER(SUPPLIER_ID, SUPPLIER_NAME)VALUES(103,'SUPPLIER 3');
INSERT INTO SUPPLIER(SUPPLIER_ID, SUPPLIER_NAME)VALUES(104,'SUPPLIER 1');
INSERT INTO SUPPLIER(SUPPLIER_ID, SUPPLIER_NAME)VALUES(105,'SUPPLIER 2');
-------DROP TABLE SUPPLIER
DROP TABLE SUPPLIER;