go /*==============================================================*/ /* Table: Unit */ /*==============================================================*/ create table Unit ( Unit_No varchar(10) not null, Unit_Address varchar(50) null, Unit_Phone varchar(18) null, constraint PK_UNIT primary key nonclustered (Unit_No) ) go /*==============================================================*/ /* Table: book */ /*==============================================================*/ create table book ( Book_No char(10) not null, Return_Date datetime null, Library_No char(20) null, \ varchar(20) not null, \ numeric(6,2) not null, bookauthor varchar(60) not null, \ varchar(40) not null, \ datetime not null, Book_ID char(1) not null, constraint PK_BOOK primary key nonclustered (Book_No) ) go /*==============================================================*/ /* Table: reader */ /*==============================================================*/ create table reader ( Reader_No char(8) not null, Unit_No varchar(10) null, Reader_Name varchar(8) not null, Reader_ID varchar(20) not null, Reader_Phone varchar(18) not null, Reader_Address varchar(50) not null, Reader_Email varchar(20) not null, constraint PK_READER primary key nonclustered (Reader_No) ) go /*==============================================================*/
/* Table: \ */ /*==============================================================*/ create table \ Return_Date datetime not null, Reader_No char(8) null, Book_No char(10) null, Return_ID char(1) not null, constraint PK_RETURN primary key nonclustered (Return_Date) ) go 教师评语： 签名：徐冬 日期：11.07
成绩