[sql] PROJ-SCRIPTS-FMCGGLOABAL

Viewer

copydownloadembedprintName: PROJ-SCRIPTS-FMCGGLOABAL
  1. CREATE DATABASE `FMCGGLOBAL;
  2. USE FMCGGLOBAL;
  3. CREATE TABLE EMPLOYEES(EMPLOYEE_ID CHAR(5) PRIMARY KEY,EMPLOYEE_NAME CHAR(50),BIRTH_DATE DATE, TITLE CHAR(60),HIRE_DATE DATE,CONTACT_NO BIGINT);
  4. INSERT INTO EMPLOYEES VALUES('E001','KARTHIKA','1999-09-17','SALES MANAGER','2015-03-07','9123434567');
  5. INSERT INTO EMPLOYEES VALUES('E002','KAMALI','1998-01-02','EXCECUTIVE OFFICER','2000-11-18','0987654321');
  6. INSERT INTO EMPLOYEES VALUES('E003','PRABHA','1996-06-12','CUSTOMS MANAGER','2016-12-09','1234567890');
  7. INSERT INTO EMPLOYEES VALUES('E004','SUDHA','1993-04-26','PRODUCT MANAGER','2019-06-02','123456123456');
  8. INSERT INTO EMPLOYEES VALUES('E005','SANDHIYA','1990-11-28','CASHIER','2014-08-23','2456782910');
  9. SELECT * FROM EMPLOYEES;
  10. CREATE TABLE SUPPLIERS(SUPPLIER_ID CHAR(5),SUPPLIER_NAME CHAR(70) ,ADDRESS VARCHAR(80),CONTACT_NO BIGINT);
  11. INSERT INTO SUPPLIERS VALUES('S001','MANI','NO-8,SABRAI TOWERS,KARAIKUDI','2345678901');
  12. INSERT INTO SUPPLIERS VALUES('S002','SARVESH','NO-8,WEST SITE,SALEM','11122334455');
  13. INSERT INTO SUPPLIERS VALUES('S003','SREEKANTH','NO-2,PALAK TOWERS ,ANDHRA','9999911111');
  14. INSERT INTO SUPPLIERS VALUES('S004','PAVITHRA','NO-9,NAVIN TOWERS,CHENNAI','0902324441');
  15. INSERT INTO SUPPLIERS VALUES('S005','SAKTHI','NO-6,GANDHI ROAD,MADURAI','12345678890');
  16. SELECT * FROM SUPPLIERS;
  17. CREATE TABLE CUSTOMERS(CUSTOMER_ID CHAR(5) PRIMARY KEY,CUSTOMER_NAME CHAR(50), ADDRESS VARCHAR(50),CONTACT_NO BIGINT);
  18. INSERT INTO CUSTOMERS VALUES('C001','PRIYA','2-EAST COAST ROAD -CHENNAI','34353627289');
  19. INSERT INTO CUSTOMERS VALUES('C002','AHILA','4-WEST COAST ROAD -ALANDUR','34353627289');
  20. INSERT INTO CUSTOMERS VALUES('C003','ABHI','6-NORTH COAST ROAD MYLAPORE','34353627289');
  21. INSERT INTO CUSTOMERS VALUES('C004','SUHI','8-SOUTH COAST ROAD MAANGADU','34353627289');
  22. INSERT INTO CUSTOMERS VALUES('C005','SUMI','10-EAST -WEST COAST ROAD-SAIDAPET ','34353627289');
  23. SELECT * FROM CUSTOMERS;
  24. drop table products;
  25. CREATE TABLE PRODUCTS(PRODUCT_ID CHAR(5)PRIMARY KEY,PRODUCT_NAME CHAR(50),PRICE int,AVAILABLE_QUANTITY INT,EXPIRY_DATE DATE, SUPPLIER_ID CHAR(5),CUSTOMER_ID CHAR(5),REORDER_LEVEL INT,REMARKS CHAR(6));
  26. INSERT INTO PRODUCTS VALUES('P001','BISCUIT',123,5,'2024-01-18','S001','C001',10,'YES');
  27. INSERT INTO PRODUCTS VALUES('P002','SALT',19,5,'2022-02-17','S002','C002',7,'NO');
  28. INSERT INTO PRODUCTS VALUES('P003','CLASSMATE-NOTE',125,5,'2026-03-23','S003','C003',6,'YES');
  29. INSERT INTO PRODUCTS VALUES('P004',' HIMALAYAS-LIPSTICK',80,5,'2025-04-19','S004','C004',8,'NO');
  30. INSERT INTO PRODUCTS VALUES('P005','LUX SOAP',45,5,'2023-01-28','S005','C005',25,'YES');
  31. describe products;
  32. SELECT * FROM PRODUCTS;
  33. CREATE TABLE CATEGORIES(CATEGORY_ID CHAR(6) PRIMARY KEY,CATEGORY_NAME VARCHAR(60),DESCRIPTION CHAR(30));
  34. INSERT INTO CATEGORIES VALUES('CY001','FOOD','HEALTHY CONTENT');
  35. INSERT INTO CATEGORIES VALUES('CY002','HOME NEEDS','HEALTHY MUST IMPORTANT');
  36. INSERT INTO CATEGORIES VALUES('CY003','STATIONARY','CLASS PAPERS');
  37. INSERT INTO CATEGORIES VALUES('CY004','COSMETICS','NO DEMAGE');
  38. INSERT INTO CATEGORIES VALUES('CY005','CLEANING','NICE FRAGRANCE');
  39. SELECT * FROM CATEGORIES;
  40. CREATE TABLE ORDERS(ORDER_ID CHAR(5) PRIMARY KEY,CUSTOMER_ID CHAR(5),EMPLOYEE_ID CHAR(5),ORDER_DATE DATE,REQUIRED_DATE DATE,SHIPPED_DATE DATE,SHIIPING_ADDRESS VARCHAR(80));
  41. INSERT INTO ORDERS VALUES('O001','C001','E001','2022-01-18','2022-01-25','2022-01-30','N0-1,MARKET ROARD-PALANI');
  42. INSERT INTO ORDERS VALUES('O002','C002','E002','2021-02-23','2022-07-26','2022-06-20','N0-2,RAIDS ROARD-DINDIGUL');
  43. INSERT INTO ORDERS VALUES('O003','C003','E003','2020-04-25','2022-09-27','2022-08-10','N0-3,SCHOOL ROARD-COIMBATORE');
  44. INSERT INTO ORDERS VALUES('O004','C004','E004','2018-06-09','2022-03-28','2022-09-25','N0-4,BANK ROARD-SINGAPORE');
  45. INSERT INTO ORDERS VALUES('O005','C005','E005','2019-05-15','2022-02-23','2022-03-28','N0-5,TOWERS ROARD-AMERICA');
  46. SELECT * FROM ORDERS;
  47. CREATE TABLE ORDER_DETAILS(ORDER_ID CHAR(5) PRIMARY KEY,PRODUCT_ID CHAR(5),QUANTITY INT(60),DISCOUNT  INT(20));
  48. INSERT INTO ORDER_DETAILS VALUES('O001','P001','12','10');
  49. INSERT INTO ORDER_DETAILS VALUES('O002','P002','22','20');
  50. INSERT INTO ORDER_DETAILS VALUES('O003','P003','89','30');
  51. INSERT INTO ORDER_DETAILS VALUES('O004','P004','82','40');
  52. INSERT INTO ORDER_DETAILS VALUES('O005','P005','60','50');
  53. SELECT * FROM ORDER_DETAILS;
  54. CREATE TABLE PAYMENT_DETAILS(PAYMENT_ID CHAR(5) PRIMARY KEY,ORDER_ID CHAR(5),AMOUNT FLOAT,PAYMENT_DATE DATETIME,PAYMENT_TYPE CHAR(60));
  55. INSERT INTO PAYMENT_DETAILS VALUES('PY001','O001','2000.09','2022-03-19 09:43:23','DEBIT-CARD');
  56. INSERT INTO PAYMENT_DETAILS VALUES('PY002','O002','4000.89','2022-04-29 08:33:13','CREDIT-CARD');
  57. INSERT INTO PAYMENT_DETAILS VALUES('PY003','O003','6000.23','2022-05-12 07:23:19','NET-BANKING');
  58. INSERT INTO PAYMENT_DETAILS VALUES('PY004','O004','1000.19','2022-06-15 06:13:10','CASH-0N-DELIVERY');
  59. INSERT INTO PAYMENT_DETAILS VALUES('PY005','O005','8000.49','2022-07-10 04:83:12','GOOGLE-PAY');
  60. SELECT * FROM PAYMENT_DETAILS;
  61.  
  62. describe table products;
  63. DELETE FROM PRODUCTS WHERE PRODUCT_ID='poo1';
  64.  
  65.  

Editor

You can edit this paste and save as new:


File Description
  • PROJ-SCRIPTS-FMCGGLOABAL
  • Paste Code
  • 24 Jan-2022
  • 4.99 Kb
You can Share it: