Centro de Enseñanza Técnica
Industrial
1º Parcial
Práctica Operadores de conjunto
Elaborado por el alumno:
Real Haro David Kaleb
Registro: 20300663
Grupo: 6C1
Carrera: Tecnólogo en Desarrollo de Software
Materia: Base de Datos II
Asesor:
Mtra. Karla Areli Isaac Rodríguez
2 de marzo de 2023
1.-(SELECT NOMBRE FROM alumnos) UNION(SELECT NOMBRE FROM docente)
MariaDB [ceti_6c1]> (SELECT NOMBRE FROM alumno) UNION(SELECT NOMBRE
FROM profesor);
+---------------------+
| NOMBRE |
+---------------------+
| Diego |
| Misael |
| Sergio Yael |
| Denahi |
| Perla Dayane |
| Osman Azael |
| Gabriel Nahum |
| Victor maximiliano |
| David Kaleb |
| Diego Antonio |
| Fernando |
| Daniel |
| Gabriela Alejandra |
| Francisco Emiliano |
| Gustavo Miguel |
| Isaac Daniel |
| Jared Emiliano |
| Diego Emiliano |
| Arely Jazm?n |
| Melanie Astrid |
| GUILLERMO |
| PABLO CESAR |
| CESAR OSWALDO |
| ALEJANDRA |
| RODOLFO ULYSES |
| SERGIO |
| KARLA ARELI |
| ANTONIO |
| SERGIO ANTONIO |
| DIANA MARISOL |
| JORGE |
| ELIZABETH |
| SONIA ERIKA |
| MARTHA BERENICE |
| MARIO CESAR |
| MARIA GUADALUPE |
| JOSE VICTOR |
| LUZ ARACELI |
| MARINA |
| ANA ELIZABETH |
| LORENA |
| CLAUDIA BETHZABEL |
| IGNACIO |
| ERIKA |
| JUAN MANUEL |
| Juan Daniel |
| Georgina |
| Teresita |
| Carlos Alberto |
| Nancy Del Carmen |
| Susana Elizabeth |
| Juan Manuell |
| Lourdes |
| Silvia Guillermina |
| Clara Gabriela |
+---------------------+
55 rows in set (0.001 sec)
MariaDB [ceti_6c1]>
2.- (SELECT NOMBRE FROM alumnos) UNION ALL(SELECT NOMBRE FROM docente)
MariaDB [ceti_6c1]> (SELECT NOMBRE FROM alumno) UNION ALL(SELECT NOMBRE
FROM profesor);
+---------------------+
| NOMBRE |
+---------------------+
| Diego |
| Misael |
| Sergio Yael |
| Denahi |
| Perla Dayane |
| Osman Azael |
| Gabriel Nahum |
| Victor maximiliano |
| David Kaleb |
| Diego Antonio |
| Fernando |
| Daniel |
| Gabriela Alejandra |
| Francisco Emiliano |
| Gustavo Miguel |
| Isaac Daniel |
| Diego |
| Daniel |
| Jared Emiliano |
| Diego Emiliano |
| Arely Jazm?n |
| Melanie Astrid |
| GUILLERMO |
| PABLO CESAR |
| CESAR OSWALDO |
| ALEJANDRA |
| RODOLFO ULYSES |
| SERGIO |
| KARLA ARELI |
| ANTONIO |
| SERGIO ANTONIO |
| DIANA MARISOL |
| JORGE |
| ELIZABETH |
| SONIA ERIKA |
| MARTHA BERENICE |
| MARIO CESAR |
| MARIA GUADALUPE |
| JOSE VICTOR |
| LUZ ARACELI |
| MARINA |
| ANA ELIZABETH |
| LORENA |
| CLAUDIA BETHZABEL |
| IGNACIO |
| ERIKA |
| JUAN MANUEL |
| Juan Daniel |
| Georgina |
| Teresita |
| Carlos Alberto |
| Nancy Del Carmen |
| Susana Elizabeth |
| Juan Manuell |
| Lourdes |
| Silvia Guillermina |
| Erika |
| Clara Gabriela |
+---------------------+
58 rows in set (0.001 sec)
MariaDB [ceti_6c1]>
3.-SELECT [Link] FROM alumnos INNER JOIN docente USING(nombre)
MariaDB [ceti_6c1]> SELECT [Link] FROM alumno INNER JOIN profesor
USING(nombre);
Empty set (0.001 sec)
MariaDB [ceti_6c1]>
MariaDB [ceti_6c1]> update profesor set nombre="Arely" WHERE nomina=7;
Query OK, 1 row affected (0.029 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ceti_6c1]> update alumno set nombre="Arely" WHERE registro=20300846;
Query OK, 1 row affected (0.020 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ceti_6c1]> SELECT [Link] FROM alumno INNER JOIN profesor
USING(nombre);
+--------+
| nombre |
+--------+
| Arely |
+--------+
1 row in set (0.001 sec)
MariaDB [ceti_6c1]>
4.-SELECT nombre FROM alumnos LEFTJOIN docente USING(nombre) WHERE
[Link] IS NULL
MariaDB [ceti_6c1]> SELECT nombre FROM alumno LEFT JOIN profesor
USING(nombre) WHERE [Link] IS NULL;
+---------------------+
| nombre |
+---------------------+
| Diego |
| Misael |
| Sergio Yael |
| Denahi |
| Perla Dayane |
| Osman Azael |
| Gabriel Nahum |
| Victor maximiliano |
| David Kaleb |
| Diego Antonio |
| Fernando |
| Daniel |
| Gabriela Alejandra |
| Francisco Emiliano |
| Gustavo Miguel |
| Isaac Daniel |
| Diego |
| Daniel |
| Jared Emiliano |
| Diego Emiliano |
| Arely Jazm?n |
| Melanie Astrid |
+---------------------+
22 rows in set (0.013 sec)
MariaDB [ceti_6c1]>
