mysql> use biblioteca;
Database changed
mysql> create table libro(cod_L char(10) not null primary key,nom_L char(40) not null);
Query OK, 0 rows affected (0.07 sec)

mysql> create table autor(cod_A char(10) not null primary key,nom_A char(40) not null);
Query OK, 0 rows affected (0.05 sec)

mysql> create table autor(cod_E char(10) not null primary key,nom_E char(40) not null);
ERROR 1050 (42S01): Table 'autor' already exists
mysql> create table editorial(cod_E char(10) not null primary key,nom_E char(40) not null);
Query OK, 0 rows affected (0.03 sec)

mysql> create table libro_autor(cod_L char(10) not null,cod_A char(10) not null,foreign key(cod_L) references libro(cod_L) on delete cascade on update cascade,foreign key(cod_A) references autor(cod_A) on delete cascade on update cascade)engine=innodb;
Query OK, 0 rows affected (0.06 sec)

mysql> create table autor_edit(cod_A char(10) not null,cod_E char(10) not null,foreign key(cod_A) references autor(cod_A) on delete cascade on update cascade,foreign key(cod_E) references editorial(cod_E) on delete cascade on update cascade)engine=innodb;
Query OK, 0 rows affected (0.06 sec)

mysql> show tables;
+----------------------+
| Tables_in_biblioteca |
+----------------------+
| autor                |
| autor_edit           |
| editorial            |
| libro                |
| libro_autor          |
+----------------------+
5 rows in set (0.02 sec)

mysql> delimiter //
mysql> create procedure listar_autor()
    -> begin
    -> select * from autor;
    -> end
    -> //
Query OK, 0 rows affected (0.05 sec)

mysql> delimiter ;
mysql> delimiter //
mysql> create procedure listar_libro()
    -> begin
    -> select * from libro;
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> delimiter //
mysql> create procedure listar_editorial()
    -> begin
    -> select * from editorial;
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> delimiter //
mysql> create procedure insertar_libro(in codli char(10),nomli char(40))
    -> begin
    -> insert into libro values(codli,nomli);
    -> end
    -> //
Query OK, 0 rows affected (0.01 sec)

mysql> delimiter ;
mysql> delimiter //
mysql> create procedure insertar_autor(in codau char(10),nomau char(40))
    -> begin
    -> insert into autor values(codau,nomau);
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> delimiter //
mysql> create procedure insertar_editorial(in coded char(10),nomed char(40))
    -> begin
    -> insert into editorial values(coded,nomed);
    -> end
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call insertar_libro('001','M tematicas discretas');
Query OK, 1 row affected (0.03 sec)

mysql> call insertar_libro('002','Fundamentos de programaci¢n');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_libro('003','Programaci¢n web 1');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_autor('101','Jorge Sep£lveda');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_autor('102','Maria Angela Cadavid');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_autor('103','Ferndando Lopez');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_editorial('201','Planeta');
Query OK, 1 row affected (0.03 sec)

mysql> call insertar_editorial('202','La gaviota');
Query OK, 1 row affected (0.01 sec)

mysql> call insertar_editorial('203','Alfaragua');
Query OK, 1 row affected (0.01 sec)

mysql> insert into libro_autor(cod_L,cod_A) values('002','102'),('002','103'),('003','101');
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> insert into autor_edit(cod_A,cod_E) values('101','201'),('101','202'),('103','203');
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> call listar_autor;
+-------+----------------------+
| cod_A | nom_A                |
+-------+----------------------+
| 101   | Jorge Sep£lveda      |
| 102   | Maria Angela Cadavid |
| 103   | Ferndando Lopez      |
+-------+----------------------+
3 rows in set (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> call listar_libro;
+-------+-----------------------------+
| cod_L | nom_L                       |
+-------+-----------------------------+
| 001   | M tematicas discretas       |
| 002   | Fundamentos de programaci¢n |
| 003   | Programaci¢n web 1          |
+-------+-----------------------------+
3 rows in set (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> call listar_editorial;
+-------+------------+
| cod_E | nom_E      |
+-------+------------+
| 201   | Planeta    |
| 202   | La gaviota |
| 203   | Alfaragua  |
+-------+------------+
3 rows in set (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> exit