![](https://csdnimg.cn/release/download_crawler_static/88496353/bg1.jpg)
中国矿业大学《数据库概论》作业 第 页 共 3 页
建立数据库
show variables like'character_set_%';
set character_set_server=utf8;
set character_set_database=utf8;
create database library;
创建表格
use library;
create table Book
(
BookId int primary key,
Title char(20) not null,
PublisherName char(15) references publisher(name)
);
create table Publisher
(
Name char(15) primary key,
Address char (20),
Phone int not null
);
create table Borrow
(
BookID int,
CardId int references borrower(cardid),
DateOut date,
DueOut date,
PRIMARY KEY (BookID, CardId),
foreign key(cardid) references book(bookid)
);
create table borrower
(
cardid int primary key,
name char(15) not null,
address char(20),