Design of library management database system

The first 1 Turn off ： Database table design - The book list

# Please add the implementation code here 
########## Begin ##########
# stay library_db Create... In the library books surface 
use library_db;
create table books(
    bookId int(11) primary key not null,
    bookName varchar(255) not null,
    publicationDate datetime not null,
    publisher varchar(255) not null,
    bookrackId int(11) not null,
    roomId int(11) not null
);


########## End ##########

The first 2 Turn off ： Database table design - Reader table

# Please add the implementation code here 
########## Begin ##########
# stay library_db Create... In the library reader surface 
use library_db;
create table reader(
    borrowBookId int(11) primary key,
    name varchar(20) not null,
    age int(11) not null,
    sex varchar(2) not null,
    address varchar(255) not null
);


########## End ##########

  The first 3 Turn off ： Database table design - Association table

# Please add the implementation code here 
########## Begin ##########
# stay library_db Create... In the library bookrack surface 
use library_db;
create table bookrack(
    bookrackId int(11) primary key,
    roomId int(11) not null,
    constraint FK_bookrack_bookrackId foreign key(bookrackId) references books(bookrackId),
    constraint FK_bookrack_roomId foreign key(roomId) references books(roomId)
);


# stay library_db Create... In the library borrow surface 
create table borrow(
    borrowBookId int(11) primary key,
    bookId int(11) not null,
    borrowDate datetime not null,
    returnDate datetime not null,
    constraint FK_borrow_borrowBookId foreign key(borrowBookId) references reader(borrowBookId),
    constraint FK_borrow_bookId foreign key(bookId) references books(bookId)
);


########## End ##########