MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | facturacion | | information_schema | | mysql | | performance_schema | | phpmyadmin | | secundaria | | test | +--------------------+ 7 rows in set (0.03 sec) MariaDB [(none)]> create database libreria; Query OK, 1 row affected (0.05 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | facturacion | | information_schema | | libreria | | mysql | | performance_schema | | phpmyadmin | | secundaria | | test | +--------------------+ 8 rows in set (0.00 sec) MariaDB [(none)]> use libreria; Database changed MariaDB [libreria]> show tables; Empty set (0.05 sec) MariaDB [libreria]> create table libro -> (Idlibro varchar(10) not null primary key, -> Titulo varchar(45) not null, -> Nropagina int not null, -> Precio int not null, -> Codigomat varchar(10) not null); Query OK, 0 rows affected (0.45 sec) MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idlibro | varchar(10) | NO | PRI | NULL | | | Titulo | varchar(45) | NO | | NULL | | | Nropagina | int(11) | NO | | NULL | | | Precio | int(11) | NO | | NULL | | | Codigomat | varchar(10) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.06 sec) MariaDB [libreria]> create table materia -> (Codigomat varchar(10) not null primary key, -> Nombre varchar(45)not null); Query OK, 0 rows affected (0.21 sec) MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Codigomat | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.02 sec) MariaDB [libreria]> create table autor -> (Codautor varchar(10) not null primary key, -> Nombre varchar(45) not null); Query OK, 0 rows affected (0.25 sec) MariaDB [libreria]> describe autor; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | Codautor | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.05 sec) MariaDB [libreria]> create table editorial -> (Codedit varchar(10) not null primary key, -> Nombre varchar(45) not null); Query OK, 0 rows affected (0.19 sec) MariaDB [libreria]> describe editorial; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | Codedit | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.06 sec) MariaDB [libreria]> create table liautedi -> (Idlibro varchar(10) not null, -> Codautor varchar(10) not null, -> Codedit varchar(10) not null, -> foreign key(Idlibro) references libro(Idlibro) on delete cascade on update cascade, -> foreign key(Codautor) references autor(Codautor) on delete cascade on update cascade, -> foreign key(Codedit) references editorial(Codedit) on delete cascade on update cascade); Query OK, 0 rows affected (0.32 sec) MariaDB [libreria]> describe liautedi; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | Idlibro | varchar(10) | NO | MUL | NULL | | | Codautor | varchar(10) | NO | MUL | NULL | | | Codedit | varchar(10) | NO | MUL | NULL | | +----------+-------------+------+-----+---------+-------+ 3 rows in set (0.11 sec) MariaDB [libreria]> alter table libro change Titulo Descripcion varchar(45) not null; Query OK, 0 rows affected (0.15 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe libro; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idlibro | varchar(10) | NO | PRI | NULL | | | Descripcion | varchar(45) | NO | | NULL | | | Nropagina | int(11) | NO | | NULL | | | Precio | int(11) | NO | | NULL | | | Codigomat | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.10 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L01','Calculo II',120,55000,'M01'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> describe libro; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Idlibro | varchar(10) | NO | PRI | NULL | | | Descripcion | varchar(45) | NO | | NULL | | | Nropagina | int(11) | NO | | NULL | | | Precio | int(11) | NO | | NULL | | | Codigomat | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.08 sec) MariaDB [libreria]> select * from libro; +---------+-------------+-----------+--------+-----------+ | Idlibro | Descripcion | Nropagina | Precio | Codigomat | +---------+-------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | +---------+-------------+-----------+--------+-----------+ 1 row in set (0.00 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L02','BD II',150,65000,'M09'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L03','Estructura de datos',180,85000,'M03'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L08','Diagramacion',85,45000,'M08'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L05','Admon en una pagina',70,7500,'M05'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L07','Redes',370,32500,'M07'); Query OK, 1 row affected (0.07 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L04','Ingles',280,105000,'M04'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> select *from libro; +---------+---------------------+-----------+--------+-----------+ | Idlibro | Descripcion | Nropagina | Precio | Codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L05 | Admon en una pagina | 70 | 7500 | M05 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramacion | 85 | 45000 | M08 | +---------+---------------------+-----------+--------+-----------+ 7 rows in set (0.00 sec) MariaDB [libreria]> insert into Libro (Idlibro,Descripcion,Nropagina,Precio,Codigomat)values('L06','Contabilidad I',170,27500,'M06'); Query OK, 1 row affected (0.02 sec) MariaDB [libreria]> select * from libro; +---------+---------------------+-----------+--------+-----------+ | Idlibro | Descripcion | Nropagina | Precio | Codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L05 | Admon en una pagina | 70 | 7500 | M05 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramacion | 85 | 45000 | M08 | +---------+---------------------+-----------+--------+-----------+ 8 rows in set (0.00 sec) MariaDB [libreria]> MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M01','Calculo'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Codigomat | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.09 sec) MariaDB [libreria]> select *from materia -> ; +-----------+---------+ | Codigomat | Nombre | +-----------+---------+ | M01 | Calculo | +-----------+---------+ 1 row in set (0.00 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M02','Matematicas'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M03','Estructura de datos'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M04','Ingles'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M08','Diagramacion'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M06','Contabilidad'); Query OK, 1 row affected (0.03 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M07','Redes'); Query OK, 1 row affected (0.07 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M05','Sistemas de Inf'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into materia (Codigomat,Nombre)values('M09','Base de datos'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> select * from materia -> ; +-----------+---------------------+ | Codigomat | Nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingles | | M05 | Sistemas de Inf | | M06 | Contabilidad | | M07 | Redes | | M08 | Diagramacion | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.00 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A01','Luis Joyanes'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A02','Jorge Vasquez Posada'); Query OK, 1 row affected (0.04 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A03','Jhon Khadem'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A04','Robert Lorber'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A05','Riaz Soars'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into autor (Codautor,Nombre)values('A06','Mario Dream'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> select *from autor; +----------+----------------------+ | Codautor | Nombre | +----------+----------------------+ | A01 | Luis Joyanes | | A02 | Jorge Vasquez Posada | | A03 | Jhon Khadem | | A04 | Robert Lorber | | A05 | Riaz Soars | | A06 | Mario Dream | +----------+----------------------+ 6 rows in set (0.00 sec) MariaDB [libreria]> insert into editorial (Codedit,Nombre)values('E01','Oveja Negra'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into editorial (Codedit,Nombre)values('E02','Norma'); Query OK, 1 row affected (0.03 sec) MariaDB [libreria]> insert into editorial (Codedit,Nombre)values('E03','Mc Graw Hill'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> select *from editorial; +---------+--------------+ | Codedit | Nombre | +---------+--------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+--------------+ 3 rows in set (0.00 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L02','A01','E01'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L02','A05','E03'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L06','A02','E02'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L07','A05','E03'); Query OK, 1 row affected (0.03 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L04','A04','E01'); Query OK, 1 row affected (0.05 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L04','A04','E02'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into liautedi (Idlibro,Codautor,Codedit)values('L04','A04','E03'); Query OK, 1 row affected (0.03 sec) MariaDB [libreria]> select *from liautedi; +---------+----------+---------+ | Idlibro | Codautor | Codedit | +---------+----------+---------+ | L02 | A01 | E01 | | L02 | A05 | E03 | | L06 | A02 | E02 | | L07 | A05 | E03 | | L04 | A04 | E01 | | L04 | A04 | E02 | | L04 | A04 | E03 | +---------+----------+---------+ 7 rows in set (0.00 sec) MariaDB [libreria]> select Descripcion from libro; +---------------------+ | Descripcion | +---------------------+ | Calculo II | | BD II | | Estructura de datos | | Ingles | | Admon en una pagina | | Contabilidad I | | Redes | | Diagramacion | +---------------------+ 8 rows in set (0.00 sec) MariaDB [libreria]> select Nombre from autor; +----------------------+ | Nombre | +----------------------+ | Luis Joyanes | | Jorge Vasquez Posada | | Jhon Khadem | | Robert Lorber | | Riaz Soars | | Mario Dream | +----------------------+ 6 rows in set (0.00 sec) MariaDB [libreria]> select Nombre from editorial; +--------------+ | Nombre | +--------------+ | Oveja Negra | | Norma | | Mc Graw Hill | +--------------+ 3 rows in set (0.00 sec) MariaDB [libreria]> select Nombre from materia; +---------------------+ | Nombre | +---------------------+ | Calculo | | Matematicas | | Estructura de datos | | Ingles | | Sistemas de Inf | | Contabilidad | | Redes | | Diagramacion | | Base de datos | +---------------------+ 9 rows in set (0.00 sec) MariaDB [libreria]> select Descripcion,Precio from libro; +---------------------+--------+ | Descripcion | Precio | +---------------------+--------+ | Calculo II | 55000 | | BD II | 65000 | | Estructura de datos | 85000 | | Ingles | 105000 | | Admon en una pagina | 7500 | | Contabilidad I | 27500 | | Redes | 32500 | | Diagramacion | 45000 | +---------------------+--------+ 8 rows in set (0.00 sec) MariaDB [libreria]> alter table Materia Rename to Asignatura; Query OK, 0 rows affected (0.25 sec) MariaDB [libreria]> describe Asignatura; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Codigomat | varchar(10) | NO | PRI | NULL | | | Nombre | varchar(45) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.06 sec) MariaDB [libreria]> show tables; +--------------------+ | Tables_in_libreria | +--------------------+ | asignatura | | autor | | editorial | | liautedi | | libro | +--------------------+ 5 rows in set (0.00 sec) MariaDB [libreria]> exit