MariaDB [(none)]> create database Parqueadero;
Query OK, 1 row affected (0.043 sec)

MariaDB [(none)]> show databases;
+-----------------------+
| Database              |
+-----------------------+
| information_schema    |
| institucion_educativa |
| libreria              |
| matricula             |
| matricula2            |
| mysql                 |
| parqueadero           |
| performance_schema    |
| phpmyadmin            |
| subconsultas          |
| taller2               |
| test                  |
| turismo               |
+-----------------------+
13 rows in set (0.166 sec)

MariaDB [(none)]> use parqueadero;
Database changed
MariaDB [parqueadero]> create table clientes
    -> (documento_cliente varchar(15) not null primary key,
    -> nombre varchar(50) not null,
    -> email varchar(50) not null,
    -> telefono varchar(15) not null);
Query OK, 0 rows affected (0.338 sec)

MariaDB [parqueadero]> create table vehiculos
    -> (placa varchar(15) not null primary key,
    -> marca varchar(50) not null,
    -> tipo varchar(50) not null);
Query OK, 0 rows affected (0.307 sec)

MariaDB [parqueadero]> create table empleados
    -> (documento_empleado varchar(15) not null primary key,
    -> nombre varchar(50) not null,
    -> cargo varchar(20) not null,
    -> edad int not null,
    -> telefono varchar(15) not null,
    -> email varchar(50) not null,
    -> tipo_sangre varchar(5) not null);
Query OK, 0 rows affected (0.994 sec)

MariaDB [parqueadero]> create table turnos
    -> (cod_turno varchar(10) not null,
    -> comienzo_turno time not null,
    -> final turno time not null);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'turno time not null)' at line 4
MariaDB [parqueadero]> create table turnos
    -> (cod_turno varchar(10) not null,
    -> comienzo_turno time not null,
    -> final_turno time not null);
Query OK, 0 rows affected (0.599 sec)

MariaDB [parqueadero]> create table nomina_empleados
    -> (cod_nomina varchar(5) not null primary key,
    -> valor_nomina float not null,
    -> dia_nomina date not null);
Query OK, 0 rows affected (0.267 sec)

MariaDB [parqueadero]> create table clientes_vehiculos
    -> (documento_cliente varchar(15) not null,
    -> placa varchar(10) not null,
    -> foreign key(documento_cliente) references clientes(documento_cliente) on delete cascade on update cascade,
    -> foreign key(placa) references vehiculos(placa) on delete cascade on update cascade);
Query OK, 0 rows affected (0.431 sec)

MariaDB [parqueadero]> create table registros
    -> (documento_cliente varchar(15) not null,
    -> placa varchar(10) not null,
    -> documento_empleado varchar(15) not null,
    -> hora_entrada time not null,
    -> hora_salid time not null,
    -> valor_mensualidd float not null,
    -> valor_pagar float not null,
    -> foreign key(documento_cliente) references clientes(documento_cliente) on delete cascade on update cascade,
    -> foreign key(placa) references vehiculos(placa) on delete cascade on update cascade,
    -> foreign key(documento_empleado) references empleados(documento_empleado) on delete cascade on update cascade);
Query OK, 0 rows affected (0.981 sec)

MariaDB [parqueadero]> create table turnos_empleados
    -> (cod_turno varchar(10) not null,
    -> documento_empleado varchar(15) not null,
    -> foreign key(cod_turno) references turnos(cod_turno) on delete cascade on update cascade,
    -> foreign key(documento_empleado) references empleados(documento_empleado) on delete cascade on update cascade);
ERROR 1005 (HY000): Can't create table `parqueadero`.`turnos_empleados` (errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [parqueadero]> show tables;
+-----------------------+
| Tables_in_parqueadero |
+-----------------------+
| clientes              |
| clientes_vehiculos    |
| empleados             |
| nomina_empleados      |
| registros             |
| turnos                |
| vehiculos             |
+-----------------------+
7 rows in set (0.002 sec)

MariaDB [parqueadero]> describe empleados;
+--------------------+-------------+------+-----+---------+-------+
| Field              | Type        | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| documento_empleado | varchar(15) | NO   | PRI | NULL    |       |
| nombre             | varchar(50) | NO   |     | NULL    |       |
| cargo              | varchar(20) | NO   |     | NULL    |       |
| edad               | int(11)     | NO   |     | NULL    |       |
| telefono           | varchar(15) | NO   |     | NULL    |       |
| email              | varchar(50) | NO   |     | NULL    |       |
| tipo_sangre        | varchar(5)  | NO   |     | NULL    |       |
+--------------------+-------------+------+-----+---------+-------+
7 rows in set (0.009 sec)

MariaDB [parqueadero]> describe turnos;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| cod_turno      | varchar(10) | NO   |     | NULL    |       |
| comienzo_turno | time        | NO   |     | NULL    |       |
| final_turno    | time        | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
3 rows in set (0.009 sec)

MariaDB [parqueadero]> drop table turnos;
Query OK, 0 rows affected (0.701 sec)

MariaDB [parqueadero]> create table turnos
    -> (cod_turno varchar(10) not null primary key,
    -> comienzo_turno time not null,
    -> final_turno time not null);
Query OK, 0 rows affected (0.343 sec)

MariaDB [parqueadero]> describe turnos;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| cod_turno      | varchar(10) | NO   | PRI | NULL    |       |
| comienzo_turno | time        | NO   |     | NULL    |       |
| final_turno    | time        | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
3 rows in set (0.008 sec)

MariaDB [parqueadero]> create table turnos_empleados
    -> (cod_turno varchar(10) not null,
    -> documento_empleado varchar(15) not null,
    -> foreign key(cod_turno) references turnos(cod_turno) on delete cascade on update cascade,
    -> foreign key(documento_empleado) references empleados(documento_empleado) on delete cascade on update cascade);
Query OK, 0 rows affected (0.646 sec)

MariaDB [parqueadero]> create table empleados_nominaempleados
    -> (documento_empleado varchar(15) not null,
    -> cod_nomina varchar(5) not null,
    -> foreign key(documento_empleado) references empleados(documento_empleado) on delete cascade  on update cascade,
    -> foreign key(cod_nomina) references nomina_empleados(cod_nomina) on delete cascade on update cascade);
Query OK, 0 rows affected (0.553 sec)

MariaDB [parqueadero]> show tables;
+---------------------------+
| Tables_in_parqueadero     |
+---------------------------+
| clientes                  |
| clientes_vehiculos        |
| empleados                 |
| empleados_nominaempleados |
| nomina_empleados          |
| registros                 |
| turnos                    |
| turnos_empleados          |
| vehiculos                 |
+---------------------------+
9 rows in set (0.002 sec)

MariaDB [parqueadero]> exit