用sql sever做图书馆管理系统

发布网友发布时间：2022-05-25 14:47

共2个回答

热心网友时间：2023-11-05 14:00

--图书信息
if exists (select * from sysobjects where name = 'books')
drop table books
create table books
(
Bid int int identity(1,1) not null,
BName varchar(50) not null,
Breade varchar(50) not null,
Bplace varchar(50) not null,--数量
Bprice decimal(20,2),--单价
Btype varchar(50)
)

--读者
if exists (select * from sysobjects where name = 'ReadBook')
drop table ReadBook
create table ReadBook
(
Rid int int identity(1,1) not null,
primary key(Rid),
Rname varchar(50) not null,
Rwork varchar(50) not null,
Rplace varchar(50) not null
)

--借书
if exists (select * from sysobjects where name = 'borrowBook')
drop table borrowBook
create table borrowBook
(
Rid int not null,--借书人
Bid int not null,--借的书 //引用外键books Bid
borrowTime datetime ,--借的时间
Breturn datime,
returnDate datetime--应该归还的时间)
go
alter table borrowBook
add
constraint fk_ Rid foreign key (Rid) references ReadBook(Rid),
constraint fk_ Bid foreign key (Bid) references ReadBook(Bid)

热心网友时间：2023-11-05 14:00