Ejemplo simple de Conexion a Base de datos

1. Ejecutar Mysql
   



2. Creando la base de datos colegio:
   
   


3. Usar la base de datos colegio:
   
   
4. 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);
   
   
   
   
5.