- Ejecutar Mysql
- Creando la base de datos colegio:
- Usar la base de datos colegio:
- Ejecutar el siguiente script
create table alumno(
idalumno char(5) primary key,
paterno varchar(20),
materno varchar(20),
nombre varchar(20),
direccion varchar(80),
correo varchar(50));
create table matricula(
idmatricula char(5) primary key,
idalumno char(5) references alumno,
alectivo char(4),
fecha date,
seccion char (1),
turno char(1),
grado char(2));
create table curso(
idcurso char(5) primary key,
curso varchar(30));
create table nota(
idmatricula char(5) references matricula,
idcurso char(5) references curso,
unidad char(1),
nota numeric);
--ingresando cursos ----
insert into curso values('0001','Aritmetica');
insert into curso values('0002','Algebra');
insert into curso values('0003','Geometria');
insert into curso values('0004','Trigonometria');
insert into curso values('0005','Fisica');
insert into curso values('0006','Quimica');
insert into curso values('0007','Ciencias Naturales');
insert into curso values('0008','Comunicacion');
insert into curso values('0009','Ingles');
insert into curso values('0010','Computacion e informatica');
insert into curso values('0011','Geografia');
insert into curso values('0012','Eduacion civica');
--ingresando alumnos---
insert into alumno values('10000','Rivas','Rojas','Cesar','Av. Tacna N° 105','cesarivas@gmail.com');
insert into alumno values('10001','Condori','Choquehuanca','Monica Marlene','Av. Lima N° 555','monica_406@hotmail.com');
insert into alumno values('10002','Berrospi','Arrieta','Ruth Analiz','Av. Canto Grande N° 1650','ruthanalis@hotmail.com');
insert into alumno values('10003','Soto','Aldama','Luis Alberto','Av. Rimac N° 145','sotoaldama@hotmail.com');
insert into alumno values('10004','Rosas','Pajuelo','Joel','Av. Vipol N° 450','joelrosas@hotmail.com');
insert into alumno values('10005','Soto','Gamarra','Eugenio','Av. Los suspiros N° 350','melibere@hotmail.com');
insert into alumno values('10006','Prudencio','Espinoza','Domingo','Jr. Carcamo N° 450','rprudencio@hotmail.com');
--ingresando matricula---
insert into matricula values('10000','10000','2007','20070315','A','M','1P');
insert into matricula values('10001','10001','2007','20070416','B','M','2P');
insert into matricula values('10002','10002','2007','20070624','A','M','3P');
insert into matricula values('10003','10003','2008','20080114','A','M','3P');
insert into matricula values('10004','10000','2007','20070317','A','M','2S');
insert into matricula values('10005','10001','2008','20080218','A','M','1S');
insert into matricula values('10006','10002','2008','20080416','A','M','3S');
--ingresando nota---
insert into nota values('10000','0001','1',14);
insert into nota values('10000','0002','1',16);
insert into nota values('10000','0003','1',18);
insert into nota values('10000','0004','1',20);
insert into nota values('10000','0005','1',14);
insert into nota values('10000','0006','1',16);
insert into nota values('10000','0007','1',17);
insert into nota values('10000','0008','1',13);
insert into nota values('10000','0009','1',08);
insert into nota values('10000','0010','1',19);
insert into nota values('10000','0011','1',15);
insert into nota values('10000','0001','2',14);
insert into nota values('10000','0002','2',18);
insert into nota values('10000','0003','2',17);
insert into nota values('10000','0004','2',20);
insert into nota values('10000','0005','2',18);
insert into nota values('10000','0006','2',16);
insert into nota values('10000','0007','2',18);
insert into nota values('10000','0008','2',19);
insert into nota values('10000','0009','2',17);