《SQLServer数据库技术与应用课程报告》由会员分享，可在线阅读，更多相关《SQLServer数据库技术与应用课程报告（10页珍藏版）》请在金锄头文库上搜索。
1、SQL Server数据库技术与应用课程报告-图书馆数据系统create database BookManageon primary(name=,BookManage_data,filename二D数据库数据存放数据文件BookManage_data.mdf, size=10mb,filegrowth=20%)log on(name=BookManage_log,filename=D:数据库数据存放事务 Fl /忐文件 BookManage_log.ldf, size=10mb,filegrowth=20%)B 心(local) (SQL Server 10.50.1617 - jianfen
2、g-PCjianfeng)日Ca昭库q 口票绽娠库s 数据库快照B J BookManage0 C3数振库关票图田口表S C3视圏a 同义词s 可編程性 _| Service BrokerS 存储a 安全性use BookManagecreate table category(cid char(3) not null primary key,cname varchar(20) not null)JIANFENG-PC.Boolc.ge dbo.category TEST.sql (local).ng-PCjianfeng 列名数据类型 允诈Null值adchacnamevarchar(20)c
3、reate table userType(tid char(3) not null primary key, tname varchar(lO), borrowDays tinyint)JIANFENG-PC.Book.ge - dbo.userType JIANFENG-PC.Book.ge - dbo.categc 列名数据类型 允许Null值$ tidchaOtname borrowDaysvarchar(lO) tinyintcreate table users(uid char(8) not null primary key,uname varchar(lO),pwd varchar
4、(lO),sex char(2),birthDay datetime,tel char(ll),tid char(3) foreign key references userType(tid)JIANFENG-PC.BookManage dbo.users TEST.sql (local).-PCjian列名数掳类型允许Null值? uidchar (8)unamevarchar(lO)pwdvarchar(lO)sexch前birthDaydatetimetelchar (11)tidchar create table book(ISBN char(10) not null primary
5、key, searchlD varchar(lO),cid char(3) foreign key references category(cid), bname varchar(50), pubHouse varchar(30),author varchar( 10), price decimal(5,2), totalNum tinyint, NumCanBorrow tinyint )JIANFENG-PCBookManage - dbo.book JIANFENG-PC.BookManage - dbc列名数据类型 允诈Null值ISBNj char(10)searchlDvardia
6、r(lO)cidchar bnamevarchar(50)pubHousevarchar(30)authorvarchar(lO)pricedecimal(5/ 2)totalNumtinyintNumCa nBorrowtinyintcreate table borrow(bid int not null primary key identity(1,1), uid char(8) foreign key references users(uid),ISBN char( 10) foreign key references book(ISBN), borrowTime datetime, r
7、etumTime datetime,isReturn char( 1)bidintnuidchar (8)ISBNchar(10)画borrowTimedatetimereturnTimedatetime画isReturnchar(l)insert into category valuesfcOr/文学类) insert into category values(c02；计算机类) insert into category values(fc037夕卜语类J insert into category values(fc047数学类) insert into category values(c0
8、5丁天文类)*saaasaA54321卜O.匸冷哉诟测仙 粋擀粋曲粋insert into userType va-ues(6lB30) 5-sertinto userType v 巴 Ues(to2-:7it45) inseHimo userType va 一 ues(o3Bsn6o)*JIANFENG-PC.Boolc.ge dbo.userType JIANFENG-PC.BcS 3 3 3321岸fig出卄3dg Sa2tidtnameborrowDaysinsert into users v 巴 ues(2012000 二奚刁 Y 二二二-:過二 994,10-12二 3545637
9、86501 )5-scrtinto users v 巴 ues(20120002HH铢二 11111-:凋二 994二?13二354563786601) insert imo users va 一 ues(2220003HB二二二二沦二 9940*4 二 35456378670二insert ho users val ues(20120004您湧工 一一一一二過二994=915H354563786801) insert ho users Vamos (二 0001爾驾二二二二邂.二 976022H354563786902) insert into users Vamos (二 0002倉湼二二
10、二二過二 975T23-I1354563787002) 5-scrtinto users vames30003w述一二二 11-:外二975T24u354563787103)米g- o_201200042012000320120002C Ql 卜%DH-FH 冲PX1994-10-15 00:1994-10-14 00:1994-10-13 00:1975-11-2400;1975-11-23 00:1976-02-12 00:birthDay 卜:13545637868:13545637867:13545637866:13545637871:1354563786981S18i3ig：晤奧 2
11、85)insert inobook vaces(9782345435TP313、二k02c 谕逊殊斗S-H世圧滚津UBS 35.287)ISBNsearchlDadbnamepubHouseauthorprice9782345432TD 235/12cOl西游记北京大学出版社吴承恩88.009782345433TD 235/22cOl三国演义北京大学出版社罗贯中108.009782345434TP313/01c02数据库原理与唐华大学出版社谭浩强28.009782345435TP313/11c02C程序设计清华大学出版社谭浩强35.20米NULLAtZAAJLLMJLLMJLLMJLLMJLL
12、insert into borrow values(*2012000179782345434,*2014-11 -05null/0) insert into borrow valuesC20120002,*9782345435,2014-11 -20,null/0) insert into borrow values(,2012000r,9782345432,；2014-ll-05null；0,) insert into borrow values(,20120002,9782345435,；2014-ll-20,null；0,) insert into borrow values(,2012
13、000r；9782345433,；2014-ll-05nuli；0,) insert into borrow values(,20120003,；9782345435,；2014-ll-20,nulbiduidISBNborrowTimereturnTimeisReturn312012000197823454342015-04-0100:.AAJLL0322012000297823454352015-042 00:.AAJU0332012000197823454322015-04-0 5 00:.A/ULL0342012000297823454352015-04-06 00:.AAJLL0352012000197823454332015-04-05
