MariaDB [BDMatricula]> MariaDB [(none)]>  C:\Users\EQUIPO\Downloads\BDmatricula2.sql
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, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Database changed
Query OK, 0 rows affected (0.007 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.006 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, 10 rows affected (0.002 sec)
Records: 10  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.007 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, 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.004 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.001 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.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.007 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.001 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.004 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.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 90 rows affected (0.003 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.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.006 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, 15 rows affected (0.001 sec)
Records: 15  Duplicates: 0  Warnings: 0

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.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.002 sec)

MariaDB [BDMatricula]> select * from docente;
+------------+-------------------------------+-----------+----------+----------------------+
| coddocente | nombre                        | direccion | telefono | email                |
+------------+-------------------------------+-----------+----------+----------------------+
| D01        | CIFUENTES MESA MYEIDY MARIA   | NULL      | NULL     | myleidym.iearm@gmail |
| D02        | CUADRADO PEREZ ADRID JOSE     | NULL      | NULL     | adrid.iearm@gmail.co |
| D03        | DUQUE RESTREPO ESTER LUCIA    | NULL      | NULL     | esterl.iearm@gmail.c |
| D04        | GUIRALES MAURICIO             | NULL      | NULL     | mauriciog.iearm@gmai |
| D05        | VERA DAZA MARIA ELENA         | NULL      | NULL     | mariae.iearm@gmail.c |
| D06        | PALACIO TOMAS FELIPE          | NULL      | NULL     | tomasf.iearm@gmail.c |
| D07        | MOSUERA OSORIO MARYETH        | NULL      | NULL     | maryeth.iearm@gmail. |
| D08        | ARBOLEDA VARGAS MARIA OFELIA  | NULL      | NULL     | ofeliaa.iearm@gmail. |
| D09        | MOSCOTE MARULANDA YANET MARIA | NULL      | NULL     | yanetm.iearm@gmail.c |
| D10        | MACIAS EDGAR ALBERTO          | NULL      | NULL     | edgarm.iearm@gmail.c |
+------------+-------------------------------+-----------+----------+----------------------+
10 rows in set (0.002 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.000 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.002 sec)

MariaDB [BDMatricula]> estudocemate;
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 'estudocemate' at line 1
MariaDB [BDMatricula]> select * from estudocemate;
+---------------+------------+------------+
| codestudiante | coddocente | codmateria |
+---------------+------------+------------+
| E01           | D05        | M01        |
| E01           | D07        | M02        |
| E01           | D09        | M02        |
| E01           | D03        | M04        |
| E01           | D03        | M05        |
| E01           | D03        | M06        |
| E01           | D01        | M07        |
| E01           | D10        | M08        |
| E01           | D06        | M09        |
| E01           | D04        | M10        |
| E01           | D02        | M11        |
| E01           | D02        | M12        |
| E01           | D06        | M13        |
| E01           | D07        | M14        |
| E01           | D08        | M15        |
| E02           | D05        | M01        |
| E02           | D07        | M02        |
| E02           | D09        | M03        |
| E02           | D03        | M04        |
| E02           | D03        | M05        |
| E02           | D03        | M06        |
| E02           | D01        | M07        |
| E02           | D10        | M08        |
| E02           | D06        | M09        |
| E02           | D04        | M10        |
| E02           | D02        | M11        |
| E02           | D02        | M12        |
| E02           | D06        | M13        |
| E02           | D07        | M14        |
| E02           | D08        | M15        |
| E03           | D05        | M01        |
| E03           | D07        | M02        |
| E03           | D09        | M03        |
| E03           | D03        | M04        |
| E03           | D03        | M05        |
| E03           | D03        | M06        |
| E03           | D01        | M07        |
| E03           | D10        | M08        |
| E03           | D06        | M09        |
| E03           | D04        | M10        |
| E03           | D02        | M11        |
| E03           | D02        | M12        |
| E03           | D06        | M13        |
| E03           | D07        | M14        |
| E03           | D08        | M15        |
| E04           | D05        | M01        |
| E04           | D07        | M02        |
| E04           | D09        | M03        |
| E04           | D03        | M04        |
| E04           | D03        | M05        |
| E04           | D03        | M06        |
| E04           | D01        | M07        |
| E04           | D10        | M08        |
| E04           | D06        | M09        |
| E04           | D04        | M10        |
| E04           | D02        | M11        |
| E04           | D02        | M12        |
| E04           | D06        | M13        |
| E04           | D07        | M14        |
| E04           | D08        | M15        |
| E05           | D05        | M01        |
| E05           | D07        | M02        |
| E05           | D09        | M03        |
| E05           | D03        | M04        |
| E05           | D03        | M05        |
| E05           | D03        | M06        |
| E05           | D01        | M07        |
| E05           | D10        | M08        |
| E05           | D06        | M09        |
| E05           | D04        | M10        |
| E05           | D02        | M11        |
| E05           | D02        | M12        |
| E05           | D06        | M13        |
| E04           | D07        | M14        |
| E05           | D08        | M15        |
| E06           | D05        | M01        |
| E06           | D07        | M02        |
| E06           | D09        | M03        |
| E06           | D03        | M04        |
| E06           | D03        | M05        |
| E06           | D03        | M06        |
| E06           | D01        | M07        |
| E06           | D10        | M08        |
| E06           | D06        | M09        |
| E06           | D04        | M10        |
| E06           | D02        | M11        |
| E06           | D02        | M12        |
| E06           | D06        | M13        |
| E06           | D07        | M14        |
| E06           | D08        | M15        |
+---------------+------------+------------+
90 rows in set (0.001 sec)

MariaDB [BDMatricula]> select * from materia;
+------------+-----------------+
| codmateria | nombre          |
+------------+-----------------+
| M01        | ESPA¥OL         |
| M02        | LECTOESCRITURA  |
| M03        | CIENCIAS NATURA |
| M04        | MATEMATICAS     |
| M05        | INVESTIGACION   |
| M06        | FISICA          |
| M07        | FILOSOFIA       |
| M08        | EDUCACION FISIC |
| M09        | ETICA           |
| M10        | ARTISTICA       |
| M11        | TECNOLOGIA      |
| M12        | INFORMATICA     |
| M13        | RELIGION        |
| M14        | SOCIALES        |
| M15        | INGLES          |
+------------+-----------------+
15 rows in set (0.002 sec)

MariaDB [BDMatricula]> select estudiante.nombre 'estudiante',acudiente.nombre 'acudiente' from estudiante, acudiente, estuacu where acudiente.codacudiente=estuacu.codacudiente and estuacu.codestudiante=estudiante.codestudiante;
+---------------------------------+---------------------------------+
| estudiante                      | acudiente                       |
+---------------------------------+---------------------------------+
| ACEVEDO BURITICA JUAN ESTEBAN   | ACEVEDO CARDONA ESTEBAN         |
| ALVAREZ AGUDELO ESTEBAN         | AGUDELO MANCO DIANA PATRICIA    |
| ZAPATA CAMPI¥O ISABEL           | ZPATA VALENCIA JORGE            |
| VALLE VELASQUEZ SOFIA           | VELASQUEZ CANO JENNY ASTRID     |
| MORENO POSADA DIEGO ALEJANDRO   | POSADA VASCO ANA                |
| LZATE ORTIZ JORGE MARIO         | ORTIZ PUERTA INDIRA             |
| ZAPATA QUINTERO JOSE MARIA      | QUINTERO MENESES ADRIANA MARIA  |
| MNTOYA MONTOYA AEJANDRO         | MONTOYA RIVERA EDILMA           |
| LOPERA CARTAGENA LUISA FENANADA | LOPERA MONSALVE FERNANDO ALONSO |
| JARAMILLO HENAO JOSE LUIS       | HENAO RIOS DORA EMILSE          |
| ALVAREZ AGUDELO LUNA            | ACEVEDO CARDONA ESTEBAN         |
| ALVAREZ AGUDELO XAVIER          | ACEVEDO CARDONA ESTEBAN         |
+---------------------------------+---------------------------------+
12 rows in set (0.007 sec)MariaDB [BDMatricula]> select materia.nombre 'materia', estudiante.nombre ' estudiante' from materia, estudiante,estudocemate where estudiante.codestudiante='E01' and estudiante.codestudiante=estudocemate.codestudiante and estudocemate.codmateria=materia.codmateria;
+-----------------+-------------------------------+
| materia         | estudiante                    |
+-----------------+-------------------------------+
| ESPA¥OL         | ACEVEDO BURITICA JUAN ESTEBAN |
| LECTOESCRITURA  | ACEVEDO BURITICA JUAN ESTEBAN |
| LECTOESCRITURA  | ACEVEDO BURITICA JUAN ESTEBAN |
| MATEMATICAS     | ACEVEDO BURITICA JUAN ESTEBAN |
| INVESTIGACION   | ACEVEDO BURITICA JUAN ESTEBAN |
| FISICA          | ACEVEDO BURITICA JUAN ESTEBAN |
| FILOSOFIA       | ACEVEDO BURITICA JUAN ESTEBAN |
| EDUCACION FISIC | ACEVEDO BURITICA JUAN ESTEBAN |
| ETICA           | ACEVEDO BURITICA JUAN ESTEBAN |
| ARTISTICA       | ACEVEDO BURITICA JUAN ESTEBAN |
| TECNOLOGIA      | ACEVEDO BURITICA JUAN ESTEBAN |
| INFORMATICA     | ACEVEDO BURITICA JUAN ESTEBAN |
| RELIGION        | ACEVEDO BURITICA JUAN ESTEBAN |
| SOCIALES        | ACEVEDO BURITICA JUAN ESTEBAN |
| INGLES          | ACEVEDO BURITICA JUAN ESTEBAN |
+-----------------+-------------------------------+
15 rows in set, 1 warning (0.006 sec)

MariaDB [BDMatricula]> select estudiante.nombre 'estudiante', materia.nombre 'materia' from materia, estudiante, estudocemate where estudiante.codestudiante=estuadocemate.codestudiante and estudocemate.codmateria=materia.codmateria;
ERROR 1054 (42S22): Unknown column 'estuadocemate.codestudiante' in 'where clause'
MariaDB [BDMatricula]> select estudiante.nombre 'estudiante', materia.nombre 'materia' from materia, estudiante, estudocemate where estudiante.codestudiante=estudocemate.codestudiante and estudocemate.codmateria=materia.codmateria;
+-------------------------------+-----------------+
| estudiante                    | materia         |
+-------------------------------+-----------------+
| ACEVEDO BURITICA JUAN ESTEBAN | ESPA¥OL         |
| ACEVEDO BURITICA JUAN ESTEBAN | LECTOESCRITURA  |
| ACEVEDO BURITICA JUAN ESTEBAN | LECTOESCRITURA  |
| ACEVEDO BURITICA JUAN ESTEBAN | MATEMATICAS     |
| ACEVEDO BURITICA JUAN ESTEBAN | INVESTIGACION   |
| ACEVEDO BURITICA JUAN ESTEBAN | FISICA          |
| ACEVEDO BURITICA JUAN ESTEBAN | FILOSOFIA       |
| ACEVEDO BURITICA JUAN ESTEBAN | EDUCACION FISIC |
| ACEVEDO BURITICA JUAN ESTEBAN | ETICA           |
| ACEVEDO BURITICA JUAN ESTEBAN | ARTISTICA       |
| ACEVEDO BURITICA JUAN ESTEBAN | TECNOLOGIA      |
| ACEVEDO BURITICA JUAN ESTEBAN | INFORMATICA     |
| ACEVEDO BURITICA JUAN ESTEBAN | RELIGION        |
| ACEVEDO BURITICA JUAN ESTEBAN | SOCIALES        |
| ACEVEDO BURITICA JUAN ESTEBAN | INGLES          |
| ALVAREZ AGUDELO ESTEBAN       | ESPA¥OL         |
| ALVAREZ AGUDELO ESTEBAN       | LECTOESCRITURA  |
| ALVAREZ AGUDELO ESTEBAN       | CIENCIAS NATURA |
| ALVAREZ AGUDELO ESTEBAN       | MATEMATICAS     |
| ALVAREZ AGUDELO ESTEBAN       | INVESTIGACION   |
| ALVAREZ AGUDELO ESTEBAN       | FISICA          |
| ALVAREZ AGUDELO ESTEBAN       | FILOSOFIA       |
| ALVAREZ AGUDELO ESTEBAN       | EDUCACION FISIC |
| ALVAREZ AGUDELO ESTEBAN       | ETICA           |
| ALVAREZ AGUDELO ESTEBAN       | ARTISTICA       |
| ALVAREZ AGUDELO ESTEBAN       | TECNOLOGIA      |
| ALVAREZ AGUDELO ESTEBAN       | INFORMATICA     |
| ALVAREZ AGUDELO ESTEBAN       | RELIGION        |
| ALVAREZ AGUDELO ESTEBAN       | SOCIALES        |
| ALVAREZ AGUDELO ESTEBAN       | INGLES          |
| ZAPATA CAMPI¥O ISABEL         | ESPA¥OL         |
| ZAPATA CAMPI¥O ISABEL         | LECTOESCRITURA  |
| ZAPATA CAMPI¥O ISABEL         | CIENCIAS NATURA |
| ZAPATA CAMPI¥O ISABEL         | MATEMATICAS     |
| ZAPATA CAMPI¥O ISABEL         | INVESTIGACION   |
| ZAPATA CAMPI¥O ISABEL         | FISICA          |
| ZAPATA CAMPI¥O ISABEL         | FILOSOFIA       |
| ZAPATA CAMPI¥O ISABEL         | EDUCACION FISIC |
| ZAPATA CAMPI¥O ISABEL         | ETICA           |
| ZAPATA CAMPI¥O ISABEL         | ARTISTICA       |
| ZAPATA CAMPI¥O ISABEL         | TECNOLOGIA      |
| ZAPATA CAMPI¥O ISABEL         | INFORMATICA     |
| ZAPATA CAMPI¥O ISABEL         | RELIGION        |
| ZAPATA CAMPI¥O ISABEL         | SOCIALES        |
| ZAPATA CAMPI¥O ISABEL         | INGLES          |
| VALLE VELASQUEZ SOFIA         | ESPA¥OL         |
| VALLE VELASQUEZ SOFIA         | LECTOESCRITURA  |
| VALLE VELASQUEZ SOFIA         | CIENCIAS NATURA |
| VALLE VELASQUEZ SOFIA         | MATEMATICAS     |
| VALLE VELASQUEZ SOFIA         | INVESTIGACION   |
| VALLE VELASQUEZ SOFIA         | FISICA          |
| VALLE VELASQUEZ SOFIA         | FILOSOFIA       |
| VALLE VELASQUEZ SOFIA         | EDUCACION FISIC |
| VALLE VELASQUEZ SOFIA         | ETICA           |
| VALLE VELASQUEZ SOFIA         | ARTISTICA       |
| VALLE VELASQUEZ SOFIA         | TECNOLOGIA      |
| VALLE VELASQUEZ SOFIA         | INFORMATICA     |
| VALLE VELASQUEZ SOFIA         | RELIGION        |
| VALLE VELASQUEZ SOFIA         | SOCIALES        |
| VALLE VELASQUEZ SOFIA         | INGLES          |
| VALLE VELASQUEZ SOFIA         | SOCIALES        |
| MORENO POSADA DIEGO ALEJANDRO | ESPA¥OL         |
| MORENO POSADA DIEGO ALEJANDRO | LECTOESCRITURA  |
| MORENO POSADA DIEGO ALEJANDRO | CIENCIAS NATURA |
| MORENO POSADA DIEGO ALEJANDRO | MATEMATICAS     |
| MORENO POSADA DIEGO ALEJANDRO | INVESTIGACION   |
| MORENO POSADA DIEGO ALEJANDRO | FISICA          |
| MORENO POSADA DIEGO ALEJANDRO | FILOSOFIA       |
| MORENO POSADA DIEGO ALEJANDRO | EDUCACION FISIC |
| MORENO POSADA DIEGO ALEJANDRO | ETICA           |
| MORENO POSADA DIEGO ALEJANDRO | ARTISTICA       |
| MORENO POSADA DIEGO ALEJANDRO | TECNOLOGIA      |
| MORENO POSADA DIEGO ALEJANDRO | INFORMATICA     |
| MORENO POSADA DIEGO ALEJANDRO | RELIGION        |
| MORENO POSADA DIEGO ALEJANDRO | INGLES          |
| LZATE ORTIZ JORGE MARIO       | ESPA¥OL         |
| LZATE ORTIZ JORGE MARIO       | LECTOESCRITURA  |
| LZATE ORTIZ JORGE MARIO       | CIENCIAS NATURA |
| LZATE ORTIZ JORGE MARIO       | MATEMATICAS     |
| LZATE ORTIZ JORGE MARIO       | INVESTIGACION   |
| LZATE ORTIZ JORGE MARIO       | FISICA          |
| LZATE ORTIZ JORGE MARIO       | FILOSOFIA       |
| LZATE ORTIZ JORGE MARIO       | EDUCACION FISIC |
| LZATE ORTIZ JORGE MARIO       | ETICA           |
| LZATE ORTIZ JORGE MARIO       | ARTISTICA       |
| LZATE ORTIZ JORGE MARIO       | TECNOLOGIA      |
| LZATE ORTIZ JORGE MARIO       | INFORMATICA     |
| LZATE ORTIZ JORGE MARIO       | RELIGION        |
| LZATE ORTIZ JORGE MARIO       | SOCIALES        |
| LZATE ORTIZ JORGE MARIO       | INGLES          |
+-------------------------------+-----------------+
90 rows in set (0.004 sec)MariaDB [BDMatricula]> select estudiante.nombre 'estudiante' from estudiante left join estudocemate on estudiante.codestudiante=estudocemate.codestudiante where estudocemate.codmateria is null;
+---------------------------------+
| estudiante                      |
+---------------------------------+
| ZAPATA QUINTERO JOSE MARIA      |
| MNTOYA MONTOYA AEJANDRO         |
| LOPERA CARTAGENA LUISA FENANADA |
| JARAMILLO HENAO JOSE LUIS       |
| ALVAREZ AGUDELO LUNA            |
| ALVAREZ AGUDELO XAVIER          |
+---------------------------------+
6 rows in set (0.001 sec)
MariaDB [BDMatricula]> select docente.nombre 'docente', materia.nombre 'materia' from docente, materia, estudocemate where docente.coddocente=estudocemate.coddocente and estudocemate.codmateria=materia.codmateria;
+-------------------------------+-----------------+
| docente                       | materia         |
+-------------------------------+-----------------+
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CIFUENTES MESA MYEIDY MARIA   | FILOSOFIA       |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| CUADRADO PEREZ ADRID JOSE     | TECNOLOGIA      |
| CUADRADO PEREZ ADRID JOSE     | INFORMATICA     |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| DUQUE RESTREPO ESTER LUCIA    | MATEMATICAS     |
| DUQUE RESTREPO ESTER LUCIA    | INVESTIGACION   |
| DUQUE RESTREPO ESTER LUCIA    | FISICA          |
| GUIRALES MAURICIO             | ARTISTICA       |
| GUIRALES MAURICIO             | ARTISTICA       |
| GUIRALES MAURICIO             | ARTISTICA       |
| GUIRALES MAURICIO             | ARTISTICA       |
| GUIRALES MAURICIO             | ARTISTICA       |
| GUIRALES MAURICIO             | ARTISTICA       |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| VERA DAZA MARIA ELENA         | ESPA¥OL         |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| PALACIO TOMAS FELIPE          | ETICA           |
| PALACIO TOMAS FELIPE          | RELIGION        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| MOSUERA OSORIO MARYETH        | LECTOESCRITURA  |
| MOSUERA OSORIO MARYETH        | SOCIALES        |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| ARBOLEDA VARGAS MARIA OFELIA  | INGLES          |
| MOSCOTE MARULANDA YANET MARIA | LECTOESCRITURA  |
| MOSCOTE MARULANDA YANET MARIA | CIENCIAS NATURA |
| MOSCOTE MARULANDA YANET MARIA | CIENCIAS NATURA |
| MOSCOTE MARULANDA YANET MARIA | CIENCIAS NATURA |
| MOSCOTE MARULANDA YANET MARIA | CIENCIAS NATURA |
| MOSCOTE MARULANDA YANET MARIA | CIENCIAS NATURA |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
| MACIAS EDGAR ALBERTO          | EDUCACION FISIC |
+-------------------------------+-----------------+
90 rows in set (0.002 sec)

MariaDB [matricula2]> exit
Bye