MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 5 rows in set (0.022 sec) MariaDB [(none)]> create database nombre_Biblioteca; Query OK, 1 row affected (0.003 sec) MariaDB [(none)]> use nombre_Biblioteca: ERROR 1049 (42000): Unknown database 'nombre_biblioteca:' MariaDB [(none)]> use nombre_Biblioteca; Database changed MariaDB [nombre_Biblioteca]> show tables; Empty set (0.002 sec) MariaDB [nombre_Biblioteca]> show tables;create table libro (idlibro varchar(10)not null primary key, titulo varchar(60)not null, nropaginas int(4) not null, precio float(6) not null); Empty set (0.002 sec) Query OK, 0 rows affected (0.025 sec) MariaDB [nombre_Biblioteca]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nombre_biblioteca | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.003 sec) MariaDB [nombre_Biblioteca]> create table libro (idlibro varchar(10)not null primary key, titulo varchar(60) -> not null, nropaginas int(4) not null, precio float(6) not null); ERROR 1050 (42S01): Table 'libro' already exists MariaDB [nombre_Biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | idlibro | varchar(10) | NO | PRI | NULL | | | titulo | varchar(60) | NO | | NULL | | | nropaginas | int(4) | NO | | NULL | | | precio | float | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.014 sec) MariaDB [nombre_Biblioteca]> create table Autor (idAutor varchar(3)not null primary key, Nombre varchar(40)not null, nacionalidad varchar(60) not null); Query OK, 0 rows affected (0.040 sec) MariaDB [nombre_Biblioteca]> create libro_Autor (idlibro varchar(10)not null foreign key, idAutor varchar(3)not null foreign key); 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 'libro_Autor (idlibro varchar(10)not null foreign key, idAutor varchar(3)not n...' at line 1 MariaDB [nombre_Biblioteca]> create table libro (idlibro varchar(10)not null primary key, titulo varchar(60) -> describe libro; 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 'describe libro' at line 2 MariaDB [nombre_Biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | idlibro | varchar(10) | NO | PRI | NULL | | | titulo | varchar(60) | NO | | NULL | | | nropaginas | int(4) | NO | | NULL | | | precio | float | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.026 sec) MariaDB [nombre_Biblioteca]> describe Autor; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idAutor | varchar(3) | NO | PRI | NULL | | | Nombre | varchar(40) | NO | | NULL | | | nacionalidad | varchar(60) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 3 rows in set (0.026 sec) MariaDB [nombre_Biblioteca]> create libroAutor (idlibro varchar(10)not null foreign key, idAutor varchar(3)not null foreign key); 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 'libroAutor (idlibro varchar(10)not null foreign key, idAutor varchar(3)not nu...' at line 1 MariaDB [nombre_Biblioteca]> create table Usuario (idUsuario varchar(3)not null primary key, Nombre varchar(40)not null, direccion varchar(15) not null, telefono int(13)not null, email varchar(20)not null, cedula int(10)not null); Query OK, 0 rows affected (0.042 sec) MariaDB [nombre_Biblioteca]> create table Usuario (idUsuario varchar(3)not null primary key, Nombre varchar(40)not null, -> describe Usuario; 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 'describe Usuario' at line 2 MariaDB [nombre_Biblioteca]> MariaDB [nombre_Biblioteca]> describe Usuario; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idUsuario | varchar(3) | NO | PRI | NULL | | | Nombre | varchar(40) | NO | | NULL | | | direccion | varchar(15) | NO | | NULL | | | telefono | int(13) | NO | | NULL | | | email | varchar(20) | NO | | NULL | | | cedula | int(10) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 6 rows in set (0.027 sec) MariaDB [nombre_Biblioteca]> show tables; +-----------------------------+ | Tables_in_nombre_biblioteca | +-----------------------------+ | autor | | libro | | usuario | +-----------------------------+ 3 rows in set (0.005 sec) MariaDB [nombre_Biblioteca]> create libro_Autor (idlibro varchar(10)not null, idAutor varchar(3)not null, foreign key(idLibro) references Libro (idLibro), foreign key(idAutor) references Autor (idAutor)); 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 'libro_Autor (idlibro varchar(10)not null, idAutor varchar(3)not null, foreign...' at line 1 MariaDB [nombre_Biblioteca]> create table Prestamo (idPrestamo varchar(3)not null primary key, idLibro varchar(3)not null, idUsuario varchar(3) not null, fechaprestamo date(10)not null, fechadevolucion date(20)not null, multamora float(10)not null); 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 '(10)not null, fechadevolucion date(20)not null, multamora float(10)not null)' at line 1 MariaDB [nombre_Biblioteca]> create table Prestamo (idPrestamo varchar(3)not null primary key, idLibro varchar(3)not nul -> l, idUsuario varchar(3) not null, fechaprestamo date(10)not null, fechadevolucion date(20)not null, multamora float(10)not null); 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 'nul l, idUsuario varchar(3) not null, fechaprestamo date(10)not null, fechade...' at line 1 MariaDB [nombre_Biblioteca]> create libro_Autor (idlibro varchar(10)not null, idAutor varchar(3)not null); 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 'libro_Autor (idlibro varchar(10)not null, idAutor varchar(3)not null)' at line 1 MariaDB [nombre_Biblioteca]> create libroAutor (idlibro varchar(10)not null, idAutor varchar(3)not null); 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 'libroAutor (idlibro varchar(10)not null, idAutor varchar(3)not null)' at line 1 MariaDB [nombre_Biblioteca]> create Editorial (idEditorial varchar(3)not null primary key, primary key, Nombre varchar(40)not null,); 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 'Editorial (idEditorial varchar(3)not null primary key, primary key, Nombre va...' at line 1 MariaDB [nombre_Biblioteca]> direccion varchar(15) not null, telefono int(13)not null, email varchar(20)not null, cedula int(10)not null -> -> show database; 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 'direccion varchar(15) not null, telefono int(13)not null, email varchar(20)no...' at line 1 MariaDB [nombre_Biblioteca]> create table Usuario (idUsuario varchar(3)not null primary key, Nombre varchar(40)not null, -> direccion varchar(15) not null, telefono int(13)not null, email varchar(20)not null, cedula int(10)not null); ERROR 1050 (42S01): Table 'usuario' already exists MariaDB [nombre_Biblioteca]> create table Editorial (idEditorial varchar(3)not null primary key, nombre varchar(40)not null, direccion varchar(15)not null, telefono int(13)not null, pagina web varchar(80)not null); 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(80)not null)' at line 1 MariaDB [nombre_Biblioteca]> CREATE TABLE Editorial ( -> idEditorial varchar(3) NOT NULL PRIMARY KEY, -> nombre varchar(40) NOT NULL, -> direccion varchar(15) NOT NULL, -> telefono int NOT NULL, -> pagina_web varchar(80) NOT NULL -> show tables; 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 'show tables' at line 7 MariaDB [nombre_Biblioteca]> MariaDB [nombre_Biblioteca]> CREATE TABLE Editorial (idEditorial varchar(3) NOT NULL PRIMARY KEY, nombre varchar(40) NOT NULL, direccion varchar(15) NOT NULL, telefono int NOT NULL, pagina_web varchar(80) NOT NULL); Query OK, 0 rows affected (0.069 sec) MariaDB [nombre_Biblioteca]> CREATE TABLE Prestamo (idPrestamo varchar(3) NOT NULL PRIMARY KEY, idLibro varchar(3) NOT NULL REFERENCES Libro(idLibro), idUsuario varchar(3) NOT NULL REFERENCES Usuario(idUsuario), fechaprestamo date NOT NULL, fechadevolucion date NOT NULL, multamora float NOT NULL); Query OK, 0 rows affected (0.087 sec) MariaDB [nombre_Biblioteca]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nombre_biblioteca | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.005 sec) MariaDB [nombre_Biblioteca]> show tables; +-----------------------------+ | Tables_in_nombre_biblioteca | +-----------------------------+ | autor | | editorial | | libro | | prestamo | | usuario | +-----------------------------+ 5 rows in set (0.005 sec) MariaDB [nombre_Biblioteca]> CREATE TABLE libro_Autor (idlibro varchar(10) NOT NULL, idAutor varchar(3) NOT NULL, FOREIGN KEY (idlibro) REFERENCES Libro (idlibro), FOREIGN KEY (idAutor) REFERENCES Autor (idAutor)); Query OK, 0 rows affected (0.127 sec) MariaDB [nombre_Biblioteca]> create table Autor_Editorial (idAutor varchar(3) not null, idEditorial varchar(10) not null, foreign key (idAutor) references Autor (idAutor), foreign key (idEditorial) references Editorial (idEditorial)); Query OK, 0 rows affected (0.130 sec) MariaDB [nombre_Biblioteca]> show tables; +-----------------------------+ | Tables_in_nombre_biblioteca | +-----------------------------+ | autor | | autor_editorial | | editorial | | libro | | libro_autor | | prestamo | | usuario | +-----------------------------+ 7 rows in set (0.004 sec) MariaDB [nombre_Biblioteca]> describe autor_editorial; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idAutor | varchar(3) | NO | MUL | NULL | | | idEditorial | varchar(10) | NO | MUL | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.054 sec) MariaDB [nombre_Biblioteca]> describe libro_autor; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | idlibro | varchar(10) | NO | MUL | NULL | | | idAutor | varchar(3) | NO | MUL | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.067 sec) MariaDB [nombre_Biblioteca]> exit