Taller Consultas Relacionales
BASE DE DATOS INSTITUCIÓN EDUCATIVA
Modelo Entidad Relación
Codigos de la Base de Datos
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| libreria |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
| webauth |
+--------------------+
8 rows in set (0.09 sec)
mysql> create database colegio;
Query OK, 1 row affected (0.03 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| colegio |
| libreria |
| mysql |
| performance_schema |
| phpmyadmin |
| test |
| webauth |
+--------------------+
9 rows in set (0.00 sec)
mysql> use colegio;
Database changed
mysql> create table acudiente
-> (codacu char(3) not null primary key,
-> nombre char(40) not null,
-> direccion char(35) not null,
->
-> telefono char(10) not null,
-> email char(25) not null);
Query OK, 0 rows affected (0.52 sec)
mysql> create table estudiante
-> (codest char(5) not null primary key,
-> nombre char(40) not null,
-> direccion char(35) not null,
-> telefono char(10) not null,
-> email char(25) not null);
Query OK, 0 rows affected (0.41 sec)
mysql> create table materia
-> (codmat char(2) not null primary key,
-> nombre char(40) not null);
Query OK, 0 rows affected (0.20 sec)
mysql> create table profesor
-> (codpro char(3) not null primary key,
-> nombre char(40) not null,
-> direccion char(35) not null,
-> telefono char(10) not null,
-> email char(25) not null);
Query OK, 0 rows affected (0.22 sec)
mysql> show tables;
+-------------------+
| Tables_in_colegio |
+-------------------+
| acudiente |
| estudiante |
| materia |
| profesor |
+-------------------+
4 rows in set (0.00 sec)
mysql> create table estacu
-> (codacu char(3) not null,
-> codest char(5) not null,
-> foreign key (codacu) references acudiente (codacu) on delete cascade on update cascade,
-> foreign key (codest) references estudiante (codest) on delete cascade on update cascade);
Query OK, 0 rows affected (0.27 sec)
mysql> create table estmat
-> (codest char(5) not null,
-> codmat char(3) not null,
-> foreign key (codest) references estudiante (codest) on delete cascade on update cascade,
-> foreign key (codmat) references materia (codmat) on delete cascade on update cascade);
Query OK, 0 rows affected (0.23 sec)
mysql> create table matprof
-> (codmat char(2) not null,
-> codpro char(3) not null,
-> foreign key (codmat) references materia (codmat) on delete cascade on update cascade,
-> foreign key (codpro) references profesor (codpro) on delete cascade on update cascade);
Query OK, 0 rows affected (0.31 sec)
mysql> describe acudiente;
+-----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| codacu | char(3) | NO | PRI | NULL | |
| nombre | char(40) | NO | | NULL | |
| direccion | char(35) | NO | | NULL | |
| telefono | char(10) | NO | | NULL | |
| email | char(25) | NO | | NULL | |
+-----------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> describe estudiante;
+-----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| codest | char(5) | NO | PRI | NULL | |
| nombre | char(40) | NO | | NULL | |
| direccion | char(35) | NO | | NULL | |
| telefono | char(10) | NO | | NULL | |
| email | char(25) | NO | | NULL | |
+-----------+----------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> describe estacu;
+--------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| codacu | char(3) | NO | MUL | NULL | |
| codest | char(5) | NO | MUL | NULL | |
+--------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe estmat;
+--------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| codest | char(5) | NO | MUL | NULL | |
| codmat | char(3) | NO | MUL | NULL | |
+--------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe materia;
+--------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| codmat | char(2) | NO | PRI | NULL | |
| nombre | char(40) | NO | | NULL | |
+--------+----------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe profesor;
+-----------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------+------+-----+---------+-------+
| codpro | char(3) | NO | PRI | NULL | |
| nombre | char(40) | NO | | NULL | |
| direccion | char(35) | NO | | NULL | |
| telefono | char(10) | NO | | NULL | |
| email | char(25) | NO | | NULL | |
+-----------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)
mysql> describe matpro;
ERROR 1146 (42S02): Table 'colegio.matpro' doesn't exist
mysql> describe matprof;
+--------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| codmat | char(2) | NO | MUL | NULL | |
| codpro | char(3) | NO | MUL | NULL | |
+--------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('001','ACEVEDO CARDONA ESTEBAN','Barrio la pradera','5846069','estebancardona@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('002','AGUDELO MANCO DIANA PATRICIA','Barrio rosaleda','5882104','dianapatricia@gmail.com');
Query OK, 1 row affected (0.06 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('003','ZAPATA VALENCIA JORGE','Barrio aragon','5841998','jorgezapata@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('004','VELASQUEZ CANO JENNY ASTRID','Barrio la pradera','2791469','jennyvelasquez@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('005','POSADA VASCO ANA','Urbanizacion compartir','2868617','anaposada@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('006','ORTIZ PUERTA INDIRA','Urbanizacion ciudadela prado','5841497','indiraortiz@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('007','QUINTERO MENESES ADRIANA','Barrio san gabriel','5840570','adrianaquintero@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('008','MONTOYA RIVERA EDILMA','Barrio la pradera','3767289','edilmamontoya@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('009','LOPERA MONSALVE FERNANDO ALONSO','Barrio el limonar 1','5709957','fernandolopera@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into acudiente(codacu,nombre,direccion,telefono,email) values ('010','HENAO RIOS DORA EMILSE','Barrio el limonar 2','2866222','dorahenao@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00001','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebacardona@gmail.com');
Query OK, 1 row affected, 1 warning (0.06 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00002','ALVAREZ AGUDELO ESTEBAN','Barrio rosedal','5882104','zapataisabel@gmail.com');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00003','ZAPATA CAMPI¥O ISABEL','Barrio aragon','5841998','estebanlavarez@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00004','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00005','MORENO POSADA DIEGO ALEJANDRO','Urbanizacion compartir','2868617','diegomoreno@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00006','ALZATE ORTIZ JORGE MARIO','Urbanizacion ciudadela prado','5841497','marioalzate@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00007','ZAPATA QUINTERO JOSE MARIA','Bariio san gabriel','5840570','josezapata@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00008','MONTOYA MONTOYA ALEJANDRO','Bariio la pradera','3767289','alejandromontoya@gmail.com');
Query OK, 1 row affected, 1 warning (0.08 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00009','LOPERA CARTAGENA LUISA FERNANDA','Bariio el limonar 1','5709957','luisalopera@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00010','JARAMILLO HENAO JOSE LUIS','Barrio el limonar 2','2866222','josearamillo@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00011','ALVAREZ AGUDELO LUNA','Barrio rosedal','5882104','lunaalvarez@gmail.com');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estudiante(codest,nombre,direccion,telefono,email) values ('00012','ALVAREZ AGUDELO XAVIER','Barrio rosedal','5882104','xavieralvarez@gmail.com');
Query OK, 1 row affected (0.05 sec)
mysql> insert into materia(codmat,nombre) values ('01','ESPA¥OL');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('02','LECTOESCRITURA');
Query OK, 1 row affected (0.06 sec)
mysql> insert into materia(codmat,nombre) values ('03','MATEMATICAS');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('04','CIENCIAS SOCILAES');
Query OK, 1 row affected (0.04 sec)
mysql> insert into materia(codmat,nombre) values ('05','INVESTIGACION');
Query OK, 1 row affected (0.04 sec)
mysql> insert into materia(codmat,nombre) values ('06','FISICA');
Query OK, 1 row affected (0.05 sec)
mysql> insert into materia(codmat,nombre) values ('07','FILOSOFIA');
Query OK, 1 row affected (0.06 sec)
mysql> insert into materia(codmat,nombre) values ('08','EDUCACION FISICA');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('09','ETICA');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('10','ARTISTICA');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('11','TECNOLOGIA');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('12','INFORMATICA');
Query OK, 1 row affected (0.03 sec)
mysql> insert into materia(codmat,nombre) values ('13','RELIGION');
Query OK, 1 row affected (0.04 sec)
mysql> insert into materia(codmat,nombre) values ('14','SOCIALES');
Query OK, 1 row affected (0.04 sec)
mysql> insert into materia(codmat,nombre) values ('15','INGLES');
Query OK, 1 row affected (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('001','CIFUENTES MESA MYEIDY MARIA','myleidym.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('002','CUADRADO PEREZ ADRID JOSE','adrid.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('003','DUQUE RESTREPO ESTER LUCIA','esterl.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.03 sec)
mysql> insert into profesor(codpro,nombre,email) values ('004','GUIRALES MAURICIO','mauriciog.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('005','VERA DAZA MARIA ELENA','mariae.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('006','PALACIO TOMAS FELIPE','tomasf.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('007','MOSQUERA OSORIO MARYETH','maryeth.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('008','ARBOLEDA VARGAS MARIA OFELIA','ofeliaa.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.04 sec)
mysql> insert into profesor(codpro,nombre,email) values ('009','MOSCOTE MARULANDA YANETH MARIA','yanetm.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.02 sec)
mysql> insert into profesor(codpro,nombre,email) values ('010','MACIAS EDGAR ALBERTO','edgarm.iearm@gmail.com');
Query OK, 1 row affected, 2 warnings (0.02 sec)
mysql> insert into estacu(codacu,codest) values('001','00001');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estacu(codacu,codest) values('002','00002');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estacu(codacu,codest) values('003','00003');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estacu(codacu,codest) values('004','00004');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estacu(codacu,codest) values('005','00005');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estacu(codacu,codest) values('006','00006');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estacu(codacu,codest) values('007','00007');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estacu(codacu,codest) values('008','00008');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estacu(codacu,codest) values('009','00009');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estacu(codacu,codest) values('010','00010');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estacu(codacu,codest) values('001','00011');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estacu(codacu,codest) values('001','00012');
Query OK, 1 row affected (0.03 sec)
mysql> show tables;
+-------------------+
| Tables_in_colegio |
+-------------------+
| acudiente |
| estacu |
| estmat |
| estudiante |
| materia |
| matprof |
| profesor |
+-------------------+
7 rows in set (0.00 sec)
mysql> describe matprof;
+--------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| codmat | char(2) | NO | MUL | NULL | |
| codpro | char(3) | NO | MUL | NULL | |
+--------+---------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql> insert into matprof(codmat,codpro) values('01','005');
Query OK, 1 row affected (0.02 sec)
mysql> insert into matprof(codmat,codpro) values('02','007');
Query OK, 1 row affected (0.06 sec)
mysql> insert into matprof(codmat,codpro) values('03','009');
Query OK, 1 row affected (0.02 sec)
mysql> insert into matprof(codmat,codpro) values('04','003');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('05','003');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('06','003');
Query OK, 1 row affected (0.06 sec)
mysql> insert into matprof(codmat,codpro) values('07','001');
Query OK, 1 row affected (0.03 sec)
mysql> insert into matprof(codmat,codpro) values('08','010');
Query OK, 1 row affected (0.02 sec)
mysql> insert into matprof(codmat,codpro) values('09','006');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('10','004');
Query OK, 1 row affected (0.03 sec)
mysql> insert into matprof(codmat,codpro) values('11','002');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('12','002');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('13','006');
Query OK, 1 row affected (0.06 sec)
mysql> insert into matprof(codmat,codpro) values('14','007');
Query OK, 1 row affected (0.04 sec)
mysql> insert into matprof(codmat,codpro) values('15','008');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','01');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','02');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00001','03');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00001','04');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','05');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','06');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00001','07');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','08');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','09');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','10');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00001','11');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','12');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00001','13');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00001','14');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00001','15');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00002','01');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00002','02');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00002','03');
Query OK, 1 row affected (0.07 sec)
mysql> insert into estmat(codest,codmat) values('00002','04');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estmat(codest,codmat) values('00002','05');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00002','06');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00002','07');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00002','08');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00002','09');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00002','10');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00002','11');
Query OK, 1 row affected (0.07 sec)
mysql> insert into estmat(codest,codmat) values('00002','12');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00002','13');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00002','14');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00002','15');
Query OK, 1 row affected (0.07 sec)
mysql> insert into estmat(codest,codmat) values('00003','01');
Query OK, 1 row affected (0.29 sec)
mysql> insert into estmat(codest,codmat) values('00003','02');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00003','03');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','04');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','05');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','06');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00003','07');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00003','08');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','09');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','10');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00003','11');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','12');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estmat(codest,codmat) values('00003','13');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','14');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00003','15');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00004','01');
Query OK, 1 row affected (0.10 sec)
mysql> insert into estmat(codest,codmat) values('00004','02');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estmat(codest,codmat) values('00004','03');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','04');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00004','05');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','06');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00004','07');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00004','08');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','09');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','10');
Query OK, 1 row affected (0.07 sec)
mysql> insert into estmat(codest,codmat) values('00004','11');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estmat(codest,codmat) values('00004','12');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','13');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','14');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00004','15');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00005','01');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00005','02');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00005','03');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00005','04');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00005','05');
Query OK, 1 row affected (0.07 sec)
mysql> insert into estmat(codest,codmat) values('00005','06');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00005','07');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00005','08');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00005','09');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00005','10');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00005','11');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00005','12');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00005','13');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00005','14');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00005','15');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','01');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','02');
Query OK, 1 row affected (0.06 sec)
mysql> insert into estmat(codest,codmat) values('00006','03');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','04');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','05');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00006','06');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00006','07');
Query OK, 1 row affected (0.03 sec)
mysql> insert into estmat(codest,codmat) values('00006','08');
Query OK, 1 row affected (0.02 sec)
mysql> insert into estmat(codest,codmat) values('00006','09');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','10');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','11');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','12');
Query OK, 1 row affected (0.05 sec)
mysql> insert into estmat(codest,codmat) values('00006','13');
Query OK, 1 row affected (0.09 sec)
mysql> insert into estmat(codest,codmat) values('00006','14');
Query OK, 1 row affected (0.04 sec)
mysql> insert into estmat(codest,codmat) values('00006','15');
Query OK, 1 row affected (0.06 sec)
mysql> exit
Consultas
1. Visualizar los estudiantes con sus acudientes
2. Que estudiantes no tienen acudiente asignado
3. Que acudientes no matricularon sus hijos en la institución
4. Visualizar las materias que matriculó el estudiante 00001
5. Visualizar los estudiantes con las materias que matricularon
6. Visualizar un listado de los estudiantes que no se han matriculado
7. Visualizar un listado de las materias a las que ningún estudiante se matriculó.
8. Visualizar los docentes con las materias que dictan
9. Visualizar las materias que no tienen docente asignado.
10. Visualizar que docentes no tienen materias asignadas.
11. Visualizar el estudiante con las materias que tiene matriculadas y que docentes las dicta.
Link de Consultas en TXT: CONSULTAS DE LA BD-COLEGIO.txt (42341)