数据库.txt

设计并实现一个精简的图书管理系统, 要求具有图书入库、查询、借书、还书、 借书证管理等功能。

create table book(
  bno  char(13)  primary key,
  category varchar(50),
  title  varchar(50),
  author varchar(50),
  press varchar(20),
  total int,
  stocked  int,
  year int,
 price numeric(6,2));

create table card(
cno char(10) primary key,
name varchar(50),
unit varchar(100),
cat char(7));

create table admin(
id char(10) primary key,
name varchar(50),
address varchar(255));

create table borrow(
cno char(10) not null,
bno char(13) not null,
borrow_date date,
return_date date,
id char(10) not null,
primary key(cno,bno),
foreign key (cno) references card(cno),
foreign key(bno) references book(bno),
foreign key(id) references admin(id));