MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 5 rows in set (0.001 sec) MariaDB [(none)]> create database Hospital; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | hospital | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.001 sec) MariaDB [(none)]> use hispital; ERROR 1049 (42000): Unknown database 'hispital' MariaDB [(none)]> use hospital; Database changed MariaDB [hospital]> CREATE TABLE Pacientes ( -> id_paciente INT PRIMARY KEY AUTO_INCREMENT, -> nombre VARCHAR(100) NOT NULL, -> fecha_nacimiento DATE NOT NULL, -> genero CHAR(1) NOT NULL, -> telefono VARCHAR(15), -> direccion VARCHAR(200) -> ); Query OK, 0 rows affected (0.013 sec) MariaDB [hospital]> DROP TABLE Pacientes; Query OK, 0 rows affected (0.050 sec) MariaDB [hospital]> CREATE TABLE Pacientes ( -> id_paciente Varchar(45) not null PRIMARY KEY, -> nombre VARCHAR(45) NOT NULL, -> genero VARCHAR(45) NOT NULL, -> telefono VARCHAR(45) NOT NULL, -> Email VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.025 sec) MariaDB [hospital]> describe pacientes; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | id_paciente | varchar(45) | NO | PRI | NULL | | | nombre | varchar(45) | NO | | NULL | | | genero | varchar(45) | NO | | NULL | | | telefono | varchar(45) | NO | | NULL | | | Email | varchar(45) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.019 sec) MariaDB [hospital]> CREATE TABLE Medicos ( -> id_medico Varchar(45) not null PRIMARY KEY, -> nombre VARCHAR(45) NOT NULL, -> especialidad VARCHAR(45) NOT NULL, -> telefono VARCHAR(45) NOT NULL, -> Email VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.014 sec) MariaDB [hospital]> describe MEDICOS; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | id_medico | varchar(45) | NO | PRI | NULL | | | nombre | varchar(45) | NO | | NULL | | | especialidad | varchar(45) | NO | | NULL | | | telefono | varchar(45) | NO | | NULL | | | Email | varchar(45) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.009 sec) MariaDB [hospital]> CREATE TABLE Plantas ( -> id_planta Varchar(45) not null PRIMARY KEY, -> nombre_planta VARCHAR(45) NOT NULL); Query OK, 0 rows affected (0.015 sec) MariaDB [hospital]> describe plantas; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_planta | varchar(45) | NO | PRI | NULL | | | nombre_planta | varchar(45) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.011 sec) MariaDB [hospital]> CREATE TABLE Ingresos ( -> id_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR(45) NOT NULL, -> fecha_alta VARCHAR(45) NOT NULL, -> FK_paciente varchar(45) not null, -> FK_planta varchar(45) not null, -> foreign key(FK_paciente) references pacientes(id_paciente) on delete cascade on update cascade, -> foreign key(FK_planta) references plantasCtrl-C -- exit!n delete casc Bye on update cascade, C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.4.32-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 hospital; Database changed MariaDB [hospital]> decribe plantas; 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 'decribe plantas' at line 1 MariaDB [hospital]> describe plantas; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_planta | varchar(45) | NO | PRI | NULL | | | nombre_planta | varchar(45) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 2 rows in set (0.014 sec) MariaDB [hospital]> CREATE TABLE Ingresos ( -> -> id_ingreso Varchar(45) not null PRIMARY KEY, -> -> fecha_ingreso VARCHAR(45) NOT NULL, -> -> fecha_alta VARCHAR(45) NOT NULL, -> -> FK_paciente varchar(45) not null, -> -> FK_planta varchar(45) not null, -> -> foreign key(FK_paciente) references pacientes(id_paciente) on delete -> cascade on update cascade,, -> ; 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 '-> id_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR...' at line 2 MariaDB [hospital]> CREATE TABLE Ingresos ( -> id_ingreso Varchar(45) not null PRIMARY KEY, -> fecha_ingreso VARCHAR(45) NOT NULL, -> fecha_alta VARCHAR(45) NOT NULL, -> FK_paciente varchar(45) not null, -> FK_planta varchar(45) not null, -> foreign key(FK_paciente) references pacientes(id_paciente) on delete cascade on update cascade, -> foreign key(FK_planta) references plantas(id_planta) on delete cascad e on update cascade); Query OK, 0 rows affected (0.031 sec) MariaDB [hospital]> describe ingresos; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | id_ingreso | varchar(45) | NO | PRI | NULL | | | fecha_ingreso | varchar(45) | NO | | NULL | | | fecha_alta | varchar(45) | NO | | NULL | | | FK_paciente | varchar(45) | NO | MUL | NULL | | | FK_planta | varchar(45) | NO | MUL | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.011 sec) MariaDB [hospital]> CREATE TABLE Asignaciones_Medicos ( -> id_asignacion Varchar(45) not null PRIMARY KEY, -> fecha_asignacion VARCHAR(45) NOT NULL, -> FK_ingreso varchar(45) not null, -> FK_medico varchar(45) not null, -> foreign key(FK_ingreso) references ingresos(id_ingreso) on delete cas cade on update cascade, -> foreign key(FK_medico) references medicos(id_medico) on delete cascad e on update cascade); Query OK, 0 rows affected (0.031 sec) MariaDB [hospital]> describe Asignaciones_Medicos; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | id_asignacion | varchar(45) | NO | PRI | NULL | | | fecha_asignacion | varchar(45) | NO | | NULL | | | FK_ingreso | varchar(45) | NO | MUL | NULL | | | FK_medico | varchar(45) | NO | MUL | NULL | | +------------------+-------------+------+-----+---------+-------+ 4 rows in set (0.013 sec) MariaDB [hospital]>