图书管理系统数据库创建.pdf

《图书管理系统数据库创建.pdf》由会员分享，可在线阅读，更多相关《图书管理系统数据库创建.pdf（4页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、图书管理系统在图书管理系统在 SQL Server 2005SQL Server 2005 数据库中的创建代码数据库中的创建代码: :1. 1. 创建数据库创建数据库create database BookSyson(name = BookSys,filename = D:BookSysDBBookSys.mdf,size = 3,)log on(name = BookSys_log,filename = D:BookSysDBBookSys_log.ldf,size = 1,filegrowth = 1)Gofilegrowth = 10%2. 2.创建表创建表（1 1）创建管理员）创建管理

2、员(admin)(admin)信息表信息表use BookSysgocreate table admin(adminIdvarchar(10) not null ,varchar(4)not null,intnot null,adminNameadminAge)Go（2 2）创建读者）创建读者(reader)(reader)信息表信息表adminSexvarchar(2)not null,adminPassvarchar(10)not nulluse BookSysgocreate table reader(readerIdvarchar(10)not null,readerPassvarch

3、ar(10) not null,readerNamevarchar(8) not null,readerSexvarchar(2)not null,readerAgeintnot null,readerDeptvarchar(20)not null,readerzhuanyevarchar(20)not null,maxnumberint,islostvarchar(2)Go（3 3）创建图书类别）创建图书类别(booktype)(booktype)信息表信息表use BookSysgocreate table booktype(bookTypeIdintnot null,not nullbo

4、okTypeName varchar(10)not null,flowvarchar(4)go（4 4）创建出版社）创建出版社(publisher)(publisher)信息表信息表use BookSysgocreate table publisher(publisherIdvarchar(10)not null,publisherNamevarchar(20)not null,publisherAddressvarchar(20)not null,publisherTelvarchar(11)Go（5 5）创建图书）创建图书(book)(book)信息表信息表use BookSysgocre

5、ate table book(bookIdvarchar(10) not null,not null,bookNamevarchar(10) not null,bookWrittervarchar(10)bookTypeIdintnot null,publisherIdvarchar(10)not null,bookPricefloatnot null,ifborrowvarchar(2)Go（6 6）创建借阅）创建借阅(borrow)(borrow)信息表信息表use BookSysgocreate table borrow(borrowIdintbookIdnot null,varchar

6、(10)not null,readerIdvarchar(10)not null,borrowTimedatetimenot null,returnTimedatetime,outTimevarchar(6)Go3. 3.创建表的约束创建表的约束（1 1）创建管理员）创建管理员(admin)(admin)信息表的约束信息表的约束use BookSysgoalter table adminadd constraint PK_adminId primary key(adminId),constraint CK_adminSex check(adminSex in (男,女),constraint

7、CK_adminAge check(adminAge(0) AND adminAge(0) and readerAge0),constraint DF_ifborrow default(否) for ifborrowgo（6 6）创建借阅）创建借阅(borrow)(borrow)信息表的约束信息表的约束use BookSysgoalter table borrowadd constraint PK_borrowId primary key(borrowId),constraint FK_bookId foreign key(bookId) references book(bookId),constraint FK_readerId foreign key(readerId) referencesreader(readerId),constraint DF_borrowTime default(getdate() FOR borrowTime,constraint DF_outTime default(否) for outTimego本文由牙膏 http:/ ,花都网站建设 http:/ 发表。