Microsoft Windows [Versión 10.0.19044.2006] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\Harold Martinez>cd/xampp/mysql/bin C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.4.24-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> source "C:\Users\Harold Martinez\OneDrive\UNIVERSIDAD\4 CUARTO SEMESTRE\2 BASE DE DATOS\Actividad 2\BDMatricula.sql" ERROR: Failed to open file '"C:\Users\Harold Martinez\OneDrive\UNIVERSIDAD\4 CUARTO SEMESTRE\2 BASE DE DATOS\Actividad 2\BDMatricula.sql"', error: 13 MariaDB [(none)]> source D:\Descargas\BDMatricula.sql Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.001 sec) Database changed Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.010 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.001 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.010 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.001 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.010 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 12 rows affected (0.003 sec) Records: 12 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.008 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 12 rows affected (0.002 sec) Records: 12 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.011 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.002 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 90 rows affected (0.004 sec) Records: 90 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.009 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 15 rows affected (0.001 sec) Records: 15 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [BDMatricula]> show tables; +-----------------------+ | Tables_in_bdmatricula | +-----------------------+ | acudiente | | docente | | estuacu | | estudiante | | estudocemate | | materia | +-----------------------+ 6 rows in set (0.001 sec) MariaDB [BDMatricula]> select * from acudiente; +--------------+---------------------------------+-----------------+----------+----------------------+ | codacudiente | nombre | direccion | telefono | email | +--------------+---------------------------------+-----------------+----------+----------------------+ | A01 | ACEVEDO CARDONA ESTEBAN | Barrio la prade | 5846069 | estebacardona@gmail. | | A02 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail. | | A03 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.co | | A04 | VELASQUEZ CANO JENNY ASTRID | Barrio la prade | 2791469 | jennyvelasquez@gmail | | A05 | POSADA VASCO ANA | Urbanizacion co | 2791469 | jennyvelasquez@gmail | | A06 | ORTIZ PUERTA INDIRA | Urbanización ci | 5841497 | indiraortiz@gmail.co | | A07 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabri | 5840570 | adrianaquintero@gmai | | A08 | MONTOYA RIVERA EDILMA | Barrio la prade | 3767289 | edilmamontoya@gmail. | | A09 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limon | 5709957 | fernandolopera@gmail | | A10 | HENAO RIOS DORA EMILSE | Barrio el limon | 2866222 | dorahenao@gmail.com | +--------------+---------------------------------+-----------------+----------+----------------------+ 10 rows in set (0.003 sec) MariaDB [BDMatricula]> select * from estudiante; +---------------+---------------------------------+-----------------+----------+----------------------+ | codestudiante | nombre | direccion | telefono | email | +---------------+---------------------------------+-----------------+----------+----------------------+ | E01 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la prade | 5846069 | juanestebacardona@gm | | E02 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail | | E03 | ZAPATA CAMPIÑO ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.c | | E04 | VALLE VELASQUEZ SOFIA | Barrio la prade | 2791469 | sofiavelasquez@gmail | | E05 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion co | 2868617 | diegomoreno@gmail.co | | E06 | LZATE ORTIZ JORGE MARIO | Urbanización ci | 5841497 | marioalzae@gmail.com | | E07 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabri | 5840570 | josezapata@gmail.com | | E08 | MNTOYA MONTOYA AEJANDRO | Barrio la prade | 3767289 | alejandromontoya@gma | | E09 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limon | 5709957 | luisalopera@gmail.co | | E10 | JARAMILLO HENAO JOSE LUIS | Barrio el limon | 2866222 | josearamillo@gmail.c | | E11 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.co | | E12 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail. | +---------------+---------------------------------+-----------------+----------+----------------------+ 12 rows in set (0.003 sec) MariaDB [BDMatricula]> select acudiente.codacudiente, acudiente.nombre, estudiante.codestudiante, estudiante.nombre from acudiente inner join estuacu on acudiente.codacudiente=estuacu.codacudiente inner join estudiante on estuacu.codestudiante= estudiante.codestudiante; +--------------+---------------------------------+---------------+---------------------------------+ | codacudiente | nombre | codestudiante | nombre | +--------------+---------------------------------+---------------+---------------------------------+ | A01 | ACEVEDO CARDONA ESTEBAN | E01 | ACEVEDO BURITICA JUAN ESTEBAN | | A02 | AGUDELO MANCO DIANA PATRICIA | E02 | ALVAREZ AGUDELO ESTEBAN | | A03 | ZPATA VALENCIA JORGE | E03 | ZAPATA CAMPIÑO ISABEL | | A04 | VELASQUEZ CANO JENNY ASTRID | E04 | VALLE VELASQUEZ SOFIA | | A05 | POSADA VASCO ANA | E05 | MORENO POSADA DIEGO ALEJANDRO | | A06 | ORTIZ PUERTA INDIRA | E06 | LZATE ORTIZ JORGE MARIO | | A07 | QUINTERO MENESES ADRIANA MARIA | E07 | ZAPATA QUINTERO JOSE MARIA | | A08 | MONTOYA RIVERA EDILMA | E08 | MNTOYA MONTOYA AEJANDRO | | A09 | LOPERA MONSALVE FERNANDO ALONSO | E09 | LOPERA CARTAGENA LUISA FENANADA | | A10 | HENAO RIOS DORA EMILSE | E10 | JARAMILLO HENAO JOSE LUIS | | A01 | ACEVEDO CARDONA ESTEBAN | E11 | ALVAREZ AGUDELO LUNA | | A01 | ACEVEDO CARDONA ESTEBAN | E12 | ALVAREZ AGUDELO XAVIER | +--------------+---------------------------------+---------------+---------------------------------+ 12 rows in set (0.001 sec) MariaDB [BDMatricula]> select estudiante.codestudiante, estudiante.nombre, estuacu.codestudiante from estudiante left join estuacu on estudiante.codestudiante=estuacu.codestudiante where estuacu.codestudiante is null; Empty set (0.001 sec) MariaDB [BDMatricula]> select * from estuacu; +---------------+--------------+ | codestudiante | codacudiente | +---------------+--------------+ | E01 | A01 | | E02 | A02 | | E03 | A03 | | E04 | A04 | | E05 | A05 | | E06 | A06 | | E07 | A07 | | E08 | A08 | | E09 | A09 | | E10 | A10 | | E11 | A01 | | E12 | A01 | +---------------+--------------+ 12 rows in set (0.001 sec) MariaDB [BDMatricula]> select acudiente.codacudiente, acudiente.nombre, estuacu.codacudiente from acudiente left join estuacu on acudiente.codacudiente=estuacu.codacudiente where estuacu.codacudiente is null; Empty set (0.001 sec) MariaDB [BDMatricula]> select estudiante.codestudiante, estudiante.nombre, materia.codmateria, materia.nombre from estudiante right join estudocemate on estudiante.codestudiante=estudocemate.codestudiante right join materia on estudocemate.codmateria=materia.codmateria where estudocemate.codestudiante = ‘E01’; +---------------+-------------------------------+------------+-----------------+ | codestudiante | nombre | codmateria | nombre | +---------------+-------------------------------+------------+-----------------+ | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M01 | ESPAÑOL | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M04 | MATEMATICAS | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M05 | INVESTIGACION | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M06 | FISICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M07 | FILOSOFIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M08 | EDUCACION FISIC | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M09 | ETICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M10 | ARTISTICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M11 | TECNOLOGIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M12 | INFORMATICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M13 | RELIGION | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M14 | SOCIALES | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M15 | INGLES | +---------------+-------------------------------+------------+-----------------+ 15 rows in set (0.002 sec) MariaDB [BDMatricula]> select estudiante.codestudiante, estudiante.nombre, materia.codmateria, materia.nombre from estudiante right join estudocemate on estudiante.codestudiante=estudocemate.codestudiante right join materia on estudocemate.codmateria=materia.codmateria; +---------------+-------------------------------+------------+-----------------+ | codestudiante | nombre | codmateria | nombre | +---------------+-------------------------------+------------+-----------------+ | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M01 | ESPAÑOL | | E02 | ALVAREZ AGUDELO ESTEBAN | M01 | ESPAÑOL | | E03 | ZAPATA CAMPIÑO ISABEL | M01 | ESPAÑOL | | E04 | VALLE VELASQUEZ SOFIA | M01 | ESPAÑOL | | E05 | MORENO POSADA DIEGO ALEJANDRO | M01 | ESPAÑOL | | E06 | LZATE ORTIZ JORGE MARIO | M01 | ESPAÑOL | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | | E02 | ALVAREZ AGUDELO ESTEBAN | M02 | LECTOESCRITURA | | E03 | ZAPATA CAMPIÑO ISABEL | M02 | LECTOESCRITURA | | E04 | VALLE VELASQUEZ SOFIA | M02 | LECTOESCRITURA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M02 | LECTOESCRITURA | | E06 | LZATE ORTIZ JORGE MARIO | M02 | LECTOESCRITURA | | E02 | ALVAREZ AGUDELO ESTEBAN | M03 | CIENCIAS NATURA | | E03 | ZAPATA CAMPIÑO ISABEL | M03 | CIENCIAS NATURA | | E04 | VALLE VELASQUEZ SOFIA | M03 | CIENCIAS NATURA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M03 | CIENCIAS NATURA | | E06 | LZATE ORTIZ JORGE MARIO | M03 | CIENCIAS NATURA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M04 | MATEMATICAS | | E02 | ALVAREZ AGUDELO ESTEBAN | M04 | MATEMATICAS | | E03 | ZAPATA CAMPIÑO ISABEL | M04 | MATEMATICAS | | E04 | VALLE VELASQUEZ SOFIA | M04 | MATEMATICAS | | E05 | MORENO POSADA DIEGO ALEJANDRO | M04 | MATEMATICAS | | E06 | LZATE ORTIZ JORGE MARIO | M04 | MATEMATICAS | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M05 | INVESTIGACION | | E02 | ALVAREZ AGUDELO ESTEBAN | M05 | INVESTIGACION | | E03 | ZAPATA CAMPIÑO ISABEL | M05 | INVESTIGACION | | E04 | VALLE VELASQUEZ SOFIA | M05 | INVESTIGACION | | E05 | MORENO POSADA DIEGO ALEJANDRO | M05 | INVESTIGACION | | E06 | LZATE ORTIZ JORGE MARIO | M05 | INVESTIGACION | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M06 | FISICA | | E02 | ALVAREZ AGUDELO ESTEBAN | M06 | FISICA | | E03 | ZAPATA CAMPIÑO ISABEL | M06 | FISICA | | E04 | VALLE VELASQUEZ SOFIA | M06 | FISICA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M06 | FISICA | | E06 | LZATE ORTIZ JORGE MARIO | M06 | FISICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M07 | FILOSOFIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M07 | FILOSOFIA | | E03 | ZAPATA CAMPIÑO ISABEL | M07 | FILOSOFIA | | E04 | VALLE VELASQUEZ SOFIA | M07 | FILOSOFIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M07 | FILOSOFIA | | E06 | LZATE ORTIZ JORGE MARIO | M07 | FILOSOFIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M08 | EDUCACION FISIC | | E02 | ALVAREZ AGUDELO ESTEBAN | M08 | EDUCACION FISIC | | E03 | ZAPATA CAMPIÑO ISABEL | M08 | EDUCACION FISIC | | E04 | VALLE VELASQUEZ SOFIA | M08 | EDUCACION FISIC | | E05 | MORENO POSADA DIEGO ALEJANDRO | M08 | EDUCACION FISIC | | E06 | LZATE ORTIZ JORGE MARIO | M08 | EDUCACION FISIC | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M09 | ETICA | | E02 | ALVAREZ AGUDELO ESTEBAN | M09 | ETICA | | E03 | ZAPATA CAMPIÑO ISABEL | M09 | ETICA | | E04 | VALLE VELASQUEZ SOFIA | M09 | ETICA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M09 | ETICA | | E06 | LZATE ORTIZ JORGE MARIO | M09 | ETICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M10 | ARTISTICA | | E02 | ALVAREZ AGUDELO ESTEBAN | M10 | ARTISTICA | | E03 | ZAPATA CAMPIÑO ISABEL | M10 | ARTISTICA | | E04 | VALLE VELASQUEZ SOFIA | M10 | ARTISTICA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M10 | ARTISTICA | | E06 | LZATE ORTIZ JORGE MARIO | M10 | ARTISTICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M11 | TECNOLOGIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M11 | TECNOLOGIA | | E03 | ZAPATA CAMPIÑO ISABEL | M11 | TECNOLOGIA | | E04 | VALLE VELASQUEZ SOFIA | M11 | TECNOLOGIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M11 | TECNOLOGIA | | E06 | LZATE ORTIZ JORGE MARIO | M11 | TECNOLOGIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M12 | INFORMATICA | | E02 | ALVAREZ AGUDELO ESTEBAN | M12 | INFORMATICA | | E03 | ZAPATA CAMPIÑO ISABEL | M12 | INFORMATICA | | E04 | VALLE VELASQUEZ SOFIA | M12 | INFORMATICA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M12 | INFORMATICA | | E06 | LZATE ORTIZ JORGE MARIO | M12 | INFORMATICA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M13 | RELIGION | | E02 | ALVAREZ AGUDELO ESTEBAN | M13 | RELIGION | | E03 | ZAPATA CAMPIÑO ISABEL | M13 | RELIGION | | E04 | VALLE VELASQUEZ SOFIA | M13 | RELIGION | | E05 | MORENO POSADA DIEGO ALEJANDRO | M13 | RELIGION | | E06 | LZATE ORTIZ JORGE MARIO | M13 | RELIGION | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M14 | SOCIALES | | E02 | ALVAREZ AGUDELO ESTEBAN | M14 | SOCIALES | | E03 | ZAPATA CAMPIÑO ISABEL | M14 | SOCIALES | | E04 | VALLE VELASQUEZ SOFIA | M14 | SOCIALES | | E04 | VALLE VELASQUEZ SOFIA | M14 | SOCIALES | | E06 | LZATE ORTIZ JORGE MARIO | M14 | SOCIALES | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M15 | INGLES | | E02 | ALVAREZ AGUDELO ESTEBAN | M15 | INGLES | | E03 | ZAPATA CAMPIÑO ISABEL | M15 | INGLES | | E04 | VALLE VELASQUEZ SOFIA | M15 | INGLES | | E05 | MORENO POSADA DIEGO ALEJANDRO | M15 | INGLES | | E06 | LZATE ORTIZ JORGE MARIO | M15 | INGLES | +---------------+-------------------------------+------------+-----------------+ 90 rows in set (0.001 sec) MariaDB [BDMatricula]> select estudiante.codestudiante, estudiante.nombre, estudocemate.codestudiante from estudiante left join estudocemate on estudiante.codestudiante= estudocemate.codestudiante where estudocemate.codestudiante is null; +---------------+---------------------------------+---------------+ | codestudiante | nombre | codestudiante | +---------------+---------------------------------+---------------+ | E07 | ZAPATA QUINTERO JOSE MARIA | NULL | | E08 | MNTOYA MONTOYA AEJANDRO | NULL | | E09 | LOPERA CARTAGENA LUISA FENANADA | NULL | | E10 | JARAMILLO HENAO JOSE LUIS | NULL | | E11 | ALVAREZ AGUDELO LUNA | NULL | | E12 | ALVAREZ AGUDELO XAVIER | NULL | +---------------+---------------------------------+---------------+ 6 rows in set (0.000 sec) MariaDB [BDMatricula]> Select materia.codmateria, materia.nombre, estudocemate.codmateria from materia right join estudocemate on materia.codmateria= estudocemate.codmateria where estudocemate.codmateria is null; Empty set (0.000 sec) MariaDB [BDMatricula]> Select distinct materia.codmateria, materia.nombre, docente.coddocente, docente.nombre from materia inner join estudocemate on materia.codmateria=estudocemate.codmateria inner join docente on estudocemate.coddocente= docente.coddocente; +------------+-----------------+------------+-------------------------------+ | codmateria | nombre | coddocente | nombre | +------------+-----------------+------------+-------------------------------+ | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | M02 | LECTOESCRITURA | D09 | MOSCOTE MARULANDA YANET MARIA | | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | +------------+-----------------+------------+-------------------------------+ 16 rows in set (0.001 sec) MariaDB [BDMatricula]> select materia.codmateria, materia.nombre, estudocemate.codmateria from materia left join estudocemate on materia.codmateria=estudocemate.codmateria where estudocemate.codmateria is null; Empty set (0.001 sec) MariaDB [BDMatricula]> select docente.coddocente, docente.nombre, estudocemate.coddocente from docente left join estudocemate on docente.coddocente=estudocemate.coddocente where estudocemate.coddocente is null; Empty set (0.000 sec) MariaDB [BDMatricula]> Select estudiante.codestudiante, estudiante.nombre, materia.codmateria, materia.nombre, docente.coddocente, docente.nombre from estudiante inner join estudocemate on estudiante.codestudiante= estudocemate.codestudiante inner join materia on estudocemate.codmateria=materia.codmateria inner join docente on docente.coddocente= estudocemate.coddocente; +---------------+-------------------------------+------------+-----------------+------------+-------------------------------+ | codestudiante | nombre | codmateria | nombre | coddocente | nombre | +---------------+-------------------------------+------------+-----------------+------------+-------------------------------+ | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E03 | ZAPATA CAMPIÑO ISABEL | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E04 | VALLE VELASQUEZ SOFIA | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E06 | LZATE ORTIZ JORGE MARIO | M07 | FILOSOFIA | D01 | CIFUENTES MESA MYEIDY MARIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E02 | ALVAREZ AGUDELO ESTEBAN | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E02 | ALVAREZ AGUDELO ESTEBAN | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E03 | ZAPATA CAMPIÑO ISABEL | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E03 | ZAPATA CAMPIÑO ISABEL | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E04 | VALLE VELASQUEZ SOFIA | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E04 | VALLE VELASQUEZ SOFIA | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E05 | MORENO POSADA DIEGO ALEJANDRO | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E05 | MORENO POSADA DIEGO ALEJANDRO | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E06 | LZATE ORTIZ JORGE MARIO | M11 | TECNOLOGIA | D02 | CUADRADO PEREZ ADRID JOSE | | E06 | LZATE ORTIZ JORGE MARIO | M12 | INFORMATICA | D02 | CUADRADO PEREZ ADRID JOSE | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E03 | ZAPATA CAMPIÑO ISABEL | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E03 | ZAPATA CAMPIÑO ISABEL | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E03 | ZAPATA CAMPIÑO ISABEL | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E04 | VALLE VELASQUEZ SOFIA | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E04 | VALLE VELASQUEZ SOFIA | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E04 | VALLE VELASQUEZ SOFIA | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E06 | LZATE ORTIZ JORGE MARIO | M04 | MATEMATICAS | D03 | DUQUE RESTREPO ESTER LUCIA | | E06 | LZATE ORTIZ JORGE MARIO | M05 | INVESTIGACION | D03 | DUQUE RESTREPO ESTER LUCIA | | E06 | LZATE ORTIZ JORGE MARIO | M06 | FISICA | D03 | DUQUE RESTREPO ESTER LUCIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E02 | ALVAREZ AGUDELO ESTEBAN | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E03 | ZAPATA CAMPIÑO ISABEL | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E04 | VALLE VELASQUEZ SOFIA | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E05 | MORENO POSADA DIEGO ALEJANDRO | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E06 | LZATE ORTIZ JORGE MARIO | M10 | ARTISTICA | D04 | GUIRALES MAURICIO | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E02 | ALVAREZ AGUDELO ESTEBAN | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E03 | ZAPATA CAMPIÑO ISABEL | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E04 | VALLE VELASQUEZ SOFIA | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E06 | LZATE ORTIZ JORGE MARIO | M01 | ESPAÑOL | D05 | VERA DAZA MARIA ELENA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E02 | ALVAREZ AGUDELO ESTEBAN | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E02 | ALVAREZ AGUDELO ESTEBAN | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E03 | ZAPATA CAMPIÑO ISABEL | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E03 | ZAPATA CAMPIÑO ISABEL | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E04 | VALLE VELASQUEZ SOFIA | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E04 | VALLE VELASQUEZ SOFIA | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E05 | MORENO POSADA DIEGO ALEJANDRO | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E05 | MORENO POSADA DIEGO ALEJANDRO | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E06 | LZATE ORTIZ JORGE MARIO | M09 | ETICA | D06 | PALACIO TOMAS FELIPE | | E06 | LZATE ORTIZ JORGE MARIO | M13 | RELIGION | D06 | PALACIO TOMAS FELIPE | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E02 | ALVAREZ AGUDELO ESTEBAN | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E02 | ALVAREZ AGUDELO ESTEBAN | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E03 | ZAPATA CAMPIÑO ISABEL | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E03 | ZAPATA CAMPIÑO ISABEL | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E04 | VALLE VELASQUEZ SOFIA | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E04 | VALLE VELASQUEZ SOFIA | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E05 | MORENO POSADA DIEGO ALEJANDRO | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E04 | VALLE VELASQUEZ SOFIA | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E06 | LZATE ORTIZ JORGE MARIO | M02 | LECTOESCRITURA | D07 | MOSUERA OSORIO MARYETH | | E06 | LZATE ORTIZ JORGE MARIO | M14 | SOCIALES | D07 | MOSUERA OSORIO MARYETH | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E03 | ZAPATA CAMPIÑO ISABEL | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E04 | VALLE VELASQUEZ SOFIA | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E06 | LZATE ORTIZ JORGE MARIO | M15 | INGLES | D08 | ARBOLEDA VARGAS MARIA OFELIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M02 | LECTOESCRITURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E02 | ALVAREZ AGUDELO ESTEBAN | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E03 | ZAPATA CAMPIÑO ISABEL | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E04 | VALLE VELASQUEZ SOFIA | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E05 | MORENO POSADA DIEGO ALEJANDRO | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E06 | LZATE ORTIZ JORGE MARIO | M03 | CIENCIAS NATURA | D09 | MOSCOTE MARULANDA YANET MARIA | | E01 | ACEVEDO BURITICA JUAN ESTEBAN | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | | E02 | ALVAREZ AGUDELO ESTEBAN | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | | E03 | ZAPATA CAMPIÑO ISABEL | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | | E04 | VALLE VELASQUEZ SOFIA | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | | E05 | MORENO POSADA DIEGO ALEJANDRO | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | | E06 | LZATE ORTIZ JORGE MARIO | M08 | EDUCACION FISIC | D10 | MACIAS EDGAR ALBERTO | +---------------+-------------------------------+------------+-----------------+------------+-------------------------------+ 90 rows in set (0.001 sec) MariaDB [BDMatricula]>