1. /创建数据库
create database bool_reader_db;
2.//创建 表
create table Book(
bno varchar(20) not null primary key,
bclass varchar(10) not null,
publisher varchar(10),
author varchar(10) not null,
bname varchar(20) not null,
price float not null,
remark varchar(20)
);
3.//实现:借阅表与图书表之间、借阅表与读者表之间的外码约束
alter table Borrow add constraint borrow_bno_constrain foreign key(bno) references book(bno);
4.//实现读者性别只能是“男”或“女”的约束
alter table Reader add constraint sex_check check(sex in ('男','女'));
5.//在“图书”表中,增加字段“数量”
alter table book add number int;