Microsoft Windows [Versión 10.0.19044.2130]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\USUARIO>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)]> create database zonadecargaBD;
Query OK, 1 row affected (0.002 sec)

MariaDB [(none)]> use zonadecargaBD;
Database changed
MariaDB [zonadecargaBD]> create table bodega(codbodega varchar(4) not null primary key,      
    -> nombre varchar(50) not null,     
    -> telefono varchar(10) not null,     
    -> email varchar (50) not null);
Query OK, 0 rows affected (0.008 sec)

MariaDB [zonadecargaBD]> create table aerolinea(codaerolinea varchar(4) not null primary key,      
    -> nombre varchar(50) not null);
Query OK, 0 rows affected (0.008 sec)

MariaDB [zonadecargaBD]> create table vuelo(codvuelo varchar(4) not null primary key,      
    -> destino varchar(50) not null,     
    -> hora time not null,
    -> codaerolinea varchar(4) not null,
    -> foreign key(codaerolinea) references aerolinea(codaerolinea) on delete cascade on update cascade);
Query OK, 0 rows affected (0.008 sec)

MariaDB [zonadecargaBD]> create table empresa_seguridad(codempresaseg varchar(4) not null primary key,      
    -> nombre varchar(50) not null);
Query OK, 0 rows affected (0.008 sec)

MariaDB [zonadecargaBD]> create table agencia(codagencia varchar(4) not null primary key,      
    -> nombre varchar(50) not null,     
    -> nivel varchar(1) not null);
Query OK, 0 rows affected (0.007 sec)

MariaDB [zonadecargaBD]> create table empleado(idempleado varchar(4) not null primary key,      
    -> nombre varchar(50) not null,     
    -> telefono varchar(10) not null,     
    -> email varchar (50) not null);
Query OK, 0 rows affected (0.007 sec)

MariaDB [zonadecargaBD]> create table bodeaeroseg
    -> (codbodega varchar(4) not null,
    ->  codempresaseg varchar(4) not null,
    -> codaerolinea varchar(4) not null,
    ->  foreign key(codbodega) references bodega(codbodega) on delete cascade on update cascade, foreign key(codempresaseg) references empresa_seguridad(codempresaseg) on delete cascade on update cascade, foreign key(codaerolinea) references aerolinea(codaerolinea) on delete cascade on update cascade);
Query OK, 0 rows affected (0.009 sec)

MariaDB [zonadecargaBD]> create table aeroage
    -> (codaerolinea varchar(4) not null,
    ->  codagencia varchar(4) not null,
    ->  foreign key(codaerolinea) references aerolinea(codaerolinea) on delete cascade on update cascade, foreign key(codagencia) references agencia(codagencia) on delete cascade on update cascade);
Query OK, 0 rows affected (0.009 sec)

MariaDB [zonadecargaBD]> create table agemp
    -> (codagencia varchar(4) not null,
    ->  idempleado varchar(4) not null,
    ->  foreign key(codagencia) references agencia(codagencia) on delete cascade on update cascade, foreign key(idempleado) references empleado(idempleado) on delete cascade on update cascade);
Query OK, 0 rows affected (0.009 sec)

MariaDB [zonadecargaBD]> show tables;
+-------------------------+
| Tables_in_zonadecargabd |
+-------------------------+
| aeroage                 |
| aerolinea               |
| agemp                   |
| agencia                 |
| bodeaeroseg             |
| bodega                  |
| empleado                |
| empresa_seguridad       |
| vuelo                   |
+-------------------------+
9 rows in set (0.002 sec)

MariaDB [zonadecargaBD]> describe bodega;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| codbodega | varchar(4)  | NO   | PRI | NULL    |       |
| nombre    | varchar(50) | NO   |     | NULL    |       |
| telefono  | varchar(10) | NO   |     | NULL    |       |
| email     | varchar(50) | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe aerolinea;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| codaerolinea | varchar(4)  | NO   | PRI | NULL    |       |
| nombre       | varchar(50) | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe empresa_seguridad;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codempresaseg | varchar(4)  | NO   | PRI | NULL    |       |
| nombre        | varchar(50) | NO   |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.003 sec)

MariaDB [zonadecargaBD]> describe vuelo;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| codvuelo     | varchar(4)  | NO   | PRI | NULL    |       |
| destino      | varchar(50) | NO   |     | NULL    |       |
| hora         | time        | NO   |     | NULL    |       |
| codaerolinea | varchar(4)  | NO   | MUL | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
4 rows in set (0.003 sec)

MariaDB [zonadecargaBD]> describe agencia;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| codagencia | varchar(4)  | NO   | PRI | NULL    |       |
| nombre     | varchar(50) | NO   |     | NULL    |       |
| nivel      | varchar(1)  | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe empleado;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| idempleado | varchar(4)  | NO   | PRI | NULL    |       |
| nombre     | varchar(50) | NO   |     | NULL    |       |
| telefono   | varchar(10) | NO   |     | NULL    |       |
| email      | varchar(50) | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe bodeaeroseg;
+---------------+------------+------+-----+---------+-------+
| Field         | Type       | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| codbodega     | varchar(4) | NO   | MUL | NULL    |       |
| codempresaseg | varchar(4) | NO   | MUL | NULL    |       |
| codaerolinea  | varchar(4) | NO   | MUL | NULL    |       |
+---------------+------------+------+-----+---------+-------+
3 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe aeroage;
+--------------+------------+------+-----+---------+-------+
| Field        | Type       | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| codaerolinea | varchar(4) | NO   | MUL | NULL    |       |
| codagencia   | varchar(4) | NO   | MUL | NULL    |       |
+--------------+------------+------+-----+---------+-------+
2 rows in set (0.004 sec)

MariaDB [zonadecargaBD]> describe agemp;
+------------+------------+------+-----+---------+-------+
| Field      | Type       | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| codagencia | varchar(4) | NO   | MUL | NULL    |       |
| idempleado | varchar(4) | NO   | MUL | NULL    |       |
+------------+------------+------+-----+---------+-------+
2 rows in set (0.003 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B01','Aerosan','3124567841','aerosan@correo.com');
Query OK, 1 row affected (0.005 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B02','Tampa','9634896214','tamap@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B03','Avianca','1254789632','avianca@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B04','Almaviva','7453209621','almaviva@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B05','Deprisa','3214580300','deorisa@correo.com');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B06','Fedex','2458963147','fedex@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B07','Girag','3419630583','girag@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B08','Bodegax','3366485520','bodegax@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B09','Bodegados','1597532549','bodegados@correo.com');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into bodega(codbodega, nombre, telefono, email) values('B10','bodegazo','3962410238','bodegazo@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES01','Longport');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES02','Securitas');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES03','Vise');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES04','SOS');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES05','Santillana');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES06','Miro');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES07','Dogman');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES08','Segucol');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES09','Foxpro');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empresa_seguridad(codempresaseg, nombre) values('ES10','Segupriv');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A01','Avianca');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A02','Vivaair');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A03','Latam');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A04','Copa');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A05','Aeromexico');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A06','Aireuropa');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A07','American');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A08','Jetblue');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A09','Spirit');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aerolinea(codaerolinea, nombre) values('A10','Ultra');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V01','Miami','03:00','A01');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V02','Madrid','18:00','A02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V03','San Jose','09:00','A03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V04','Lima','23:00','A04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V05','Panama','11:15','A05');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V06','New York','07:00','A06');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V07','San Juan','08:00','A07');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V08','Cancun','06:00','A08');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V09','Mexico','01:00','A01');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into vuelo(codvuelo, destino, hora, codaerolinea) values('V10','Montreal','15:15','A02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG01','Magnum','3');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG02','DSV','2');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG03','Malco','1');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG04','WorldCargo','3');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG05','DHL','2');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG06','Allincargo','1');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG07','MasterFreigth','3');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG08','KellyFreigth','2');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG09','Muñozcargo','1');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agencia(codagencia, nombre, nivel) values('AG10','Panalpina','2');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E01','Juan Rodriguez','9632145875','juan@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E02','Pepe Peralta','1265987501','pepe@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E03','Karen Martinez','3366559902','karen@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E04','Jose Hernandez','3214785203','jose@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E05','Estefania Perez','9517896321','estefa@correo.com');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E06','Alejandra Lopez','1593578520','alejandra@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E07','Camila Sanpedro','3520006980','camila@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E08','Kevin Jaramillo','3398713650','kevin@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E09','Viky Rivera','9635874120','viky@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into empleado(idempleado, nombre, telefono, email) values('E10','Sergio Ramos','9631578758','sergio@correo.com');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B01','ES01','A01');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B02','ES02','A02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B03','ES03','A03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B04','ES04','A04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B05','ES05','A02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B06','ES01','A03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B07','ES02','A07');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B08','ES08','A08');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B01','ES01','A02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into bodeaeroseg(codbodega, codempresaseg, codaerolinea) values('B02','ES02','A03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A01','AG01');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A02','AG02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A03','AG03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A04','AG04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A05','AG03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A06','AG04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A07','AG07');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A08','AG08');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A01','AG03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into aeroage(codaerolinea, codagencia) values('A02','AG04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG01','E01');
Query OK, 1 row affected (0.002 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG02','E02');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG03','E03');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG04','E04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG05','E05');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG06','E06');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG07','E07');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG08','E08');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG01','E04');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> insert into agemp(codagencia, idempleado) values('AG02','E05');
Query OK, 1 row affected (0.001 sec)

MariaDB [zonadecargaBD]> select * from bodega;
+-----------+-----------+------------+----------------------+
| codbodega | nombre    | telefono   | email                |
+-----------+-----------+------------+----------------------+
| B01       | Aerosan   | 3124567841 | aerosan@correo.com   |
| B02       | Tampa     | 9634896214 | tamap@correo.com     |
| B03       | Avianca   | 1254789632 | avianca@correo.com   |
| B04       | Almaviva  | 7453209621 | almaviva@correo.com  |
| B05       | Deprisa   | 3214580300 | deorisa@correo.com   |
| B06       | Fedex     | 2458963147 | fedex@correo.com     |
| B07       | Girag     | 3419630583 | girag@correo.com     |
| B08       | Bodegax   | 3366485520 | bodegax@correo.com   |
| B09       | Bodegados | 1597532549 | bodegados@correo.com |
| B10       | bodegazo  | 3962410238 | bodegazo@correo.com  |
+-----------+-----------+------------+----------------------+
10 rows in set (0.001 sec)

MariaDB [zonadecargaBD]> select * from aerolinea;
+--------------+------------+
| codaerolinea | nombre     |
+--------------+------------+
| A01          | Avianca    |
| A02          | Vivaair    |
| A03          | Latam      |
| A04          | Copa       |
| A05          | Aeromexico |
| A06          | Aireuropa  |
| A07          | American   |
| A08          | Jetblue    |
| A09          | Spirit     |
| A10          | Ultra      |
+--------------+------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from empresa_seguridad;
+---------------+------------+
| codempresaseg | nombre     |
+---------------+------------+
| ES01          | Longport   |
| ES02          | Securitas  |
| ES03          | Vise       |
| ES04          | SOS        |
| ES05          | Santillana |
| ES06          | Miro       |
| ES07          | Dogman     |
| ES08          | Segucol    |
| ES09          | Foxpro     |
| ES10          | Segupriv   |
+---------------+------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from vuelo;
+----------+----------+----------+--------------+
| codvuelo | destino  | hora     | codaerolinea |
+----------+----------+----------+--------------+
| V01      | Miami    | 03:00:00 | A01          |
| V02      | Madrid   | 18:00:00 | A02          |
| V03      | San Jose | 09:00:00 | A03          |
| V04      | Lima     | 23:00:00 | A04          |
| V05      | Panama   | 11:15:00 | A05          |
| V06      | New York | 07:00:00 | A06          |
| V07      | San Juan | 08:00:00 | A07          |
| V08      | Cancun   | 06:00:00 | A08          |
| V09      | Mexico   | 01:00:00 | A01          |
| V10      | Montreal | 15:15:00 | A02          |
+----------+----------+----------+--------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from agencia;
+------------+---------------+-------+
| codagencia | nombre        | nivel |
+------------+---------------+-------+
| AG01       | Magnum        | 3     |
| AG02       | DSV           | 2     |
| AG03       | Malco         | 1     |
| AG04       | WorldCargo    | 3     |
| AG05       | DHL           | 2     |
| AG06       | Allincargo    | 1     |
| AG07       | MasterFreigth | 3     |
| AG08       | KellyFreigth  | 2     |
| AG09       | Muñozcargo   | 1     |
| AG10       | Panalpina     | 2     |
+------------+---------------+-------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from empleado;
+------------+-----------------+------------+----------------------+
| idempleado | nombre          | telefono   | email                |
+------------+-----------------+------------+----------------------+
| E01        | Juan Rodriguez  | 9632145875 | juan@correo.com      |
| E02        | Pepe Peralta    | 1265987501 | pepe@correo.com      |
| E03        | Karen Martinez  | 3366559902 | karen@correo.com     |
| E04        | Jose Hernandez  | 3214785203 | jose@correo.com      |
| E05        | Estefania Perez | 9517896321 | estefa@correo.com    |
| E06        | Alejandra Lopez | 1593578520 | alejandra@correo.com |
| E07        | Camila Sanpedro | 3520006980 | camila@correo.com    |
| E08        | Kevin Jaramillo | 3398713650 | kevin@correo.com     |
| E09        | Viky Rivera     | 9635874120 | viky@correo.com      |
| E10        | Sergio Ramos    | 9631578758 | sergio@correo.com    |
+------------+-----------------+------------+----------------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from bodeaeroseg;
+-----------+---------------+--------------+
| codbodega | codempresaseg | codaerolinea |
+-----------+---------------+--------------+
| B01       | ES01          | A01          |
| B02       | ES02          | A02          |
| B03       | ES03          | A03          |
| B04       | ES04          | A04          |
| B05       | ES05          | A02          |
| B06       | ES01          | A03          |
| B07       | ES02          | A07          |
| B08       | ES08          | A08          |
| B01       | ES01          | A02          |
| B02       | ES02          | A03          |
+-----------+---------------+--------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from aeroage;
+--------------+------------+
| codaerolinea | codagencia |
+--------------+------------+
| A01          | AG01       |
| A02          | AG02       |
| A03          | AG03       |
| A04          | AG04       |
| A05          | AG03       |
| A06          | AG04       |
| A07          | AG07       |
| A08          | AG08       |
| A01          | AG03       |
| A02          | AG04       |
+--------------+------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> select * from agemp;
+------------+------------+
| codagencia | idempleado |
+------------+------------+
| AG01       | E01        |
| AG02       | E02        |
| AG03       | E03        |
| AG04       | E04        |
| AG05       | E05        |
| AG06       | E06        |
| AG07       | E07        |
| AG08       | E08        |
| AG01       | E04        |
| AG02       | E05        |
+------------+------------+
10 rows in set (0.000 sec)

MariaDB [zonadecargaBD]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p zonadecargaBD>c:/xampp/zonadecargaBD.sql
Enter password:

C:\xampp\mysql\bin>