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

MariaDB [(none)]> create table DOCENTE(cod_docente varchar(10) not null primary key, nom_docente varchar(50) not null, telefono varchar(10) not null, email varchar(30) not null);
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use matricula;
Database changed
MariaDB [matricula]> create table DOCENTE(cod_docente varchar(10) not null primary key, nom_docente varchar(50) not null, telefono varchar(10) not null, email varchar(30) not null);
Query OK, 0 rows affected (0.16 sec)

MariaDB [matricula]> create table MATERIA(cod_materia varchar(10) not null primary key, nom_materia varchar(50) not null, intensidadh int not null, creditos int not null);
Query OK, 0 rows affected (0.11 sec)

MariaDB [matricula]> create table ESTUDIANTE(cod_estudiante varchar(10) not null primary key, nom_estudiante varchar(50) not null, direccion varchar(50) not null, telefono varchar(20) not null, email varchar (50) not null);
Query OK, 0 rows affected (0.19 sec)

MariaDB [matricula]> create table ACUDIENTE(cedula_acu varchar(10) not null primary key, nom_acudiente varchar(50) not null, direccion varchar(50) not null, telefono varchar(20) not null);
Query OK, 0 rows affected (0.14 sec)

MariaDB [matricula]> create table DOC_MATERIAS(cod_docente varchar(10) not null, cod_materia varchar(10) not null, foreign key(cod_docente) references DOCENTE(cod_docente) on delete cascade on update cascade, foreign key(cod_materia) references MATERIA(cod_materia) on delete cascade on update cascade);
Query OK, 0 rows affected (0.13 sec)

MariaDB [matricula]> create table MATERIA_EST(cod_estudiante) varchar(10) not null, cod_materia varchar(10) not null, foreign key(cod_estudiante) references ESTUDIANTE(cod_estudiante) on delete cascade on update cascade, foreign key(cod_materia) references MATERIA(cod_materia) 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 ') varchar(10) not null, cod_materia varchar(10) not null, foreign key(cod_estudi' at line 1
MariaDB [matricula]> create table MATERIA_EST(cod_estudiante varchar(10) not null, cod_materia varchar(10) not null, foreign key(cod_estudiante) references ESTUDIANTE(cod_estudiante) on delete cascade on update cascade, foreign key(cod_materia) references MATERIA(cod_materia) on delete cascade on update cascade);
Query OK, 0 rows affected (0.20 sec)

MariaDB [matricula]> create table ESTUD_ACUDI(cod_estudiante varchar(10) not null, cedula_acu varchar(10) not null, foreign key(cod_estudiante) references ESTUDIANTE(cod_estudiante) on delete cascade on update cascade, foreign key(cedula_acu) references ACUDIENTE(cedula_acu) on delete cascade on update cascade);
Query OK, 0 rows affected (0.13 sec)

MariaDB [matricula]> show tables;
+---------------------+
| Tables_in_matricula |
+---------------------+
| acudiente           |
| doc_materias        |
| docente             |
| estud_acudi         |
| estudiante          |
| materia             |
| materia_est         |
+---------------------+
7 rows in set (0.03 sec)

MariaDB [matricula]> describe acudiente;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| cedula_acu    | varchar(10) | NO   | PRI | NULL    |       |
| nom_acudiente | varchar(50) | NO   |     | NULL    |       |
| direccion     | varchar(50) | NO   |     | NULL    |       |
| telefono      | varchar(20) | NO   |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

MariaDB [matricula]> describe doc_materias;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| cod_docente | varchar(10) | NO   | MUL | NULL    |       |
| cod_materia | varchar(10) | NO   | MUL | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)

MariaDB [matricula]> describe materia;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| cod_materia | varchar(10) | NO   | PRI | NULL    |       |
| nom_materia | varchar(50) | NO   |     | NULL    |       |
| intensidadh | int(11)     | NO   |     | NULL    |       |
| creditos    | int(11)     | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

MariaDB [matricula]> describe docente;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| cod_docente | varchar(10) | NO   | PRI | NULL    |       |
| nom_docente | varchar(50) | NO   |     | NULL    |       |
| telefono    | varchar(10) | NO   |     | NULL    |       |
| email       | varchar(30) | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

MariaDB [matricula]> describe estud_acudi;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| cod_estudiante | varchar(10) | NO   | MUL | NULL    |       |
| cedula_acu     | varchar(10) | NO   | MUL | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MariaDB [matricula]> describe estudiante;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| cod_estudiante | varchar(10) | NO   | PRI | NULL    |       |
| nom_estudiante | varchar(50) | NO   |     | NULL    |       |
| direccion      | varchar(50) | NO   |     | NULL    |       |
| telefono       | varchar(20) | NO   |     | NULL    |       |
| email          | varchar(50) | NO   |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
5 rows in set (0.02 sec)

MariaDB [matricula]> describe materia_est;
+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| cod_estudiante | varchar(10) | NO   | MUL | NULL    |       |
| cod_materia    | varchar(10) | NO   | MUL | NULL    |       |
+----------------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)

MariaDB [matricula]> exit