Datos de tbs antenor orrego

para ejecutar utiliza F5 o  F9

insert into TCarrera  values ('C0001','COMPUTACION');

insert into TCarrera  values ('C0002','MECANICA');

insert into TCarrera  values ('C0003','ENFERMERIA');

insert into TCarrera  values ('C0004','FARMACIA');

insert into TCarrera  values ('C0005','ADMINISTRACION');

insert into TCarrera  values ('C0006','CONTABILIDAD');

insert into TCarrera  values ('C0007','ELECTRONICA');

insert into TCarrera  values ('C0008','INGENERIA CIVIL');

insert into TCarrera  values ('C0009','ABOGADO');

insert into TCarrera  values ('C0010','DOCTOR');

select * from TCarrera;

insert into TUsuario  values ('U0001','124578940');

insert into TUsuario  values ('U0002','129864712');

insert into TUsuario  values ('U0003','187456022');

insert into TUsuario  values ('U0004','857496120');

insert into TUsuario  values ('U0005','285841025');

insert into TUsuario  values ('U0006','252205454');

insert into TUsuario  values ('U0007','154055410');

insert into TUsuario  values ('U0008','205441546');

insert into TUsuario  values ('U0009','541504489');

insert into TUsuario  values ('U0010','111055411');

insert into TUsuario  values ('U0011','124578940');

insert into TUsuario  values ('U0012','129864712');

insert into TUsuario  values ('U0013','187456022');

insert into TUsuario  values ('U0014','857496120');

insert into TUsuario  values ('U0015','285841025');

insert into TUsuario  values ('U0016','252205454');

insert into TUsuario  values ('U0017','154055410');

insert into TUsuario  values ('U0018','205441546');

insert into TUsuario  values ('U0019','541504489');

insert into TUsuario  values ('U0020','111055411');

insert into TUsuario  values ('U0021','124578940');

insert into TUsuario  values ('U0022','129864712');

insert into TUsuario  values ('U0023','187456022');

insert into TUsuario  values ('U0024','857496120');

insert into TUsuario  values ('U0025','285841025');

insert into TUsuario  values ('U0026','252205454');

insert into TUsuario  values ('U0027','154055410');

insert into TUsuario  values ('U0028','205441546');

insert into TUsuario  values ('U0029','541504489');

insert into TUsuario  values ('U0030','111055411');

select  * from tusuario;

insert into TAlumno  values ('A0001','MARQUEZ','JUAREZ','MARIA','20/05/1998','U0001','C0001');

insert into TAlumno  values ('A0002','NEYRA','LUJAN','LUISA','05/04/1970','U0002','C0002');

insert into TAlumno  values ('A0003','CACERES','CONTRERAS','JORGE','10/02/1990','U0003','C0003');

insert into TAlumno  values ('A0004','FERNANDEZ','VASQUEZ','JUAN','01/02/1920','U0004','C0004');

insert into TAlumno  values ('A0005','SALVADOR','LAURRARI','MARIO','25/09/1995','U0005','C0005');

insert into TAlumno  values ('A0006','CHU','JUAREZ','OSCAR','10/12/1940','U0006','C0006');

insert into TAlumno  values ('A0007','BERNAL','AZABACHE','CATALINA','12/05/1960','U0007','C0007');

insert into TAlumno  values ('A0008','ALTAMIRANO','TORRES','KAREN','19/06/1945','U0008','C0008');

insert into TAlumno  values ('A0009','CHUQUIVILCA','PONCE','SHIRLEY','16/09/1990','U0009','C0009');

insert into TAlumno  values ('A0010','ROBLES','MENDIZABALA','JUANA','12/06/1980','U0010','C0010');

insert into TAlumno  values ('A0011','AZABACHE','JUAREZ','JUANA','20/05/1998','U0011','C0001');

insert into TAlumno  values ('A0012','KAREN','LUJAN','LUISA','05/04/1970','U0012','C0002');

insert into TAlumno  values ('A0013','CACERES','JUAREZ','JORGE','10/02/1990','U0013','C0003');

insert into TAlumno  values ('A0014','AZABACHE','VASQUEZ','JUAN','01/02/1920','U0014','C0004');

insert into TAlumno  values ('A0015','SALVADOR','LAURRARI','JUANA','25/09/1995','U0015','C0005');

insert into TAlumno  values ('A0016','CHU','JUAREZ','OSCAR','10/12/1940','U0016','C0006');

insert into TAlumno  values ('A0017','AZABACHE','AZABACHE','CATALINA','12/05/1960','U0017','C0007');

insert into TAlumno  values ('A0018','ALTAMIRANO','TORRES','JUANA','19/06/1945','U0018','C0008');

insert into TAlumno  values ('A0019','CHUQUIVILCA','PONCE','SHIRLEY','16/09/1990','U0019','C0009');

insert into TAlumno  values ('A0020','AZABACHE','MENDIZABALA','JUANA','12/06/1980','U0020','C0010');

select *  From TAlumno;

INSERT INTO TDocente VALUES('D0001','PERALTA', 'CHAVEZ','JUAN','U0001');

INSERT INTO TDocente VALUES('D0002','AOLHUAY', 'ROJAS','MARCOS','U0002');

INSERT INTO TDocente VALUES('D0003','ROMERO', 'RIVERA','MARIO','U0003');

INSERT INTO TDocente VALUES('D0004','LUJAN' ,'CANCHARI','JUAN','U0004');

INSERT INTO TDocente VALUES('D0005','NEYRA', 'PRADO','JULIO','U0005');

INSERT INTO TDocente VALUES('D0006','CHU', 'JUAREZ','GLORIA','U0006');

INSERT INTO TDocente VALUES('D0007','VELASQUES', 'LAURRARI','JULIETA','U0007');

INSERT INTO TDocente VALUES('D0008','ESPETIA', 'RODRIGUEZ','MARTIN','U0008');

INSERT INTO TDocente VALUES('D0009','ZUMAETA', 'PEREZ','JESUS','U0009');

INSERT INTO TDocente VALUES('D0010','BERNAL', 'AZQABACHE','LUIS','U0010');

INSERT INTO TDocente VALUES('D0011','LAURRARI', 'AZQABACHE','LUIS','U0021');

INSERT INTO TDocente VALUES('D0012','CANCHARI', 'ROJAS','MARCOS','U0022');

INSERT INTO TDocente VALUES('D0013','ROMERO', 'AZQABACHE','MARIO','U0023');

INSERT INTO TDocente VALUES('D0014','CANCHARI' ,'CANCHARI','JUAN','U0024');

INSERT INTO TDocente VALUES('D0015','LAURRARI', 'PRADO','JULIO','U0025');

INSERT INTO TDocente VALUES('D0016','CHU', 'JUAREZ','GLORIA','U0026');

INSERT INTO TDocente VALUES('D0017','VELASQUES', 'LAURRARI','JULIETA','U0027');

INSERT INTO TDocente VALUES('D0018','CANCHARI', 'RODRIGUEZ','MARTIN','U0028');

INSERT INTO TDocente VALUES('D0019','ZUMAETA', 'PEREZ','JESUS','U0029');

INSERT INTO TDocente VALUES('D0020','LAURRARI', 'AZQABACHE','JESUS','U0030');

select * from TDocente;

INSERT INTO TAsignatura VALUES('S0001','MATEMATICAS','S0001');

INSERT INTO TAsignatura VALUES('S0002','REDES INALAMBRICAS','S0002');

INSERT INTO TAsignatura VALUES('S0003','INGLES','S0003');

INSERT INTO TAsignatura VALUES('S0004','COMUNICACION','S0004');

INSERT INTO TAsignatura VALUES('S0005','PROGRAMACION','S0005');

INSERT INTO TAsignatura VALUES('S0006','LOGIGA','S0006');

INSERT INTO TAsignatura VALUES('S0007','ESTADISTICAS','S0007');

INSERT INTO TAsignatura VALUES('S0008','ANALIS DE DISEÑO','S0008');

INSERT INTO TAsignatura VALUES('S0009','QUIMICA','S0009');

INSERT INTO TAsignatura VALUES('S0010','FISICA','S0010');

INSERT INTO TAsignatura VALUES('S0011','MATEMATICAS','S0001');

INSERT INTO TAsignatura VALUES('S0012','REDES INALAMBRICAS','S0002');

INSERT INTO TAsignatura VALUES('S0013','INGLES','S0003');

INSERT INTO TAsignatura VALUES('S0014','COMUNICACION','S0004');

INSERT INTO TAsignatura VALUES('S0015','PROGRAMACION','S0005');

INSERT INTO TAsignatura VALUES('S0016','LOGIGA','S0006');

INSERT INTO TAsignatura VALUES('S0017','ESTADISTICAS','S0007');

INSERT INTO TAsignatura VALUES('S0018','ANALIS DE DISEÑO','S0008');

INSERT INTO TAsignatura VALUES('S0019','QUIMICA','S0009');

INSERT INTO TAsignatura VALUES('S0020','FISICA','S0010');

select * from TAsignatura;

INSERT INTO TNotas VALUES('A0001','S0001','I','10','18', '15');

INSERT INTO TNotas VALUES('A0002','S0002','II','18','15', '18');

INSERT INTO TNotas VALUES('A0003','S0003','III','12','14','18');

INSERT INTO TNotas VALUES('A0004','S0004','IV','19','16','18');

INSERT INTO TNotas VALUES('A0005','S0005','V','12','17','18');

INSERT INTO TNotas VALUES('A0006','S0006','II','16','12', '18');

INSERT INTO TNotas VALUES('A0007','S0007','IV','15','11', '18');

INSERT INTO TNotas VALUES('A0008','S0008','VI','12','12','18');

INSERT INTO TNotas VALUES('A0009','S0009','V','20','16','18');

INSERT INTO TNotas VALUES('A0010','S0010','II','17,04','17,10','18');

INSERT INTO TNotas VALUES('A0011','S0001','I','10','18', '18');

INSERT INTO TNotas VALUES('A0012','S0002','II','18,95','15', '18');

INSERT INTO TNotas VALUES('A0013','S0003','III','12','14', '18');

INSERT INTO TNotas VALUES('A0014','S0004','IV','19','16', '18');

INSERT INTO TNotas VALUES('A0015','S0005','V','12','17', '18');

INSERT INTO TNotas VALUES('A0016','S0006','V','12','17', '18');

INSERT INTO TNotas VALUES('A0017','S0007','IV','15','11', '18');

INSERT INTO TNotas VALUES('A0018','S0008','VI','12','12','13');

INSERT INTO TNotas VALUES('A0019','S0009','V','20','16','15');

INSERT INTO TNotas VALUES('A0020','S0010','II','17','17','15');

select * from TNotas;

INSERT INTO TCarga VALUES('C0001','D0001','S0001','I');

INSERT INTO TCarga VALUES('C0002','D0002','S0002','II');

INSERT INTO TCarga VALUES('C0003','D0003','S0003','III');

INSERT INTO TCarga VALUES('C0004','D0004','S0004','IV');

INSERT INTO TCarga VALUES('C0005','D0005','S0005','V');

INSERT INTO TCarga VALUES('C0006','D0006','S0006','VI');

INSERT INTO TCarga VALUES('C0007','D0007','S0007','III');

INSERT INTO TCarga VALUES('C0008','D0008','S0008','II');

INSERT INTO TCarga VALUES('C0009','D0009','S0009','V');

INSERT INTO TCarga VALUES('C0010','D0010','S0010','I');

INSERT INTO TCarga VALUES('C0011','D0001','S0001','I');

INSERT INTO TCarga VALUES('C0012','D0002','S0002','II');

INSERT INTO TCarga VALUES('C0013','D0003','S0003','III');

INSERT INTO TCarga VALUES('C0014','D0004','S0004','IV');

INSERT INTO TCarga VALUES('C0015','D0005','S0005','V');

INSERT INTO TCarga VALUES('C0016','D0006','S0006','VI');

INSERT INTO TCarga VALUES('C0017','D0007','S0007','III');

INSERT INTO TCarga VALUES('C0018','D0008','S0008','II');

INSERT INTO TCarga VALUES('C0019','D0009','S0009','V');

INSERT INTO TCarga VALUES('C0020','D0010','S0010','I');

select * from TCarga;