图书管理系统 数据库实现（oracle）

create tablespace library2
datafile 'E:\oracle\datafiles\library2.dbf'
size 10M
autoextend on;
create user library2
identified by oracle
default tablespace library2
grant connect,resource to library2;
grant select on scott.emp to library2;--授权

create table bookRoom(--书库
id     number(6)    primary    key,  --表的创建
name   varchar2(20) not  null,
address varchar2(20),
phone   varchar2(20)
);
create  table  BookCatagory( --图书的类别
id    number(6)     primary    key,
name  varchar2(20)  not   null,
brid  number(6)   references   bookroom(id),
demo   varchar2(100)
);
create table Book(
ISBN    varchar2(20)  primary   key,
cid     number(6)     references  bookCatagory(id),
name    varchar2(100) not   null,
publish  varchar2 (20),
author  varchar2 (20),
publishDate DATE,
price  number(6,2),
storageDate date,
stocknumber number,
inNumber    number
);
create  table  BookAdministrator( --图书管理员
id    varchar2(20)     primary    key,
name  varchar2(10),
phone varchar2(10),
brid  number(6)   references  bookroom(id)
);
create table Reader( --读者
id     varchar2(20)     primary  key,
name   varchar(20)   not