--------------------------------------------------------MY
SQL--------------------------------------------------
CREAR TABLAS
CREATE TABLE CLIENTE (NCLIE INTEGER NOT NULL, NOMBRECL VARCHAR(30) NOT NULL, DIRECC
VARCHAR(20), TEL VARCHAR(15),CIUDAD VARCHAR (15) , PRIMARY KEY (NCLIE));
CREATE TABLE PRODUCTO(CODIGO INTEGER NOT NULL, DESCRIPCION VARCHAR(30), PRECIO
FLOAT, PRIMARY KEY (CODIGO));
CREATE TABLE FACTURA(NFACT INTEGER NOT NULL, FECHA DATE, NCLIENTE INTEGER NOT NULL,
TOTAL FLOAT, PRIMARY KEY (NFACT), FOREIGN KEY (NCLIENTE) REFERENCES CLIENTE
(NCLIE));
CREATE TABLE ITEM (NFACT INTEGER NOT NULL, CODIGOP INTEGER NOT NULL , CANTIDAD
FLOAT, SUBTOTAL FLOAT, PRIMARY KEY (NFACT,CODIGOP),FOREIGN KEY (NFACT) REFERENCES
FACTURA (NFACT), FOREIGN KEY (CODIGOP) REFERENCES PRODUCTO (CODIGO));
INSERTAR CLIENTES:
INSERT INTO CLIENTE VALUES(1057,'WILIAM', 'CALLE 101 # 33 A 15','3167628102',
'MANIZALES');
INSERT INTO CLIENTE VALUES(1058,'YOLANDA', 'CALLE 96 # 46 C 15','3124729124',
'PEREIRA');
INSERT INTO CLIENTE VALUES(1059,'HERCILIA', 'CARRERA 50 # 17','3114729124',
'CALI');
INSERT INTO CLIENTE VALUES(1060,'ASHLEY', 'CARRERA 25 # 40 02','3104829164',
'IBAGUE');
INSERT INTO CLIENTE VALUES(1061,'ISABELLA', 'AVENIDA 67 # 12 84','8840612',
'MANZANARES');
INSERT INTO CLIENTE VALUES(1062,'SEBASTIAN', 'KM 47 # 12','7376545', 'CARTAGO');
INSERTAR PRDUCTOS:
INSERT INTO producto VALUES (2056,'ARROZ',1200);
INSERT INTO producto VALUES (2057,'PAPA',2500);
INSERT INTO producto VALUES (2058,'CARNE',4500);
INSERT INTO producto VALUES (2059,'PLATANO',800);
INSERT INTO producto VALUES (2060,'CHICARRON',37000);
INSERTAR FACTURA:
INSERT INTO FACTURA VALUES (3056,'2022-04-01',1056,20000);
INSERT INTO FACTURA VALUES (3057,'2022-06-12',1057,186900);
INSERT INTO FACTURA VALUES (3058,'2023-01-06',1058,127350);
INSERT INTO FACTURA VALUES (3059,'2022-10-12',1059,11000);
INSERT INTO FACTURA VALUES (3060,'2023-04-01',1060,284000);
INSERT INTO FACTURA VALUES (3061,'2022-02-09',1061,5800);
INSERT INTO FACTURA VALUES (3062,'2022-11-11',1062,755000);
INSERT INTO FACTURA VALUES (3063,'2023-08-06',1051,9000);
INSERT INTO FACTURA VALUES (3064,'2022-07-03',1052,153000);
INSERT INTO FACTURA VALUES (3065,'2021-05-10',1053,1200);
INSERTAR ITEM:
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3051,2051,1,88000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3052,2052,3,1000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3053,2053,5,1600);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3054,2054,1,150000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3055,2055,2,27000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3056,2056,6,39000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3057,2057,3,13000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3058,2058,1,16200);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3059,2059,4,90000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3060,2060,3,233000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3061,2054,1,13050);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3062,2053,2,396250);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3063,2055,5,242000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3064,2052,1,35000);
INSERT INTO ITEM (NFACT,CODIGOP,CANTIDAD,SUBTOTAL) VALUES (3065,2051,6,662000);