建立LIBRARY数据库代码(简化)和关系图

PAGEPAGE3PAGEPAGE3建立Library数据库和表代码--CREATEDATABASElibraryCREATEDATABASE图书馆ONPRIMARY(NAME='library',FILENAME='H:\Library\library.mdf',SIZE=4,MAXSIZE=UNLIMITED,FILEGROWTH=1)LOGON(NAME='library_log',FILENAME='H:\Library\library_log.ldf',SIZE=1,MAXSIZE=2048GB,FILEGROWTH=10%)GO--1.CREATEBOOKCREATETABLEdbo.BOOK(BOOK_IDnvarchar(8)NOTNULLPRIMARYKEY, BOOK_NAMEnvarchar(50)NULL, AUTHORnvarchar(30)NULL, PRESSnvarchar(50)NULL, PRESS_DATEdatetimeNULL, FLAG_BORROWnvarchar(1)NULL, PRICEmoneyNULL, book_typevarchar(10)NULL,)--2.CREATECLERKCREATETABLEdbo.CLERK(CLERK_IDnvarchar(8)NOTNULLPRIMARYKEY,NAMEnvarchar(8)NULL,ID_CARDnvarchar(18)NULL,PASSWORDnvarchar(30)NULL,OFFICIERnvarchar(30)NULLDEFAULT'管理员')--3.CREATEREADERCREATETABLEdbo.READER( READER_IDnvarchar(8)NOTNULLPRIMARYKEY, NAMEnvarchar(8)NOTNULL, IDCARDnvarchar(18)NULL, MAXNUM_CAN_BORROWsmallintNULL, FLAG_BORROWnvarchar(2)NULL, sexbitNULL,)--4.CREATEBORROWCREATETABLEdbo.BORROW( READER_IDnvarchar(8)NULL, BOOK_IDnvarchar(8)NULL, BORROW_DATEdatetimeNULL, B_CLERK_IDnvarchar(8)NULL,IDintIDENTITY(1,1)NOTNULLPRIMARYKEY, R_CLERK_IDnvarchar(8)NULL, RETURN_DATEdatetimeNULL, FLAG_RETURNnchar(2)NULLCONSTRAINTDF_BORROW_FLAG_RETURNDEFAULT('N'),CONSTRAINTFK_BORROW_BOOKFOREIGNKEY(BOOK_ID)REFERENCESdbo.BOOK(BOOK_ID),CONSTRAINTFK_BORROW_CLERKFOREIGNKEY(B_CLERK_ID)REFERENCESdbo.CLERK(CLERK_ID),CONSTRAINTFK_BORROW_R_CLERKFOREIGNKEY(R_CLERK_ID)REFERENCESdbo.CLERK(CLERK_ID),CONSTRAINTFK_BORROW_READERFOREIGNKEY(READER_ID)REFERENCESdbo.READER(READER_ID))--5.CREATECHUNCREATETABLEdbo.chun( IDintNOTNULL, ISBNnvarchar(8)NULL, 书名nvarchar(50)NULL, 作者nvarchar(30)NULL, 版别nvarchar(50)NULL, 出版日期datetimeNULL))--6.CREATEFINECREATETABLEdbo.FINE( READER_IDnvarchar(8)NULL, AMOUNTintNULL, DAYSsmallintNULL, FINE_DATEdatetimeNULL, CLERK_IDnvarchar(8)NULL, IDintIDENTITY(1,1)NOTNULL, OK_DATEdatetimeNULL, FLAG_FINEnchar(2)NULL)--7.CREATEFINE_HISTORYCREATETABLEdbo.FINE_HISTORY( READER_IDnvarchar(30)NULL, AMOUNTintNULL, DAYSsmallintNULL, FINE_DATEdatetimeNULL, OK_DATEdatetimeNULL, IDintIDENTITY(1,1)NOTNULL)--8.CREATEHISTORYCREATETABLEdbo.HISTORY( READER_IDnvarchar(30)NULL, BOOK_IDnvarchar(30)NULL, BORROW_DATEdatetimeNULL, RETURN_DATEdatetimeNULL, B_CLERK_IDnvarchar(30)NULL, R_CLERK_IDnvarchar(30)NULL, IDintIDENTITY(1,1)NOTNULL)--9.CREATEnew_tableCREATETABLEdbo.new_table( book_namenvarchar(50)NULL, authornvarchar(30)NULL, press_datedatetimeNULL, pricemoneyNULL)--10.CREATEstuCREATETABLEdbo.stu( IDintNOTNULL, 学号nvarchar(10)NULL, 姓名nvarchar(30)NULL, 身份证号nvarchar(30)NULL)--11.CREATExml_bookCREATETABLEdbo.xml_book(idint