MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academico | | facturacion | | information_schema | | institucion | | libreria | | mysql | | performance_schema | | phpmyadmin | | secundaria | | test | +--------------------+ 10 rows in set (0.00 sec) MariaDB [(none)]> create database institucion; ERROR 1007 (HY000): Can't create database 'institucion'; database exists MariaDB [(none)]> create database institucion1; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | academico | | facturacion | | information_schema | | institucion | | institucion1 | | libreria | | mysql | | performance_schema | | phpmyadmin | | secundaria | | test | +--------------------+ 11 rows in set (0.00 sec) MariaDB [(none)]> use institucion1; Database changed MariaDB [institucion1]> create table acudiente -> (codacu varchar(10) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(15) not null -> email varchar(12) not null); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(12) not null)' at line 6 MariaDB [institucion1]> create table acudiente -> (codacu varchar(10) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(15) not null, -> email varchar(10) not null); Query OK, 0 rows affected (0.26 sec) MariaDB [institucion1]> create table estudiante -> (codestu varchar(10) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(15) not null, -> email varchar(10) not null); Query OK, 0 rows affected (0.25 sec) MariaDB [institucion1]> create table materia -> (codmat varchar(10) not null primary key, -> nombre varchar(40) not null); Query OK, 0 rows affected (0.24 sec) MariaDB [institucion1]> create table profesor -> (codprof varchar(10) not null primary key, -> nombre varchar(50) not null); Query OK, 0 rows affected (0.23 sec) MariaDB [institucion1]> drop table profesor; Query OK, 0 rows affected (0.37 sec) MariaDB [institucion1]> create table profesor -> (codprof varchar(10) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(15) not null, -> email varchar(10) not null); Query OK, 0 rows affected (0.30 sec) MariaDB [institucion1]> create table acudiente_estudiante -> (codacu varchar(10) not null, -> codestu varchar(10) not null, -> foreign key(codacu) references acudiente(codacu) on delete cascade on update cascade, -> foreign key(codestu) references estudiante(codestu) on delete cascade on update cascade); Query OK, 0 rows affected (0.27 sec) MariaDB [institucion1]> create table estudiante_materia -> (codestu varchar(10) not null, -> (codmat varchar(10) not null, -> foreign key(codestu) references estudiante(codestu) on delete cascade on update cascade, -> foreign key(codmat) references materia(codmat) on delete cascade on update cascade); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(codmat varchar(10) not null, foreign key(codestu) references estudiante(codestu' at line 3 MariaDB [institucion1]> create table estudiante_materia -> (codestu varchar(10) not null, -> codmat varchar(10) not null, -> foreign key(codestu) references estudiante(codestu) on delete cascade on update cascade, -> foreign key(codmat) references materia(codmat) on delete cascade on update cascade); Query OK, 0 rows affected (0.29 sec) MariaDB [institucion1]> create table materia_profesor -> codmat varchar(10) not null, -> codprof varchar(10) not null, -> foreign key(codmat) references materia(codmat) on delete cascade on update cascade, -> foreign key(codprof) references profesor(codprof) on delete cascade on update cascade); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(10) not null, codprof varchar(10) not null, foreign key(codmat) referenc' at line 2 MariaDB [institucion1]> create table materia_profesor -> (codmat varchar(10) not null, -> codprof varchar(10) not null, -> foreign key(codmat) references materia(codmat) on delete cascade on update cascade, -> foreign key(codprof) references profesor(codprof) on delete cascade on update cascade); Query OK, 0 rows affected (0.26 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('001','ACEVEDO CARDONA ESTEBAN','Barrio la pradera','5846069','estebacardona@gmail.com'); Query OK, 1 row affected, 2 warnings (0.07 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('002','AGUDELO MANCO DIANA PATRICIA','Barrio rosaleda','5882104','dianapatricia@gmail.com'); Query OK, 1 row affected, 1 warning (0.04 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('003','ZPATA VALENCIA JORGE','Barrio Aragon','5841998','jorgezapata@gmail.com'); Query OK, 1 row affected, 1 warning (0.07 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('004','VELASQUEZ CANO JENNY ASTRID','Barrio la pradera','2791469','jennyvelasquez@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('005','POSADA VASCO ANA','Urbanizacion compartir','2868617','anaposada@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('006','ORTIZ PUERTA INDIRA','Urbanizaci¢n ciudadela prado ','5841497','indiraortiz@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('007','QUINTERO MENESES ADRIANA MARIA','Barrio Sangabriel','5840570','adrianaquintero@gmail.com'); Query OK, 1 row affected, 2 warnings (0.05 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('008','MONTOYA RIVERA EDILMA','Barrio la pradera','3767289','edilmamontoya@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('009','LOPERA MONSALVE FERNANDO ALONSO','Barrio el limonar 1','5709957','fernandolopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.03 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE VALUES ('010','HENAO RIOS DORA EMILSE','Barrio el limonar2','2866222','dorahenao@gmail.com'); Query OK, 1 row affected, 2 warnings (0.05 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00001','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebacardona@gmail.com'); Query OK, 1 row affected, 2 warnings (0.05 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00002','ALVAREZ AGUDELO ESTEBAN','Barrio rosaleda','5882104','estebanlavarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00003','ZAPATA CAMPI„O ISABEL','Barrio Aragon','5841998','zapataisabel@gmail.com'); Query OK, 1 row affected, 1 warning (0.05 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00004','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00005','MORENO POSADA DIEGO ALEJANDRO','Urbanizacion compartir','2868617','diegomoreno@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00006','LZATE ORTIZ JORGE MARIO','Urbanizaci¢n ciudadela prado ','5841497','marioalzae@gmail.com'); Query OK, 1 row affected, 2 warnings (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00007','ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel','5840570','josezapata@gmail.com'); Query OK, 1 row affected, 2 warnings (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00008','MNTOYA MONTOYA AEJANDRO','Barrio la pradera','3767289','alejandromontoya@gmail.com'); Query OK, 1 row affected, 2 warnings (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00009','LOPERA CARTAGENA LUISA FENANADA','Barrio el limonar 1','5709957','luisalopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00010','JARAMILLO HENAO JOSE LUIS','Barrio el limonar2','2866222','josearamillo@gmail.com'); Query OK, 1 row affected, 2 warnings (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00011','ALVAREZ AGUDELO LUNA','Barrio rosaleda','5882104','lunaalvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE VALUES ('00012','ALVAREZ AGUDELO XAVIER','Barrio rosaleda','5882104','xavieralvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.08 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('01','ESPA„OL'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('02','LECTOESRITURA'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('03','MATEMATICAS'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('04','CIENCIAS NATURALES'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('05','INVESTIGACION'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('06','FISICA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('07','FILOSOFIA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('08','EDUCACION FISICA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('09','ETICA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('10','ARTISTICA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('11','TECNOLOGIA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('12','INFORMATCA'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('13','RELIGION'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('14','SOCIALES'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA VALUES ('15','INGLES'); Query OK, 1 row affected (0.08 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('001','CIFUENTES MESA MYEIDY MARIA','','','myleidym.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.12 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('002','CUADRADO PEREZ ADRID JOSE','','','adrid.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('003','DUQUE RESTREPO ESTER LUCIA','','','esterl.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('004','GUIRALES MAURICIO','','','mauriciog.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('005','VERA DAZA MARIA ELENA','','','mariae.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('006','PALACIO TOMAS FELIPE','','','tomasf.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('007','MOSUERA OSORIO MARYETH','','','maryeth.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('008','ARBOLEDA VARGAS MARIA OFELIA','','','ofeliaa.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.02 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('009','MOSCOTE MARULANDA YANET MARIA','','','yanetm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.03 sec) MariaDB [institucion1]> INSERT INTO PROFESOR VALUES ('010','MACIAS EDGAR ALBERTO','','','edgarm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('001','00001'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('002','00002'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('003','00003'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('004','00004'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('005','00005'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('006','00006'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('007','00007'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('008','00008'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('009','00009'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('010','00010'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('001','00011'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ESTUDIANTE_ACUDIENTE VALUES ('001','00012'); ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('001','00001'); Query OK, 1 row affected (0.10 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('002','00002'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('003','00003'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('004','00004'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('005','00005'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('006','00006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('007','00007'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('008','00008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('009','00009'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('010','00010'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('001','00011'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ACUDIENTE_ESTUDIANTE VALUES ('001','00012'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','01'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','02'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','03'); Query OK, 1 row affected (0.09 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','04'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','05'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','06'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','07'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','09'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','10'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','11'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','12'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','13'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','14'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00001','15'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','01'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','02'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','03'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','04'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','05'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','06'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','07'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','09'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','10'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','11'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','12'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','13'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','14'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00002','15'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','01'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','02'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','03'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','04'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','05'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','06'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','07'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','09'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','10'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','11'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','12'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','13'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','14'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00003','15'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','01'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','02'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','03'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','04'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','05'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','06'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','07'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','09'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','10'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','11'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','12'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','13'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','14'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00004','15'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','01'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','02'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','03'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','04'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','05'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','06'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','07'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','09'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','10'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','11'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','12'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','13'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','14'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00005','15'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','01'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','02'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','03'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','04'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','05'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','06'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','07'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','08'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','09'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','10'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','11'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','12'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','13'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','14'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTUDIANTE_MATERIA VALUES ('00006','15'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('01','005'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('02','007'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('03','009'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('05','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('06','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('07','001'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('08','010'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('09','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('10','004'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('11','002'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('13','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('14','007'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO MATERIA_PROFESOR VALUES ('15','008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> MariaDB [institucion1]> MariaDB [institucion1]> describe acudiente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codacu | varchar(10) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | | direccion | varchar(15) | NO | | NULL | | | telefono | varchar(15) | NO | | NULL | | | email | varchar(10) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.03 sec) MariaDB [institucion1]> select * from acudiente; +--------+---------------------------------+-----------------+----------+------------+ | codacu | nombre | direccion | telefono | email | +--------+---------------------------------+-----------------+----------+------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la prade | 5846069 | estebacard | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatri | | 003 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapat | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la prade | 2791469 | jennyvelas | | 005 | POSADA VASCO ANA | Urbanizacion co | 2868617 | anaposada@ | | 006 | ORTIZ PUERTA INDIRA | Urbanizaci¢n ci | 5841497 | indiraorti | | 007 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabri | 5840570 | adrianaqui | | 008 | MONTOYA RIVERA EDILMA | Barrio la prade | 3767289 | edilmamont | | 009 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limon | 5709957 | fernandolo | | 010 | HENAO RIOS DORA EMILSE | Barrio el limon | 2866222 | dorahenao@ | +--------+---------------------------------+-----------------+----------+------------+ 10 rows in set (0.00 sec) MariaDB [institucion1]> select * from estudiante; +---------+---------------------------------+-----------------+----------+------------+ | codestu | nombre | direccion | telefono | email | +---------+---------------------------------+-----------------+----------+------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la prade | 5846069 | juanesteba | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlav | | 00003 | ZAPATA CAMPI„O ISABEL | Barrio Aragon | 5841998 | zapataisab | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la prade | 2791469 | sofiavelas | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion co | 2868617 | diegomoren | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci¢n ci | 5841497 | marioalzae | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabri | 5840570 | josezapata | | 00008 | MNTOYA MONTOYA AEJANDRO | Barrio la prade | 3767289 | alejandrom | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limon | 5709957 | luisaloper | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limon | 2866222 | josearamil | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvare | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralva | +---------+---------------------------------+-----------------+----------+------------+ 12 rows in set (0.00 sec) MariaDB [institucion1]> select * from materia; +--------+--------------------+ | codmat | nombre | +--------+--------------------+ | 01 | ESPA„OL | | 02 | LECTOESRITURA | | 03 | MATEMATICAS | | 04 | CIENCIAS NATURALES | | 05 | INVESTIGACION | | 06 | FISICA | | 07 | FILOSOFIA | | 08 | EDUCACION FISICA | | 09 | ETICA | | 10 | ARTISTICA | | 11 | TECNOLOGIA | | 12 | INFORMATCA | | 13 | RELIGION | | 14 | SOCIALES | | 15 | INGLES | +--------+--------------------+ 15 rows in set (0.00 sec) MariaDB [institucion1]> select * from profesor; +---------+-------------------------------+-----------+----------+------------+ | codprof | nombre | direccion | telefono | email | +---------+-------------------------------+-----------+----------+------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | | | myleidym.i | | 002 | CUADRADO PEREZ ADRID JOSE | | | adrid.iear | | 003 | DUQUE RESTREPO ESTER LUCIA | | | esterl.iea | | 004 | GUIRALES MAURICIO | | | mauriciog. | | 005 | VERA DAZA MARIA ELENA | | | mariae.iea | | 006 | PALACIO TOMAS FELIPE | | | tomasf.iea | | 007 | MOSUERA OSORIO MARYETH | | | maryeth.ie | | 008 | ARBOLEDA VARGAS MARIA OFELIA | | | ofeliaa.ie | | 009 | MOSCOTE MARULANDA YANET MARIA | | | yanetm.iea | | 010 | MACIAS EDGAR ALBERTO | | | edgarm.iea | +---------+-------------------------------+-----------+----------+------------+ 10 rows in set (0.00 sec) MariaDB [institucion1]> create table estmatprof -> (codestu varchar(10) not null, -> codmat varchar(10) not null, -> codprof varchar(10) not null, -> foreign key(codestu) references estudiante(codestu) on delete cascade on update cascade, -> foreign key(codmat) references materia(codmat) on delete cascade on update cascade, -> foreign key(codprof) references profesor(codprof) on delete cascade on update cascade); Query OK, 0 rows affected (0.34 sec) MariaDB [institucion1]> describe estmatprof; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | codestu | varchar(10) | NO | MUL | NULL | | | codmat | varchar(10) | NO | MUL | NULL | | | codprof | varchar(10) | NO | MUL | NULL | | +---------+-------------+------+-----+---------+-------+ 3 rows in set (0.07 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','01','005'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','03','009'); Query OK, 1 row affected (0.07 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','05','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','06','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','07','001'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','08','010'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','09','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','10','004'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','11','002'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','13','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','14','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00001','15','008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','01','005'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','03','009'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','05','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','06','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','07','001'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','08','010'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','09','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','10','004'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','11','002'); Query OK, 1 row affected (0.08 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','13','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','14','007'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00002','15','008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','01','005'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','03','009'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','05','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','06','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','07','001'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','08','010'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','09','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','10','004'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','11','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','13','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','14','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00003','15','008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','01','005'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','03','009'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','05','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','06','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','07','001'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','08','010'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','09','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','10','004'); Query OK, 1 row affected (0.08 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','11','002'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','13','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','14','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00004','15','008'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','01','005'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','03','009'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','05','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','06','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','07','001'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','08','010'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','09','006'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','10','004'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','11','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','12','002'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','13','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','14','007'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00005','15','008'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','01','005'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','02','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','03','009'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','04','003'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','05','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','06','003'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','07','001'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','08','010'); Query OK, 1 row affected (0.05 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','09','006'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','10','004'); Query OK, 1 row affected (0.04 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','11','002'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','12','002'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','13','006'); Query OK, 1 row affected (0.03 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','14','007'); Query OK, 1 row affected (0.02 sec) MariaDB [institucion1]> INSERT INTO ESTMATPROF VALUES ('00006','15','008'); Query OK, 1 row affected (0.06 sec) MariaDB [institucion1]> select * from estmatprof; +---------+--------+---------+ | codestu | codmat | codprof | +---------+--------+---------+ | 00001 | 01 | 005 | | 00001 | 02 | 007 | | 00001 | 03 | 009 | | 00001 | 04 | 003 | | 00001 | 05 | 003 | | 00001 | 06 | 003 | | 00001 | 07 | 001 | | 00001 | 08 | 010 | | 00001 | 09 | 006 | | 00001 | 10 | 004 | | 00001 | 11 | 002 | | 00001 | 12 | 002 | | 00001 | 13 | 006 | | 00001 | 14 | 007 | | 00001 | 15 | 008 | | 00002 | 01 | 005 | | 00002 | 02 | 007 | | 00002 | 03 | 009 | | 00002 | 04 | 003 | | 00002 | 05 | 003 | | 00002 | 06 | 003 | | 00002 | 07 | 001 | | 00002 | 08 | 010 | | 00002 | 09 | 006 | | 00002 | 10 | 004 | | 00002 | 11 | 002 | | 00002 | 12 | 002 | | 00002 | 13 | 006 | | 00002 | 14 | 007 | | 00002 | 15 | 008 | | 00003 | 01 | 005 | | 00003 | 02 | 007 | | 00003 | 03 | 009 | | 00003 | 04 | 003 | | 00003 | 05 | 003 | | 00003 | 06 | 003 | | 00003 | 07 | 001 | | 00003 | 08 | 010 | | 00003 | 09 | 006 | | 00003 | 10 | 004 | | 00003 | 11 | 002 | | 00003 | 12 | 002 | | 00003 | 13 | 006 | | 00003 | 14 | 007 | | 00003 | 15 | 008 | | 00004 | 01 | 005 | | 00004 | 02 | 007 | | 00004 | 03 | 009 | | 00004 | 04 | 003 | | 00004 | 05 | 003 | | 00004 | 06 | 003 | | 00004 | 07 | 001 | | 00004 | 08 | 010 | | 00004 | 09 | 006 | | 00004 | 10 | 004 | | 00004 | 11 | 002 | | 00004 | 12 | 002 | | 00004 | 13 | 006 | | 00004 | 14 | 007 | | 00004 | 15 | 008 | | 00005 | 01 | 005 | | 00005 | 02 | 007 | | 00005 | 03 | 009 | | 00005 | 04 | 003 | | 00005 | 05 | 003 | | 00005 | 06 | 003 | | 00005 | 07 | 001 | | 00005 | 08 | 010 | | 00005 | 09 | 006 | | 00005 | 10 | 004 | | 00005 | 11 | 002 | | 00005 | 12 | 002 | | 00005 | 13 | 006 | | 00005 | 14 | 007 | | 00005 | 15 | 008 | | 00006 | 01 | 005 | | 00006 | 02 | 007 | | 00006 | 03 | 009 | | 00006 | 04 | 003 | | 00006 | 05 | 003 | | 00006 | 06 | 003 | | 00006 | 07 | 001 | | 00006 | 08 | 010 | | 00006 | 09 | 006 | | 00006 | 10 | 004 | | 00006 | 11 | 002 | | 00006 | 12 | 002 | | 00006 | 13 | 006 | | 00006 | 14 | 007 | | 00006 | 15 | 008 | +---------+--------+---------+ 90 rows in set (0.00 sec) MariaDB [institucion1]> select estudiante.codestu 'Cod. Estudiante' , estudiante.nombre 'Nombre Estudiante', acudiente.codacu 'Cod. Acudiente' , acudiente.nombre 'Nombre Acudiente' from estudiante, acudiente, estudiante_acudiente where estudiante.codestu = estudiante_acudiente.codestu and estudiante_acudiente.codacu = acudiente.codacu; ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> select estudiante.codestu 'Cod. Estudiante' , estudiante.nombre 'Nombre Estudiante', acudiente.codacu 'Cod. Acudiente' , acudiente.nombre 'Nombre Acudiente' from estudiante, acudiente, estudiante_acudiente where estudiante.codestu = estudiante_acudiente.codestu and estudiante_acudiente.codacu = acudiente.codacu; ERROR 1146 (42S02): Table 'institucion1.estudiante_acudiente' doesn't exist MariaDB [institucion1]> select estudiante.codestu 'Cod. Estudiante' , estudiante.nombre 'Nombre Estudiante', acudiente.codacu 'Cod. Acudiente' , acudiente.nombre 'Nombre Acudiente' from estudiante, acudiente,acudiente_estudiante where estudiante.codestu = acudiente_estudiante.codestu and acudiente_estudiante.codacu = acudiente.codacu; +-----------------+---------------------------------+----------------+---------------------------------+ | Cod. Estudiante | Nombre Estudiante | Cod. Acudiente | Nombre Acudiente | +-----------------+---------------------------------+----------------+---------------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 001 | ACEVEDO CARDONA ESTEBAN | | 00002 | ALVAREZ AGUDELO ESTEBAN | 002 | AGUDELO MANCO DIANA PATRICIA | | 00003 | ZAPATA CAMPI„O ISABEL | 003 | ZPATA VALENCIA JORGE | | 00004 | VALLE VELASQUEZ SOFIA | 004 | VELASQUEZ CANO JENNY ASTRID | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 005 | POSADA VASCO ANA | | 00006 | LZATE ORTIZ JORGE MARIO | 006 | ORTIZ PUERTA INDIRA | | 00007 | ZAPATA QUINTERO JOSE MARIA | 007 | QUINTERO MENESES ADRIANA MARIA | | 00008 | MNTOYA MONTOYA AEJANDRO | 008 | MONTOYA RIVERA EDILMA | | 00009 | LOPERA CARTAGENA LUISA FENANADA | 009 | LOPERA MONSALVE FERNANDO ALONSO | | 00010 | JARAMILLO HENAO JOSE LUIS | 010 | HENAO RIOS DORA EMILSE | | 00011 | ALVAREZ AGUDELO LUNA | 001 | ACEVEDO CARDONA ESTEBAN | | 00012 | ALVAREZ AGUDELO XAVIER | 001 | ACEVEDO CARDONA ESTEBAN | +-----------------+---------------------------------+----------------+---------------------------------+ 12 rows in set (0.07 sec) MariaDB [institucion1]> select estudiante.codestu'Cod. Estudiante', estudiante.nombre 'Nombre Estudiante' from estudiante left join acudiente_estudiante on acudiente_estudiante.codestu=estudiante.codestu where acudiente_estudiante.codestu is null; Empty set (0.01 sec) MariaDB [institucion1]> select acudiente.codacu'Cod. Acudiente', acudiente.nombre 'Nombre Acudiente' from acudiente left join acudiente_estudiante on acudiente_estudiante.codacu=acudiente.codacu where acudiente_estudiante.codacu is null; Empty set (0.04 sec) MariaDB [institucion1]> select materia.codmat 'Cod. Materia', materia.nombre 'Nombre materia' from estudiante, materia, estudiante_materia where estudiante.codestu = '00001' and estudiante.codestu = estudiante_materia.codestu and estudiante_materia.codmat=materia.codmat; +--------------+--------------------+ | Cod. Materia | Nombre materia | +--------------+--------------------+ | 01 | ESPA„OL | | 02 | LECTOESRITURA | | 03 | MATEMATICAS | | 04 | CIENCIAS NATURALES | | 05 | INVESTIGACION | | 06 | FISICA | | 07 | FILOSOFIA | | 08 | EDUCACION FISICA | | 09 | ETICA | | 10 | ARTISTICA | | 11 | TECNOLOGIA | | 12 | INFORMATCA | | 13 | RELIGION | | 14 | SOCIALES | | 15 | INGLES | +--------------+--------------------+ 15 rows in set (0.00 sec) MariaDB [institucion1]> select estudiante.codestu 'Cod. Estudiante' , estudiante.nombre 'Nom. Estudiante', materia.codmat 'Cod. Materia' , materia.nombre 'Nom. Materia' from estudiante, materia, estudiante_materia where estudiante.codestu = estudiante_materia.codestu and estudiante_materia.codmat = materia.codmat; +-----------------+-------------------------------+--------------+--------------------+ | Cod. Estudiante | Nom. Estudiante | Cod. Materia | Nom. Materia | +-----------------+-------------------------------+--------------+--------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 01 | ESPA„OL | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 02 | LECTOESRITURA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 03 | MATEMATICAS | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 04 | CIENCIAS NATURALES | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 05 | INVESTIGACION | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 06 | FISICA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 07 | FILOSOFIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 08 | EDUCACION FISICA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 09 | ETICA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 10 | ARTISTICA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 11 | TECNOLOGIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 12 | INFORMATCA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 13 | RELIGION | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 14 | SOCIALES | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 15 | INGLES | | 00002 | ALVAREZ AGUDELO ESTEBAN | 01 | ESPA„OL | | 00002 | ALVAREZ AGUDELO ESTEBAN | 02 | LECTOESRITURA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 03 | MATEMATICAS | | 00002 | ALVAREZ AGUDELO ESTEBAN | 04 | CIENCIAS NATURALES | | 00002 | ALVAREZ AGUDELO ESTEBAN | 05 | INVESTIGACION | | 00002 | ALVAREZ AGUDELO ESTEBAN | 06 | FISICA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 07 | FILOSOFIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 08 | EDUCACION FISICA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 09 | ETICA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 10 | ARTISTICA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 11 | TECNOLOGIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 12 | INFORMATCA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 13 | RELIGION | | 00002 | ALVAREZ AGUDELO ESTEBAN | 14 | SOCIALES | | 00002 | ALVAREZ AGUDELO ESTEBAN | 15 | INGLES | | 00003 | ZAPATA CAMPI„O ISABEL | 01 | ESPA„OL | | 00003 | ZAPATA CAMPI„O ISABEL | 02 | LECTOESRITURA | | 00003 | ZAPATA CAMPI„O ISABEL | 03 | MATEMATICAS | | 00003 | ZAPATA CAMPI„O ISABEL | 04 | CIENCIAS NATURALES | | 00003 | ZAPATA CAMPI„O ISABEL | 05 | INVESTIGACION | | 00003 | ZAPATA CAMPI„O ISABEL | 06 | FISICA | | 00003 | ZAPATA CAMPI„O ISABEL | 07 | FILOSOFIA | | 00003 | ZAPATA CAMPI„O ISABEL | 08 | EDUCACION FISICA | | 00003 | ZAPATA CAMPI„O ISABEL | 09 | ETICA | | 00003 | ZAPATA CAMPI„O ISABEL | 10 | ARTISTICA | | 00003 | ZAPATA CAMPI„O ISABEL | 11 | TECNOLOGIA | | 00003 | ZAPATA CAMPI„O ISABEL | 12 | INFORMATCA | | 00003 | ZAPATA CAMPI„O ISABEL | 13 | RELIGION | | 00003 | ZAPATA CAMPI„O ISABEL | 14 | SOCIALES | | 00003 | ZAPATA CAMPI„O ISABEL | 15 | INGLES | | 00004 | VALLE VELASQUEZ SOFIA | 01 | ESPA„OL | | 00004 | VALLE VELASQUEZ SOFIA | 02 | LECTOESRITURA | | 00004 | VALLE VELASQUEZ SOFIA | 03 | MATEMATICAS | | 00004 | VALLE VELASQUEZ SOFIA | 04 | CIENCIAS NATURALES | | 00004 | VALLE VELASQUEZ SOFIA | 05 | INVESTIGACION | | 00004 | VALLE VELASQUEZ SOFIA | 06 | FISICA | | 00004 | VALLE VELASQUEZ SOFIA | 07 | FILOSOFIA | | 00004 | VALLE VELASQUEZ SOFIA | 08 | EDUCACION FISICA | | 00004 | VALLE VELASQUEZ SOFIA | 09 | ETICA | | 00004 | VALLE VELASQUEZ SOFIA | 10 | ARTISTICA | | 00004 | VALLE VELASQUEZ SOFIA | 11 | TECNOLOGIA | | 00004 | VALLE VELASQUEZ SOFIA | 12 | INFORMATCA | | 00004 | VALLE VELASQUEZ SOFIA | 13 | RELIGION | | 00004 | VALLE VELASQUEZ SOFIA | 14 | SOCIALES | | 00004 | VALLE VELASQUEZ SOFIA | 15 | INGLES | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 01 | ESPA„OL | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 02 | LECTOESRITURA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 03 | MATEMATICAS | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 04 | CIENCIAS NATURALES | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 05 | INVESTIGACION | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 06 | FISICA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 07 | FILOSOFIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 08 | EDUCACION FISICA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 09 | ETICA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 10 | ARTISTICA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 11 | TECNOLOGIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 12 | INFORMATCA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 13 | RELIGION | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 14 | SOCIALES | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 15 | INGLES | | 00006 | LZATE ORTIZ JORGE MARIO | 01 | ESPA„OL | | 00006 | LZATE ORTIZ JORGE MARIO | 02 | LECTOESRITURA | | 00006 | LZATE ORTIZ JORGE MARIO | 03 | MATEMATICAS | | 00006 | LZATE ORTIZ JORGE MARIO | 04 | CIENCIAS NATURALES | | 00006 | LZATE ORTIZ JORGE MARIO | 05 | INVESTIGACION | | 00006 | LZATE ORTIZ JORGE MARIO | 06 | FISICA | | 00006 | LZATE ORTIZ JORGE MARIO | 07 | FILOSOFIA | | 00006 | LZATE ORTIZ JORGE MARIO | 08 | EDUCACION FISICA | | 00006 | LZATE ORTIZ JORGE MARIO | 09 | ETICA | | 00006 | LZATE ORTIZ JORGE MARIO | 10 | ARTISTICA | | 00006 | LZATE ORTIZ JORGE MARIO | 11 | TECNOLOGIA | | 00006 | LZATE ORTIZ JORGE MARIO | 12 | INFORMATCA | | 00006 | LZATE ORTIZ JORGE MARIO | 13 | RELIGION | | 00006 | LZATE ORTIZ JORGE MARIO | 14 | SOCIALES | | 00006 | LZATE ORTIZ JORGE MARIO | 15 | INGLES | +-----------------+-------------------------------+--------------+--------------------+ 90 rows in set (0.00 sec) MariaDB [institucion1]> select estudiante.codestu'Cod. Estudiante', estudiante.nombre 'Nombre Estudiante' from estudiante left join estudiante_materia on estudiante_materia.codestu=estudiante.codestu where estudiante_materia.codestu is null; +-----------------+---------------------------------+ | Cod. Estudiante | Nombre Estudiante | +-----------------+---------------------------------+ | 00007 | ZAPATA QUINTERO JOSE MARIA | | 00008 | MNTOYA MONTOYA AEJANDRO | | 00009 | LOPERA CARTAGENA LUISA FENANADA | | 00010 | JARAMILLO HENAO JOSE LUIS | | 00011 | ALVAREZ AGUDELO LUNA | | 00012 | ALVAREZ AGUDELO XAVIER | +-----------------+---------------------------------+ 6 rows in set (0.00 sec) MariaDB [institucion1]> select materia.codmat'Cod. Materia', materia.nombre'Nombre Materia' from materia left join estudiante_materia on estudiante_materia.codmat=materia.codmat where estudiante_materia.codmat is null; Empty set (0.00 sec) MariaDB [institucion1]> select profesor.codprof'Cod. Profesor', profesor.nombre'Nombre profesor', materia.codmat'Cod. Materia', materia.nombre'Nombre Materia' from profesor, materia, materia_profesor where profesor.codprof=materia_profesor.codprof and materia.codmat=materia_profesor.codmat; +---------------+-------------------------------+--------------+--------------------+ | Cod. Profesor | Nombre profesor | Cod. Materia | Nombre Materia | +---------------+-------------------------------+--------------+--------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | 07 | FILOSOFIA | | 002 | CUADRADO PEREZ ADRID JOSE | 11 | TECNOLOGIA | | 002 | CUADRADO PEREZ ADRID JOSE | 12 | INFORMATCA | | 003 | DUQUE RESTREPO ESTER LUCIA | 04 | CIENCIAS NATURALES | | 003 | DUQUE RESTREPO ESTER LUCIA | 05 | INVESTIGACION | | 003 | DUQUE RESTREPO ESTER LUCIA | 06 | FISICA | | 004 | GUIRALES MAURICIO | 10 | ARTISTICA | | 005 | VERA DAZA MARIA ELENA | 01 | ESPA„OL | | 006 | PALACIO TOMAS FELIPE | 09 | ETICA | | 006 | PALACIO TOMAS FELIPE | 13 | RELIGION | | 007 | MOSUERA OSORIO MARYETH | 02 | LECTOESRITURA | | 007 | MOSUERA OSORIO MARYETH | 14 | SOCIALES | | 008 | ARBOLEDA VARGAS MARIA OFELIA | 15 | INGLES | | 009 | MOSCOTE MARULANDA YANET MARIA | 03 | MATEMATICAS | | 010 | MACIAS EDGAR ALBERTO | 08 | EDUCACION FISICA | +---------------+-------------------------------+--------------+--------------------+ 15 rows in set (0.00 sec) MariaDB [institucion1]> select materia.codmat'Cod. Materia', materia.nombre'Nombre Materia' from materia left join materia_profesor on materia_profesor.codmat=materia.codmat where materia_profesor.codmat is null; Empty set (0.00 sec) MariaDB [institucion1]> select profesor.codprof'Cod. Profesor', profesor.nombre'Nombre Profesor' from profesor left join materia_profesor on materia_profesor.codprof=profesor.codprof where materia_profesor.codprof is null; Empty set (0.00 sec) MariaDB [institucion1]> select distinct estudiante.codestu'Cod. Estudiante', estudiante.nombre'Nombre Estudiante',materia.codmat'Cod. Materia',materia.nombre'Nombre Materia', profesor.codprof'Cod. Profesor',profesor.nombre'Nombre Profesor' from estudiante,materia,profesor,estmatprof where estudiante.codestu=estmatprof.codestu and estmatprof.codmat=materia.codmat and profesor.codprof=estmatprof.codprof; +-----------------+-------------------------------+--------------+--------------------+---------------+-------------------------------+ | Cod. Estudiante | Nombre Estudiante | Cod. Materia | Nombre Materia | Cod. Profesor | Nombre Profesor | +-----------------+-------------------------------+--------------+--------------------+---------------+-------------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00003 | ZAPATA CAMPI„O ISABEL | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00004 | VALLE VELASQUEZ SOFIA | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00006 | LZATE ORTIZ JORGE MARIO | 07 | FILOSOFIA | 001 | CIFUENTES MESA MYEIDY MARIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00002 | ALVAREZ AGUDELO ESTEBAN | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00002 | ALVAREZ AGUDELO ESTEBAN | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00003 | ZAPATA CAMPI„O ISABEL | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00003 | ZAPATA CAMPI„O ISABEL | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00004 | VALLE VELASQUEZ SOFIA | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00004 | VALLE VELASQUEZ SOFIA | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00006 | LZATE ORTIZ JORGE MARIO | 11 | TECNOLOGIA | 002 | CUADRADO PEREZ ADRID JOSE | | 00006 | LZATE ORTIZ JORGE MARIO | 12 | INFORMATCA | 002 | CUADRADO PEREZ ADRID JOSE | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00003 | ZAPATA CAMPI„O ISABEL | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00003 | ZAPATA CAMPI„O ISABEL | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00003 | ZAPATA CAMPI„O ISABEL | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00004 | VALLE VELASQUEZ SOFIA | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00004 | VALLE VELASQUEZ SOFIA | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00004 | VALLE VELASQUEZ SOFIA | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00006 | LZATE ORTIZ JORGE MARIO | 04 | CIENCIAS NATURALES | 003 | DUQUE RESTREPO ESTER LUCIA | | 00006 | LZATE ORTIZ JORGE MARIO | 05 | INVESTIGACION | 003 | DUQUE RESTREPO ESTER LUCIA | | 00006 | LZATE ORTIZ JORGE MARIO | 06 | FISICA | 003 | DUQUE RESTREPO ESTER LUCIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00002 | ALVAREZ AGUDELO ESTEBAN | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00003 | ZAPATA CAMPI„O ISABEL | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00004 | VALLE VELASQUEZ SOFIA | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00006 | LZATE ORTIZ JORGE MARIO | 10 | ARTISTICA | 004 | GUIRALES MAURICIO | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00003 | ZAPATA CAMPI„O ISABEL | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00004 | VALLE VELASQUEZ SOFIA | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00006 | LZATE ORTIZ JORGE MARIO | 01 | ESPA„OL | 005 | VERA DAZA MARIA ELENA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00002 | ALVAREZ AGUDELO ESTEBAN | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00002 | ALVAREZ AGUDELO ESTEBAN | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00003 | ZAPATA CAMPI„O ISABEL | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00003 | ZAPATA CAMPI„O ISABEL | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00004 | VALLE VELASQUEZ SOFIA | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00004 | VALLE VELASQUEZ SOFIA | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00006 | LZATE ORTIZ JORGE MARIO | 09 | ETICA | 006 | PALACIO TOMAS FELIPE | | 00006 | LZATE ORTIZ JORGE MARIO | 13 | RELIGION | 006 | PALACIO TOMAS FELIPE | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00002 | ALVAREZ AGUDELO ESTEBAN | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00002 | ALVAREZ AGUDELO ESTEBAN | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00003 | ZAPATA CAMPI„O ISABEL | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00003 | ZAPATA CAMPI„O ISABEL | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00004 | VALLE VELASQUEZ SOFIA | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00004 | VALLE VELASQUEZ SOFIA | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00006 | LZATE ORTIZ JORGE MARIO | 02 | LECTOESRITURA | 007 | MOSUERA OSORIO MARYETH | | 00006 | LZATE ORTIZ JORGE MARIO | 14 | SOCIALES | 007 | MOSUERA OSORIO MARYETH | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00003 | ZAPATA CAMPI„O ISABEL | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00004 | VALLE VELASQUEZ SOFIA | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00006 | LZATE ORTIZ JORGE MARIO | 15 | INGLES | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00002 | ALVAREZ AGUDELO ESTEBAN | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00003 | ZAPATA CAMPI„O ISABEL | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00004 | VALLE VELASQUEZ SOFIA | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00006 | LZATE ORTIZ JORGE MARIO | 03 | MATEMATICAS | 009 | MOSCOTE MARULANDA YANET MARIA | | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | | 00002 | ALVAREZ AGUDELO ESTEBAN | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | | 00003 | ZAPATA CAMPI„O ISABEL | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | | 00004 | VALLE VELASQUEZ SOFIA | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | | 00005 | MORENO POSADA DIEGO ALEJANDRO | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | | 00006 | LZATE ORTIZ JORGE MARIO | 08 | EDUCACION FISICA | 010 | MACIAS EDGAR ALBERTO | +-----------------+-------------------------------+--------------+--------------------+---------------+-------------------------------+ 90 rows in set (0.04 sec) MariaDB [institucion1]> MariaDB [institucion1]> exit