mysql> create database matriculas;
Query OK, 1 row affected (0.02 sec)

mysql> use matriculas;
Database changed
mysql> create table acudientes
    -> (codigo_acudiente char(5) not null primary key,
    -> nombre char(60) not null)engine=innobd;
Query OK, 0 rows affected, 2 warnings (0.06 sec)

mysql> create table estudiantes
    -> (codigo_estudiante char(5) not null primary key,
    -> nombre char(60) not null,
    -> direccion char(50) not null,
    -> telefono int(10) not null,
    -> email char(60) null)engine=innodb;
Query OK, 0 rows affected (0.07 sec)

mysql> create table materias
    -> (codigo_materia char(5) not null primary key,
    -> nombre char(60) not null)engine=innodb;
Query OK, 0 rows affected (0.05 sec)

mysql> create table docentes
    -> (codigo_docente char(5) not null primary key,
    -> nombre char(60) not null,
    -> telefono int(10) not null,
    -> email char(60) null)engine=innodb;
Query OK, 0 rows affected (0.07 sec)

mysql> show tables;
+----------------------+
| Tables_in_matriculas |
+----------------------+
| acudientes           |
| docentes             |
| estudiantes          |
| materias             |
+----------------------+
4 rows in set (0.00 sec)

mysql> describe acudientes;
+------------------+----------+------+-----+---------+-------+
| Field            | Type     | Null | Key | Default | Extra |
+------------------+----------+------+-----+---------+-------+
| codigo_acudiente | char(5)  | NO   | PRI | NULL    |       |
| nombre           | char(60) | NO   |     | NULL    |       |
+------------------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> create table estudiante_acudiente
    -> (codigo_estudiante char(5) not null,
    -> codigo_acudiente char(5) not null,
    -> foreign key(codigo_estudiante) references estudiantes(codigo_estudiante) on delete cascade on update cascade,
    -> foreign key(codigo_acudiente) references acudientes(codigo_acudiente) on delete cascade on update cascade)engine=innodb;
Query OK, 0 rows affected (0.09 sec)

mysql> create table materia_estudiante
    -> (codigo_materia char(5) not null,
    -> codigo_estudiante char(5) not null,
    -> foreign key(codigo_materia) references materias(codigo_materia) on delete cascade on update cascade,
    -> foreign key(codigo_estudiante) references estudiantes(codigo_estudiante) on delete cascade on update cascade)engine=innodb;
Query OK, 0 rows affected (0.07 sec)

mysql> create table docente_materia
    -> (codigo_docente char(5) not null,
    -> codigo_materia char(5) not null,
    -> foreign key(codigo_docente) references docentes(codigo_docente) on delete cascade on update cascade,
    -> foreign key(codigo_materia) references materias(codigo_materia) on delete cascade on update cascade)engine=innodb;
Query OK, 0 rows affected (0.10 sec)

mysql> show tables;
+----------------------+
| Tables_in_matriculas |
+----------------------+
| acudientes           |
| docente_materia      |
| docentes             |
| estudiante_acudiente |
| estudiantes          |
| materia_estudiante   |
| materias             |
+----------------------+
7 rows in set (0.00 sec)

mysql> describe acudientes;
+------------------+----------+------+-----+---------+-------+
| Field            | Type     | Null | Key | Default | Extra |
+------------------+----------+------+-----+---------+-------+
| codigo_acudiente | char(5)  | NO   | PRI | NULL    |       |
| nombre           | char(60) | NO   |     | NULL    |       |
+------------------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> insert into acudientes(codigo_acudiente,nombre) values("acu01","Sonia Jimena");
Query OK, 1 row affected (0.02 sec)

mysql> insert into acudientes(codigo_acudiente,nombre) values("acu02","Pablo Suarez");
Query OK, 1 row affected (0.02 sec)

mysql> insert into acudientes(codigo_acudiente,nombre) values("acu03","Milena Patricia Pe¤a");
Query OK, 1 row affected (0.03 sec)

mysql> select * from acudientes;
+------------------+----------------------+
| codigo_acudiente | nombre               |
+------------------+----------------------+
| acu01            | Sonia Jimena         |
| acu02            | Pablo Suarez         |
| acu03            | Milena Patricia Pe¤a |
+------------------+----------------------+
3 rows in set (0.00 sec)

mysql> describe materias;
+----------------+----------+------+-----+---------+-------+
| Field          | Type     | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+-------+
| codigo_materia | char(5)  | NO   | PRI | NULL    |       |
| nombre         | char(60) | NO   |     | NULL    |       |
+----------------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> insert into materias(codigo_materia,nombre) values("mat01","Espa¤ol");
Query OK, 1 row affected (0.02 sec)

mysql> insert into materias(codigo_materia,nombre) values("mat02","Sociales");
Query OK, 1 row affected (0.02 sec)

mysql> insert into materias(codigo_materia,nombre) values("mat03","Etica");
Query OK, 1 row affected (0.02 sec)

mysql> select * from materias;
+----------------+----------+
| codigo_materia | nombre   |
+----------------+----------+
| mat01          | Espa¤ol  |
| mat02          | Sociales |
| mat03          | Etica    |
+----------------+----------+
3 rows in set (0.00 sec)

mysql> describe docentes;
+----------------+----------+------+-----+---------+-------+
| Field          | Type     | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+-------+
| codigo_docente | char(5)  | NO   | PRI | NULL    |       |
| nombre         | char(60) | NO   |     | NULL    |       |
| telefono       | int(10)  | NO   |     | NULL    |       |
| email          | char(60) | YES  |     | NULL    |       |
+----------------+----------+------+-----+---------+-------+
4 rows in set (0.01 sec)

mysql> insert into docentes(codigo_docente,nombre,telefono,email) values("doc01","Julio Bernal",2113546,"jube@remington.edu.co");
Query OK, 1 row affected (0.02 sec)

mysql> insert into docentes(codigo_docente,nombre,telefono,email) values("doc02","Javier Ospina",3107254158,"viejovavi@remington.edu.co");
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql> insert into docentes(codigo_docente,nombre,telefono,email) values("doc03","carolina Rodriguez",3125412,"caro@hotmail.com");
Query OK, 1 row affected (0.03 sec)

mysql> select * from docentes;
+----------------+--------------------+------------+----------------------------+
| codigo_docente | nombre             | telefono   | email                      |
+----------------+--------------------+------------+----------------------------+
| doc01          | Julio Bernal       |    2113546 | jube@remington.edu.co      |
| doc02          | Javier Ospina      | 2147483647 | viejovavi@remington.edu.co |
| doc03          | carolina Rodriguez |    3125412 | caro@hotmail.com           |
+----------------+--------------------+------------+----------------------------+
3 rows in set (0.00 sec)

mysql> describe estudiantes;
+-------------------+----------+------+-----+---------+-------+
| Field             | Type     | Null | Key | Default | Extra |
+-------------------+----------+------+-----+---------+-------+
| codigo_estudiante | char(5)  | NO   | PRI | NULL    |       |
| nombre            | char(60) | NO   |     | NULL    |       |
| direccion         | char(50) | NO   |     | NULL    |       |
| telefono          | int(10)  | NO   |     | NULL    |       |
| email             | char(60) | YES  |     | NULL    |       |
+-------------------+----------+------+-----+---------+-------+
5 rows in set (0.01 sec)

mysql> insert into estudiantes(codigo_estudiante,nombre,direccion,telefono,email) values("est01","Santiago Lopez","Cll 15 # 25 - 30",2547895,"salo@colegio.com");
Query OK, 1 row affected (0.04 sec)

mysql> insert into estudiantes(codigo_estudiante,nombre,direccion,telefono,email) values("est02","Melani Suarez","Cra 20 # 15 - 46",3152458745,"melona@hotmail.com");
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql> insert into estudiantes(codigo_estudiante,nombre,direccion,telefono,email) values("est03","Carlos Mario Oquendo","Cll 5 # 32 - 20",2145368742,"camaque@hotmail.com");
Query OK, 1 row affected (0.02 sec)

mysql> select * from estudiantes;
+-------------------+----------------------+------------------+------------+---------------------+
| codigo_estudiante | nombre               | direccion        | telefono   | email               |
+-------------------+----------------------+------------------+------------+---------------------+
| est01             | Santiago Lopez       | Cll 15 # 25 - 30 |    2547895 | salo@colegio.com    |
| est02             | Melani Suarez        | Cra 20 # 15 - 46 | 2147483647 | melona@hotmail.com  |
| est03             | Carlos Mario Oquendo | Cll 5 # 32 - 20  | 2145368742 | camaque@hotmail.com |
+-------------------+----------------------+------------------+------------+---------------------+
3 rows in set (0.00 sec)

mysql> exit