Menu

DataBase

To make the program work, is necessary to create and run a SQL database, with the following commands:
(Sorry about this way to do it)

create table `Biblioteca`.Libro
(
    id INT not null primary key,
    titulo VARCHAR(50) not null,
    nombreAutor VARCHAR(50) default 'Desconocido' not null,
    apellidoAutor VARCHAR(50),
    isbn VARCHAR(25),
    editorial VARCHAR(50) default 'Desconocida' not null,
    copias INT default 1 not null,
    prestados INT default 0,
    tomo INT,
    tematica VARCHAR(50) not null
)

create table `Biblioteca`.Prestamo
(
    idPrestatario VARCHAR(20) not null primary key,
    idLibro INT not null primary key,
    fechaInicio DATE not null primary key,
    fechaFin DATE not null
)

create table `Biblioteca`.Prestatario
(
    cedula VARCHAR(20) not null primary key,
    nombre VARCHAR(50) not null,
    apellido VARCHAR(50) not null,
    telefono VARCHAR(10) not null,
    telefono2 VARCHAR(10),
    fNacimiento DATE not null,
    Sexo CHAR(1) not null
)

create table `Biblioteca`.Usuario
(
    nombre VARCHAR(50) not null,
    apellido VARCHAR(50) not null,
    nick VARCHAR(20) not null primary key,
    pass VARCHAR(20) not null
)

\\\\\\\\\\\\\\\\\\\\\\\\//////////////////////////////////////////////
By running this database the program would work with no problems


Related

Wiki: Home