Diccionario de datos en POO
Enviado por joshua_contreras • 7 de Marzo de 2023 • Ensayos • 8.804 Palabras (36 Páginas) • 119 Visitas
Joshua Contreras Barajas 18300089 6F3 18/08/22 Base de datos 2 Karla Arely Isaac Rodríguez[pic 1]
[pic 2]
Setting environment for using XAMPP for Windows.
Departamento@DESKTOP-6KO0LLA c:\xampp
# mysql -h localhost -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 171
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)]> USE DATABESE ceti
ERROR 1049 (42000): Unknown database 'databese'
MariaDB [(none)]> USE DATABESE ceti;
ERROR 1049 (42000): Unknown database 'databese'
MariaDB [(none)]> USE ceti;
Database changed
MariaDB [ceti]> SELECT*FROM docente WHERE academia IN (SELECT clave FROM academia WHERE nombre="Sistemas Digitales");
+-------+----------+--------------+------------------------------+
| clave | academia | nombre | apellido |
+-------+----------+--------------+------------------------------+
| 4005 | 4 | Elizabeth | Alvarez del Castillo Solorio |
| 4015 | 4 | Edgar Matias | Aldana |
| 5005 | 4 | Antonio | Gonzales Lozano |
| 5017 | 4 | Rogelio | Mejia Gutierrez |
+-------+----------+--------------+------------------------------+
4 rows in set (0.001 sec)
MariaDB [ceti]> select * from alumno where municipio NOT IN (SELECT clave from municipio where nombre = "Tlajomulco de Zuniga");
+----------+-----------+---------+-------------------+--------------------+------------+------+------------+---------------------------------+---------------------------------+
| registro | municipio | carrera | nombre | apellido | fecha_nac | sexo | celular | domicilio | colonia |
+----------+-----------+---------+-------------------+--------------------+------------+------+------------+---------------------------------+---------------------------------+
| 17300143 | 120 | 3 | Maximiliano Agraz | Ledesma Fernandez | 2001-12-04 | H | 3326360907 | Rincon de los limones 10 | Rinconada Vallarta |
| 18300089 | 40 | 3 | Joshua Keanu | Contreras Barajas | 0000-00-00 | H | 3320342513 | Inocencio Arreoola 3292 | Ricardo Flores Magon |
| 18300402 | 40 | 3 | Enrique | Romero Castro | 2003-05-10 | H | 3332325275 | Vista la Catedral 3068 | Cerro del Tesoro |
| 19300081 | 40 | 3 | Luis Angel | Martinez Gonzalez | 2004-08-27 | H | 3311416071 | C.Hacienda El Platanar | Oblatos |
| 19300085 | 120 | 3 | Daniel Alejandro | Orona Flores | 0000-00-00 | H | 3319577761 | Tulipanes 885 | Los Girasoles |
| 19300100 | 120 | 3 | Emilio | Gomez Breschi | 2004-12-18 | H | 3322748774 | Cerrada Marina Vallarta 340 | Santa Margarita Residencial |
| 19300135 | 120 | 3 | Isaac Daniel | Chavez Chavez | 2004-05-10 | H | 3322467998 | Jardines de las CLa. Ori. 1427 | Jardines del Vergel |
| 19300764 | 120 | 3 | Alvaro | Rosas Orozco | 2004-09-23 | H | 3324303263 | Calle Manuel Hernandez Hernadez | Parques del Auditorio |
| 20100306 | 80 | 3 | Aldo | Garduno Gomez | 2004-08-10 | H | 3333035791 | C. Arties | Las pomas |
| 20100325 | 120 | 3 | Octavio | Chong Hernandez | 2004-02-21 | H | 3311506492 | Eca Do Queiros 1031 | Jardines Universidad |
| 20100328 | 80 | 3 | Angel Yazid | Rivera Rodriguez | 2004-02-20 | H | 3318683156 | Avenidida San Blas 2605 | Parques de Santa Cruz del Valle |
| 20100335 | 120 | 3 | Mario Bernardo | Ponce Barrios | 0000-00-00 | H | 3323380639 | Nogal 256 | La Tuzania |
| 20100337 | 40 | 3 | Jessica Nicolette | Ramirez Cachua | 0000-00-00 | M | 3319648475 | Alonso de la Mota 1968 | Guadalupana |
| 20100342 | 40 | 3 | Luis Alfonso | Acosta Ortiz | 2003-12-10 | H | 3317115495 | Barcelona 1046 | Santa Alena Alcalde |
| 20100347 | 40 | 3 | Jorge Dante | Cruz Alejo | 2004-03-05 | H | 3311315337 | Alpes 1678 | Monumental |
| 20100360 | 120 | 3 | Luis Alejandro | Ruvalcaba Martinez | 0000-00-00 | H | 3314469549 | Jorge Bravo 1360 | Paseos del Sol |
+----------+-----------+---------+-------------------+--------------------+------------+------+------------+---------------------------------+---------------------------------+
16 rows in set (0.001 sec)
MariaDB [ceti]> Select Nombre, Apellido From Alumno Where Carrera IN (Select Clave From Carrera Where Nombre = 'Tecnologo en Desarrollo de Software');
+-------------------+--------------------+
| Nombre | Apellido |
+-------------------+--------------------+
| Maximiliano Agraz | Ledesma Fernandez |
| Joshua Keanu | Contreras Barajas |
| Enrique | Romero Castro |
| Luis Angel | Martinez Gonzalez |
| Daniel Alejandro | Orona Flores |
| Emilio | Gomez Breschi |
| Andre Thot | Mejia Valenzuela |
| Isaac Daniel | Chavez Chavez |
| Alvaro | Rosas Orozco |
...