1 debes crear tu base de datos proyecto4to SEC
2 crear las cinco tablas tal como se indico en los videos
AHORA BIEN : solo contro V y control C
insert into CLIENTE
(CI,nombre,apellido,direccion,telefono)
value
(5798046,"WILDER","ARMELLA","CALLE R z pinos",7885428),
(1834505,"DELICIA","CORTEZ","CALLE 56 z green",7254872),
(2233046,"MERCEDES","MIRANDA","CALLE f z leon",7112081),
(5543170,"EDDIE","PERALTA","CALLE 67 z golketa",7985412),
(5785085,"JAIME","CRUZ","CALLE 80 z miraflores",7548352),
(5008608,"EDWIN","RAMIREZ","CALLE 12 z fuel",7888021),
(1830258,"SOLEDAD","FLORES","CALLE 4 z olivos",6654812),
(1880804,"RAMIRO","BENITEZ","CALLE 2 z golveta",2579457),
(1892870,"LAURA","CRUZ","plaza avaroa","1235798"),
(7193156,"LUCERO","RAMIEZZ","CALLE 5 z golbert",12374387)
;
...........................................................
insert into producto
(COD_PRODUCTO,NOMBRE,MARCA,COLOR,MODELO,STOCK,PRECIO)
values
(null,"lavajilla","balay","blanco","ju-301",15,31000),
(null,"lavadora","sansung","gris","ity-65",15,700),
(null,"cocina","dako","blanco","wqe-34",30,2400),
(null,"Cafetera","eletrolux","blanco","ui-95",34,1250),
(null,"tostadora","vidaelect","negro","ewq-65",15,2300),
(null,"secadora","fell","azul","32-uy","34",2400),
(null,"horno","continental","negro","12-fr",20,2120),
(null,"lavadora","continental","negro","23-ip",24,3000),
(null,"horno","continental","negro","81-th",10,1800),
(null,"licuadora","electrolux","azul","10-br",24,4000),
(null,"lavadora","oster","negro","17-nl",15,1250),
(null,"sumidora","bsh","rojo","10-kl",15,1250),
(null,"tostadora","continental","negro","13-am",30,2400),
(null,"cocina","continental","verde","70-dm",34,2300),
(null,"refrigerador","dako","gris","19-bf",20,3000),
(null,"batidora","bsh","negro","96-za",10,1800),
(null,"cafetera","continental","gris","ev-20",24,2300),
(null,"refrigerador","continental","rojo","ay-90",15,1800),
(null,"tostadora","bsh","blanco","77-kd",18,4000),
(null,"sumidora","continental","rojo","34-tb",16,1250),
(null,"licuadora","fell","verde","59-ax",16,1300),
(null,"cocina","electrolux","negro","30-em",28,1500)
;
..................................................................
insert into proveedor
(ID_PROVEEDOR,NOMBRE,DIRECCION,TELEFONO)
VALUES
(2018,"DORADO","CALLE 4 Z. OLIVOS",1694328),
(2371,"COPACABANA","CALLE 6 Z. OBRAJES",7885412),
(3249,"AURORA","CALLE 12 Z. SAN PEDRO",77364189),
(2015,"LA PRIMERA","CALLE A Z. KOLVER",2256788),
(1201,"DISMAC","CALLE 32 Z. SEYA",1279432)
;
.....................................................................
INSERT INTO compra
(CI,COD_PRODUCTO,FECHA_COMPRA,CANTIDAD)
VALUES
(5798046,103,"2019-08-01",3),
(1834505,102,"2019-08-02",2),
(2233046,103,"2019-08-02",2),
(5543170,104,"2019-08-03",4),
(5785085,105,"2019-08-01",2),
(5008608,106,"2019-08-04",1),
(1830258,107,"2019-08-05",2),
(1880804,108,"2019-08-06",4),
(1892870,109,"2019-08-05",1),
(7193156,110,"2019-08-06",3)
;
....................................................................
INSERT INTO provee
(ID_PROVEEDOR,COD_PRODUCTO,FECHA,CANTIDAD)
VALUES
(2018,103,"2019-04-01",24),
(2371,104,"2019-04-01",40),
(3249,102,"2019-04-01",15),
(2015,100,"2019-04-01",40),
(1201,101,"2019-04-01",12),
(2018,102,"2019-04-01",20),
(2371,108,"2019-04-02",24),
(3249,105,"2019-04-02",20),
(2015,106,"2019-04-02",12),
(2371,107,"2019-04-02",20),
(3249,108,"2019-04-03",40),
(2018,109,"2019-04-03",15),
(1201,110,"2019-04-04",40),
(3249,111,"2019-04-04",20),
(2018,112,"2019-04-05",24),
(2015,113,"2019-04-06",26),
(2371,112,"2019-04-06",20),
(2018,115,"2019-04-07",14),
(1201,116,"2019-04-07",24),
(2018,117,"2019-04-07",15),
(3249,118,"2019-04-07",24),
(2018,119,"2019-04-07",20),
(1201,120,"2019-04-07",40),
(2015,121,"2019-04-07",12),
(3249,122,"2019-04-08",25),
(1201,123,"2019-04-08",20),
(2371,121,"2019-04-09",12),
(2018,122,"2019-04-10",40),
(3249,110,"2019-04-10",15)
;
No hay comentarios:
Publicar un comentario