API tools faq
paste
Advertisement
alvarovaca

BBDD Viajes MySQL

alvarovaca
Dec 6th, 2020
274
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.47 KB | None | 0 0
raw download clone embed print report diff
  1. -- La base de datos es bastante simple, pues se almacena información sobre los empleados de una empresa de tecnología, junto a una serie de viajes que se han realizado por motivos laborales, almacenando en una tabla intermedia resultante de una cardinalidad N:N los viajes a los que han acudido cada uno de ellos.
  2.  
  3. MariaDB [bd_viajes]> CREATE TABLE Empleados
  4.     -> (
  5.     -> DNI             VARCHAR(9),
  6.     -> Nombre          VARCHAR(30),
  7.     -> Direccion       VARCHAR(25),
  8.     -> Telefono        VARCHAR(9),
  9.     -> FechaNacimiento DATE,
  10.     -> CONSTRAINT pk_empleados PRIMARY KEY (DNI),
  11.     -> CONSTRAINT nombrerelleno CHECK (Nombre IS NOT NULL)
  12.     -> );
  13. Query OK, 0 rows affected, 1 warning (0.379 sec)
  14.  
  15. MariaDB [bd_viajes]> INSERT INTO Empleados
  16.     -> VALUES ('90389058R', 'Joaquin Marrero Covas', 'C/ Hijuela de Lojo, 22', '618385118', STR_TO_DATE('1997-01-28', '%Y-%m-%d'));
  17. Query OK, 1 row affected (0.352 sec)
  18.  
  19. MariaDB [bd_viajes]> INSERT INTO Empleados
  20.     -> VALUES ('18232747A', 'Aristarco Caban Meraz', 'Puerta Nueva, 67', '691204722', STR_TO_DATE('1994-05-07', '%Y-%m-%d'));
  21. Query OK, 1 row affected (0.343 sec)
  22.  
  23. MariaDB [bd_viajes]> INSERT INTO Empleados
  24.     -> VALUES ('94106513N', 'Marian Fonseca Betancourt', 'C/ Manuel Iradier, 37', '638415823', STR_TO_DATE('1979-07-17', '%Y-%m-%d'));
  25. Query OK, 1 row affected (0.002 sec)
  26.  
  27. MariaDB [bd_viajes]> INSERT INTO Empleados
  28.     -> VALUES ('12777631G', 'Merlino Rosado Cordero', 'C/ Henan Cortes, 58', '609841755', STR_TO_DATE('1993-11-27', '%Y-%m-%d'));
  29. Query OK, 1 row affected (0.005 sec)
  30.  
  31. MariaDB [bd_viajes]> INSERT INTO Empleados
  32.     -> VALUES ('68219319P', 'Tabare Chapa Alcantar', 'C/ Arana, 12', '682227206', STR_TO_DATE('1992-03-09', '%Y-%m-%d'));
  33. Query OK, 1 row affected (0.095 sec)
  34.  
  35. MariaDB [bd_viajes]> INSERT INTO Empleados
  36.     -> VALUES ('67227129S', 'Ian Esquivel Laboy', 'C/ Inglaterra, 64', '728005136', STR_TO_DATE('1992-07-21', '%Y-%m-%d'));
  37. Query OK, 1 row affected (0.006 sec)
  38.  
  39. MariaDB [bd_viajes]> INSERT INTO Empleados
  40.     -> VALUES ('52315160G', 'Heinz Collado Caraballo', 'Escuadro, 60', '600173822', STR_TO_DATE('1984-02-13', '%Y-%m-%d'));
  41. Query OK, 1 row affected (0.004 sec)
  42.  
  43. MariaDB [bd_viajes]> INSERT INTO Empleados
  44.     -> VALUES ('85145590G', 'Anabel Lerma Dominguez', 'Crta. Cadiz, 1', '675014823', STR_TO_DATE('1981-01-07', '%Y-%m-%d'));
  45. Query OK, 1 row affected (0.096 sec)
  46.  
  47. MariaDB [bd_viajes]> INSERT INTO Empleados
  48.     -> VALUES ('56228957Y', 'Dinorah Viera Tello', 'Ctra. Villena, 22', '642852778', STR_TO_DATE('1987-05-28', '%Y-%m-%d'));
  49. Query OK, 1 row affected (0.013 sec)
  50.  
  51. MariaDB [bd_viajes]> INSERT INTO Empleados
  52.     -> VALUES ('61242562W', 'Manases Castillo Camacho', 'Ctra. Hornos, 91', '607853354', STR_TO_DATE('1991-10-29', '%Y-%m-%d'));
  53. Query OK, 1 row affected (0.005 sec)
  54.  
  55. MariaDB [bd_viajes]> CREATE TABLE Viajes
  56.     -> (
  57.     -> Identificador   VARCHAR(5),
  58.     -> Destino         VARCHAR(15),
  59.     -> Duracion        INTEGER(2),
  60.     -> Precio          INTEGER(4),
  61.     -> Motivo          VARCHAR(50),
  62.     -> CONSTRAINT pk_viajes PRIMARY KEY (Identificador),
  63.     -> CONSTRAINT destinorelleno CHECK (Destino IS NOT NULL)
  64.     -> );
  65. Query OK, 0 rows affected, 1 warning (0.376 sec)
  66.  
  67. MariaDB [bd_viajes]> INSERT INTO Viajes
  68.     -> VALUES ('A-001', 'Barcelona', 5, 1540, 'Montaje de equipos de oficina.');
  69. Query OK, 1 row affected (0.105 sec)
  70.  
  71. MariaDB [bd_viajes]> INSERT INTO Viajes
  72.     -> VALUES ('A-002', 'Islandia', 10, 3420, 'Mantenimiento granja de servidores.');
  73. Query OK, 1 row affected (0.007 sec)
  74.  
  75. MariaDB [bd_viajes]> INSERT INTO Viajes
  76.     -> VALUES ('A-003', 'Japon', 13, 4270, 'Arreglar fallo de conexion.');
  77. Query OK, 1 row affected (0.006 sec)
  78.  
  79. MariaDB [bd_viajes]> INSERT INTO Viajes
  80.     -> VALUES ('A-004', 'Noruega', 8, 3010, 'Instalacion de cableado.');
  81. Query OK, 1 row affected (0.011 sec)
  82.  
  83. MariaDB [bd_viajes]> INSERT INTO Viajes
  84.     -> VALUES ('A-005', 'Indonesia', 9, 2130, 'Reestablecimiento de servidores tras ataque DDoS.');
  85. Query OK, 1 row affected (0.005 sec)
  86.  
  87. MariaDB [bd_viajes]> CREATE TABLE ViajesPorEmpleado
  88.     -> (
  89.     -> DNIEmpleado     VARCHAR(9),
  90.     -> IDViaje         VARCHAR(5),
  91.     -> CONSTRAINT pk_viajesporempleado PRIMARY KEY (DNIEmpleado, IDViaje),
  92.     -> CONSTRAINT fk_empleados FOREIGN KEY (DNIEmpleado) REFERENCES Empleados(DNI),
  93.     -> CONSTRAINT fk_viajes FOREIGN KEY (IDViaje) REFERENCES Viajes(Identificador)
  94.     -> );
  95. Query OK, 0 rows affected, 1 warning (0.166 sec)
  96.  
  97. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  98.     -> VALUES ('90389058R', 'A-002');
  99. Query OK, 1 row affected (0.341 sec)
  100.  
  101. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  102.     -> VALUES ('90389058R', 'A-003');
  103. Query OK, 1 row affected (0.006 sec)
  104.  
  105. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  106.     -> VALUES ('90389058R', 'A-005');
  107. Query OK, 1 row affected (0.013 sec)
  108.  
  109. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  110.     -> VALUES ('18232747A', 'A-001');
  111. Query OK, 1 row affected (0.009 sec)
  112.  
  113. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  114.     -> VALUES ('18232747A', 'A-005');
  115. Query OK, 1 row affected (0.005 sec)
  116.  
  117. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  118.     -> VALUES ('94106513N', 'A-004');
  119. Query OK, 1 row affected (0.010 sec)
  120.  
  121. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  122.     -> VALUES ('12777631G', 'A-002');
  123. Query OK, 1 row affected (0.257 sec)
  124.  
  125. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  126.     -> VALUES ('12777631G', 'A-001');
  127. Query OK, 1 row affected (0.101 sec)
  128.  
  129. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  130.     -> VALUES ('67227129S', 'A-005');
  131. Query OK, 1 row affected (0.005 sec)
  132.  
  133. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  134.     -> VALUES ('52315160G', 'A-005');
  135. Query OK, 1 row affected (0.010 sec)
  136.  
  137. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  138.     -> VALUES ('52315160G', 'A-003');
  139. Query OK, 1 row affected (0.003 sec)
  140.  
  141. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  142.     -> VALUES ('52315160G', 'A-004');
  143. Query OK, 1 row affected (0.003 sec)
  144.  
  145. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  146.     -> VALUES ('85145590G', 'A-002');
  147. Query OK, 1 row affected (0.004 sec)
  148.  
  149. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  150.     -> VALUES ('85145590G', 'A-001');
  151. Query OK, 1 row affected (0.105 sec)
  152.  
  153. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  154.     -> VALUES ('56228957Y', 'A-004');
  155. Query OK, 1 row affected (0.003 sec)
  156.  
  157. MariaDB [bd_viajes]> INSERT INTO ViajesPorEmpleado
  158.     -> VALUES ('56228957Y', 'A-001');
  159. Query OK, 1 row affected (0.004 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!