Proyecto Bd Sql

Universidad Tecnológica de México
Campus Sur

Base de Datos I
Proyecto final
Manejo de Vivero
Ignacio Ramírez García
José Luis Rodríguez Rdz.

Manipulación de datos.
* Insertar datos para cada una de las tablas (5 reg.).
Arren366
SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO ARREN366
2(CVE_ARRE,NOMBRE,APATERNO,AMATERNO,CALLE,COLONIA,ESTADO,CIUDAD,TELCASA,TELCEL,TELOTRO,ESTATUSAR
3* VALUES(5,'LUIS', 'RODRIGUEZ','ROPDRIGUEZ','NORTE 9','MOCTEZUMA','DF','MEXICO',55621112,555,5555
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO ARREN366
2 (CVE_ARRE,NOMBRE,APATERNO,AMATERNO,CALLE,COLONIA,ESTADO,CIUDAD,TELCASA,TELCEL,TELOTRO,ESTATUSAR
3* VALUES(15,'LUISA', 'RODRIGUEZ','ROPDRIGUEZ','NORTE9','MOCTEZUMA','DF','MEXICO',1515151515,1515
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO ARREN366
2 (CVE_ARRE,NOMBRE,APATERNO,AMATERNO,CALLE,COLONIA,ESTADO,CIUDAD,TELCASA,TELCEL,TELOTRO,ESTATUSAR
3* VALUES(25,'MALUISA', 'RODRIGUEZ','LOPEZ','NORTE 45','MOCTEZUMA','DF','MEXICO',2525252522525,151
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf1 INSERT INTO ARREN366
2 (CVE_ARRE,NOMBRE,APATERNO,AMATERNO,CALLE,COLONIA,ESTADO,CIUDAD,TELCASA,TELCEL,TELOTRO,ESTATUSAR
3* VALUES(50,'MARTA', 'SALAS','LOPEZ','PITAGORAS 15','SOL','EDO MEX','NEZA',5050505050,151515,1515
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO ARREN366
2(CVE_ARRE,NOMBRE,APATERNO,AMATERNO,CALLE,COLONIA,ESTADO,CIUDAD,TELCASA,TELCEL,TELOTRO,ESTATUSAR
3* VALUES(100,'ERICK', 'CONTRERAS','SOLORIO','SAN MIGUEL 23','AAZUL','DF','MEXICO',100100100,15151
SQL> /

1 row created.

CLASLOC366
SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO CLASLOC366
2 (CVECLA,DESCRIPCION,TOTAL_LOC)
3* VALUES(1,'PLANTAS DE SOL',10)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1INSERT INTO CLASLOC366
2 (CVECLA,DESCRIPCION,TOTAL_LOC)
3* VALUES(2,'PLANTAS DE SOMBRA',10)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO CLASLOC366
2 (CVECLA,DESCRIPCION,TOTAL_LOC)
3* VALUES(3,'JARDINERIA',10)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO CLASLOC366
2(CVECLA,DESCRIPCION,TOTAL_LOC)
3* VALUES(4,'AZALEAS',20)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO CLASLOC366
2 (CVECLA,DESCRIPCION,TOTAL_LOC)
3* VALUES(5,'VARIOS',50)
SQL> /

1 row created.

LOCALES366
SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO LOCALES366
2 (CVE_LOC,LOTE,NOLOC,CVE_ARRE,CVE_CLA)
3* VALUES('L1',1,1,'1',1)
SQL> /1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO LOCALES366
2 (CVE_LOC,LOTE,NOLOC,CVE_ARRE,CVE_CLA)
3* VALUES('L2',2,2,'5',2)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO LOCALES366
2 (CVE_LOC,LOTE,NOLOC,CVE_ARRE,CVE_CLA)
3* VALUES('L3',3,3,'25',3)
SQL> /

1 row created.

SQL> EDIT
Wrote fileafiedt.buf

1 INSERT INTO LOCALES366
2 (CVE_LOC,LOTE,NOLOC,CVE_ARRE,CVE_CLA)
3* VALUES('L4',4,4,'50',4)
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO LOCALES366
2 (CVE_LOC,LOTE,NOLOC,CVE_ARRE,CVE_CLA)
3* VALUES('L5',5,5,'50',5)
SQL> /

VENTAS366
SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO VENTAS366
2(FOLIO,FECHA,CVE_LOC,DESCRIPCION,TOTAL,ESTATUS)
3* VALUES(1,'29/12/10','L1','MENUDEO',500,'R')
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO VENTAS366
2 (FOLIO,FECHA,CVE_LOC,DESCRIPCION,TOTAL,ESTATUS)
3* VALUES(2,'25/11/10','L1','MENUDEO',100,'R')
SQL> /

1 row created.

SQL> EDIT
Wrote file afiedt.buf

1 INSERT INTO VENTAS366
2...