
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;