PRACTICA 3
SQL
Fecha de entrega: 14 de Noviembre del
2022
Por: David Kaleb Real Haro
Registro: 20300663
Grupo: 5F1
CENTRO DE ENSEÑANZA
TECNICA INDUSTRIAL
PLANTEL COLOMOS
Carrera: Desarrollo de
Software.
ASIGNATURA: BASE DE
DATOS 1
MAESTRA: ISAAC
RODRIGUEZ KARLA ARELI
1-Usar la BD Ceti
MariaDB [(none)]> use ceti;
Database changed
MariaDB [ceti]>
2- Imprime la lista de la información de los profesores
MariaDB [ceti]> SELECT*FROM profesor;
+--------+-------------------+-------------+-----------------------+-------------+
| Nomina | Nombre | ApeP | ApeM | FK_Academia |
+--------+-------------------+-------------+-----------------------+-------------+
| 1 | GUILLERMO | GARCIA | DIAZ | 8|
| 2 | PABLO CESAR | OROPEZA | HERNANDEZ | 6|
| 3 | CESAR OSWALDO | GODINEZ | MARTINEZ | 8|
| 4 | ALEJANDRA | TORRES | ALCARAZ | 1|
| 5 | RODOLFO ULYSES | CARDENAS | VAZQUEZ | 5|
| 6 | SERGIO | DELGADO | BECERRA | 4|
| 7 | KARLA ARELI | RODRIGUEZ | ISAAC | 4|
| 8 | ANTONIO | GONZALEZ | LOZANO | 2|
| 9 | SERGIO ANTONIO | ROMAN | ELLERBRACKE | 4|
| 10 | DIANA MARISOL | FLORES | FIGUEROA | 1|
| 11 | JORGE | CAMPA | PAMPLONA | 3|
| 12 | ELIZABETH | SOLORIO | ALVAREZ DEL CASTILLO | 2|
| 13 | SONIA ERIKA | DE LA TORRE | IBA?EZ | 4|
| 14 | MARTHA BERENICE | GUZMAN | BARRIOS | 11 |
| 15 | MARIO CESAR | PANTOJA | MANZO | 10 |
| 16 | MARIA GUADALUPE | GONZALEZ | DELGADO | 9|
| 17 | JOSE VICTOR | MARTINEZ | RAMOS | 6|
| 18 | LUZ ARACELI | BELTRAL | GARCIA | 5|
| 19 | MARINA | | DOBROVA | 11 |
| 20 | ANA ELIZABETH | BERGHOUSE | DIAZ VELEZ | 6|
| 21 | LORENA | JIMENEZ | ACEVES | 9|
| 22 | CLAUDIA BETHZABEL | ROSALES | PARDO | 8|
| 23 | IGNACIO | | ZARATE | 11 |
| 24 | ERIKA | CHAVEZ | LORENZANA | 2|
| 25 | JUAN MANUEL | DAMIAN | GARCIA | 11 |
+--------+-------------------+-------------+-----------------------+-------------+
25 rows in set (0.001 sec)
MariaDB [ceti]>
3- Imprime el nombre y apellido de los profesores de la academia de informatica
MariaDB [ceti]> SELECT nombre, ApeP,ApeM FROM profesor WHERE(Fk_Academia=4);
+----------------+-------------+--------------+
| nombre | ApeP | ApeM |
+----------------+-------------+--------------+
| SERGIO | DELGADO | BECERRA |
| KARLA ARELI | RODRIGUEZ | ISAAC |
| SERGIO ANTONIO | ROMAN | ELLERBRACKE |
| SONIA ERIKA | DE LA TORRE | IBA?EZ |
+----------------+-------------+--------------+
4 rows in set (0.001 sec)
MariaDB [ceti]>
4- Modifica elapellidodel profesor de POOporel apellido de tu villano favorito
MariaDB [ceti]> UPDATE profesor SET ApeP='Venom' WHERE (Nomina=13);
Query OK, 1 row affected (0.022 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ceti]> UPDATE profesor SET ApeP='Falcone' WHERE (Nomina=13);
Query OK, 1 row affected (0.026 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ceti]>
5- Cuenta los alumnos de la carrera de desarrollo (COUNT)
MariaDB [ceti]> SELECT COUNT(DISTINCT Registro) FROM alumno WHERE (carrera=3);
+--------------------------+
| COUNT(DISTINCT Registro) |
+--------------------------+
| 20 |
+--------------------------+
1 row in set (0.027 sec)
MariaDB [ceti]>
6- Cuenta a los profesores de laacademia de informática
MariaDB [ceti]> SELECT COUNT(DISTINCT Nomina) FROM profesor WHERE (Fk_Academia=4);
+------------------------+
| COUNT(DISTINCT Nomina) |
+------------------------+
| 4|
+------------------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
7- Imprime la SUMA de todos los registros de los alumnos (SUM)
MariaDB [ceti]> SELECT SUM(Registro) AS TOTALBALANCE FROM Alumno;
+--------------+
| TOTALBALANCE |
+--------------+
| 403211754 |
+--------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
8- Imprime el promediode todos los alumnos (AVG)
MariaDB [ceti]> SELECT AVG (Calificacion) FROM calificacion;
+--------------------+
| AVG (Calificacion) |
+--------------------+
| 83.1500 |
+--------------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
9- Imprime tu promedio de todas las materias (AVG)
MariaDB [ceti]> SELECT AVG (Calificacion) FROM calificacion WHERE (Alumno=20300668);
+--------------------+
| AVG (Calificacion) |
+--------------------+
| 94.8889 |
+--------------------+
1 row in set (0.001 sec)
MariaDB [ceti]> SELECT AVG (Calificacion) FROM calificacion WHERE (Alumno=20300663);
+--------------------+
| AVG (Calificacion) |
+--------------------+
| 94.1111 |
+--------------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
10- Imprime el registro máximo de la tabla alumno (MAX)
MariaDB [ceti]> SELECT MAX(Registro) From Alumno;
+---------------+
| MAX(Registro) |
+---------------+
| 20300849 |
+---------------+
1 row in set (0.000 sec)
MariaDB [ceti]>
11- Imprime la calificaciónmáxima(MAX)
MariaDB [ceti]> SELECT MAX(Calificacion) From Calificacion;
+-------------------+
| MAX(Calificacion) |
+-------------------+
| 100 |
+-------------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
12- Imprime el registro mínimo de la tabla alumno (MIN)
MariaDB [ceti]> SELECT MIN(Registro) From Alumno;
+---------------+
| MIN(Registro) |
+---------------+
| 19300107 |
+---------------+
1 row in set (0.000 sec)
MariaDB [ceti]>
13- Imprime la calificaciónmínima(MIN)
MariaDB [ceti]> SELECT MIN(Calificacion) From Calificacion;
+-------------------+
| MIN(Calificacion) |
+-------------------+
| 0|
+-------------------+
1 row in set (0.001 sec)
MariaDB [ceti]>
14-Si no estas en tu ordenador Elimina la BD
MariaDB [ceti]> DROP DATABASE ceti;
Query OK, 7 rows affected (0.716 sec)
MariaDB [(none)]>
