第1个回答 2020-04-17
create table librarycard
(cno char(10) ,
cname varchar2(10) not null,
cdept varchar2(10),
primary key(cno)
);
create table book
(bno char(8),
bname varchar2(10) not null,
bauthor varchar2(20) not null,
bprice number(10),
binventory number(10),
primary key(bno)
);
create table record
(cno char(10),
bno char(8),
rgetdate date,
rbackdate date
);