Microsoft Windows [Versión 10.0.17763.316]
(c) 2018 Microsoft Corporation. Todos los derechos reservados.

C:\Users\CLINICANU-501.CLINICADELNORTE>cd/xampp/mysql/bin

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.38-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)]> tee C:/xampp/ParcialBD01mysql.txt
Logging to file 'C:/xampp/ParcialBD01mysql.txt'
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
5 rows in set (0.00 sec)

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

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| matricula          |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.00 sec)

MariaDB [(none)]> use matricula;
Database changed
MariaDB [matricula]> show tables;
Empty set (0.00 sec)

MariaDB [matricula]> create table estudiante
    -> (codestudiante varchar(10) not null primary key,
    -> Nombre varchar(45) not null,
    -> Direccion varchar(45) not null,
    -> Telefono varchar(10) not null,
    -> Acudiente varchar(45) not null,
    -> Email varchar(45) null);
Query OK, 0 rows affected (0.15 sec)

MariaDB [matricula]> describe estudiante;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codestudiante | varchar(10) | NO   | PRI | NULL    |       |
| Nombre        | varchar(45) | NO   |     | NULL    |       |
| Direccion     | varchar(45) | NO   |     | NULL    |       |
| Telefono      | varchar(10) | NO   |     | NULL    |       |
| Acudiente     | varchar(45) | NO   |     | NULL    |       |
| Email         | varchar(45) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

Database changed
MariaDB [matricula]> describe estudiante;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codestudiante | varchar(10) | NO   | PRI | NULL    |       |
| Nombre        | varchar(45) | NO   |     | NULL    |       |
| Direccion     | varchar(45) | NO   |     | NULL    |       |
| Telefono      | varchar(10) | NO   |     | NULL    |       |
| Acudiente     | varchar(45) | NO   |     | NULL    |       |
| Email         | varchar(45) | YES  |     | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

MariaDB [matricula]> create table acudiente
    -> (codacudiente varchar(10)not null primary key,
    -> nombre varchar(45)not null,
    -> telefono varchar(10)not null,
    -> direccion varchar(45) not null,
    -> email varchar(40)null);
Query OK, 0 rows affected (0.21 sec)

MariaDB [matricula]> show tables;
+---------------------+
| Tables_in_matricula |
+---------------------+
| acudiente           |
| estudiante          |
+---------------------+
2 rows in set (0.00 sec)

MariaDB [matricula]> describe acudiente;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| codacudiente | varchar(10) | NO   | PRI | NULL    |       |
| nombre       | varchar(45) | NO   |     | NULL    |       |
| telefono     | varchar(10) | NO   |     | NULL    |       |
| direccion    | varchar(45) | NO   |     | NULL    |       |
| email        | varchar(40) | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

MariaDB [matricula]> create table docente
    -> (coddocente varchar(10)not null primary key,
    -> nombre varchar(45)not null,
    -> telefono varchar(10)not null,
    -> email varchar(45)not null);
Query OK, 0 rows affected (0.15 sec)

MariaDB [matricula]> show tables;
+---------------------+
| Tables_in_matricula |
+---------------------+
| acudiente           |
| docente             |
| estudiante          |
+---------------------+
3 rows in set (0.00 sec)

MariaDB [matricula]> describe docente;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| coddocente | varchar(10) | NO   | PRI | NULL    |       |
| nombre     | varchar(45) | NO   |     | NULL    |       |
| telefono   | varchar(10) | NO   |     | NULL    |       |
| email      | varchar(45) | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)

MariaDB [matricula]> create table materia
    -> (codmateria varchar(5)not null primary key,
    -> nombre varchar(45)not null);
Query OK, 0 rows affected (0.16 sec)

MariaDB [matricula]> show tables;
+---------------------+
| Tables_in_matricula |
+---------------------+
| acudiente           |
| docente             |
| estudiante          |
| materia             |
+---------------------+
4 rows in set (0.00 sec)

MariaDB [matricula]> describe materia;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| codmateria | varchar(5)  | NO   | PRI | NULL    |       |
| nombre     | varchar(45) | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

MariaDB [matricula]> create table estudiante_acudiente
    -> (codestudiante varchar(10)not null,
    -> codacudiente varchar(10)not null,
    -> foreign key(codestudiante) references estudiante(codestudiante)on delete cascade on update cascade,
    -> foreign key(codacudiente) references acudiente(codacudiente)on delete cascade on update cascade);
Query OK, 0 rows affected (0.53 sec)

MariaDB [matricula]> describe estudiante_acudiente;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codestudiante | varchar(10) | NO   | MUL | NULL    |       |
| codacudiente  | varchar(10) | NO   | MUL | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

MariaDB [matricula]> create table docente_materia
    -> (coddocente varchar(10)not null,
    -> codmateria varchar(5)not null,
    -> foreign key(coddocente) references docente(coddocente)on delete cascade on update cascade);
Query OK, 0 rows affected (0.29 sec)

MariaDB [matricula]> create table estudiante_materia
    -> (codestudiante varchar(10)not null,
    -> codmateria varchar(5) not null,
    -> foreign key(codestudiante) references estudiante(codestudiante)on delete cascade on update cascade,
    -> foreign key(codmateria) references materia(codmateria)on delete cascade on update cascade);
Query OK, 0 rows affected (0.25 sec)

MariaDB [matricula]> describe estudiante_materia;
+---------------+-------------+------+-----+---------+-------+
| Field         | Type        | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| codestudiante | varchar(10) | NO   | MUL | NULL    |       |
| codmateria    | varchar(5)  | NO   | MUL | NULL    |       |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

MariaDB [matricula]> describe docente_materia;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| coddocente | varchar(10) | NO   | MUL | NULL    |       |
| codmateria | varchar(5)  | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

MariaDB [matricula]> show tables;
+----------------------+
| Tables_in_matricula  |
+----------------------+
| acudiente            |
| docente              |
| docente_materia      |
| estudiante           |
| estudiante_acudiente |
| estudiante_materia   |
| materia              |
+----------------------+
7 rows in set (0.00 sec)

MariaDB [matricula]> exit