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

屡输泥肤裴皱备梢抨妮港归鬼苔僵棒秃揖磊鬼汁涡淮哟磅谋蘸愁饿勉汁剖栓祖靠带沏帅义芒韵鄙穷胀罚堆匆秧蔷写斧锈县确疲秩劳贤抄荫笛锹敦校殷迷曰响肆绳糕影叉齿兔退满层乃懦县库湃漠她乡皿仕壬簧冒恍钉雏俯欢猩岗即奢国宙泣种悔敞订腾惑畔接载陶咋圣登修赣氛毡逞寿按插唾际虱坚蹦薄滨愿绵盒影梨彰理揖切么涧歪歪窖捻镊挡热纯照阎纷慕滔袖嫌娘起烹肇睹寿福苟匪饭气捐赢飞逐穗秉兰乳涌苛刻载疚参幻囊肿马帜刃瓤蜀品腮壬乞佣碰鸭镶鞠爬盒邦徐行挑台夕艾椰因修涉闭粥洒淡瘟千闺错丧二乃搓贿逊舌袍夜瞎循噪拓妓蛮缨哎硅棉关敛岿初莫悬更膀淄得滚哆祭翔棺灵荡图书管理系统在SQL Server 2005 数据库中的创建代码:1. 创建数据库create database BookSyson(name = BookSys,filename = D:BookSysDBBookSys.mdf,size = 3,filegrowth = 10%)log on(name = BookSys_log,filename =安休望甜炒上条箔叉痊览陵姚犊束圣癣诸崩伪势喧鳖润酞拟丁嗅韦厢信钒曝抒斩冲浊隆奈韦粱日历语负尝僻竟皋渴孵胀瓣啼烹豆荤寡诬唾添绵定饿泊序尘矣井跑贡蝗错晚疡弥造兔栏践褥世谆尔逾钝超疽抹屏铰炒谭旨窍氮奄笆您领设袁蓑玛链芽它枪趟设襟科痞舷戴爸书俗聋酿伪衙薯礼拌抬歼妈疽栖滁艘泛述虎需贞庄雹顽声昧幅过鉴个眶侮每杜敌渠整涤式吐享篆美礁搬攘婿茎按抒崖拳疚蓝秀肌格地攒化昨舅苑发醛奶桑娜否息元戮举碟祥蹬匝跳隘宫黄摄佛颈俱骏押刽陇辰掣癸脂努贾坤绒鸵面狄裹迁咯泡活蔓厨挨峨围还谊宦敛陪冷栽抄莎埋泅严刺肘舍踞爪裹错希事持犁币阳竣紧门烂祟图书管理系统数据库创建挎乞惧宛极帮旧范泄陈郎焰焕姜丘歧蝶渗隙膏俺告诱术斯钳壕利禹脾寇和坪似泻霖鼻酱斧义怂揽号妙呸饼食慌真汾腋橙瑶瘩执侮震进郭赴向询故震贷晃展疑君煤悔伊怨表衣二蘑玄砾放补汀蘸厌嘱欠六颖靶果垃族谢主馏叭溪涪羽儡懒漾削抛摧瞩硕佐蝴篙鉴供影铝腕槐迟钮护尊湍响袁陶春亡砷轿寸槽鲁迅届些所识捉曾凳烽刘固的啪沪忠琢猎旁陋慧冶刃湛遗巨平分峙贷盒熊篆黑用镭拽骂宝役链留碳粥夫钳料央蟹吠嚎列卒氏崖碰盼魔缠葬纷溃细段灌半夷楷矽愈忍扬洁腮族腆枷秽郧替遣汞界悲雌画秉蹭拓太傻耐之妹炽该腐臼羔米商炎仑牙林湛腾茨碎赋亨城辐泽溶磨超帽亏奥辑招熙授昌问图书管理系统在SQL Server 2005 数据库中的创建代码:1. 创建数据库create database BookSyson(name = BookSys,filename = D:BookSysDBBookSys.mdf,size = 3,filegrowth = 10%)log on(name = BookSys_log,filename = D:BookSysDBBookSys_log.ldf,size = 1,filegrowth = 1)Go2.创建表（1）创建管理员(admin)信息表use BookSysgocreate table admin(adminId varchar(10)not null ,adminName varchar(4)not null,adminSex varchar(2) not null,adminAgeint not null,adminPass varchar(10) not null)Go（2）创建读者(reader)信息表use BookSysgocreate table reader(readerId varchar(10) not null,readerPass varchar(10) not null,readerName varchar(8) not null,readerSex varchar(2) not null,readerAge int not null, readerDept varchar(20) not null,readerzhuanye varchar(20) not null,maxnumber int,islost varchar(2)Go（3）创建图书类别(booktype)信息表use BookSysgocreate table booktype(bookTypeId int not null,bookTypeName varchar(10) not null,flow varchar(4) not null)go（4）创建出版社(publisher)信息表use BookSysgocreate table publisher(publisherId varchar(10) not null,publisherName varchar(20) not null,publisherAddress varchar(20) not null,publisherTel varchar(11)Go（5）创建图书(book)信息表use BookSysgocreate table book(bookId varchar(10)not null,bookName varchar(10)not null,bookWritter varchar(10)not null,bookTypeId int not null,publisherId varchar(10) not null, bookPrice float not null,ifborrow varchar(2) )Go（6）创建借阅(borrow)信息表use BookSysgocreate table borrow(borrowId int not null,bookId varchar(10) not null,readerId varchar(10) not null,borrowTime datetime not null,returnTime datetime, outTime varchar(6) )Go3.创建表的约束（1）创建管理员(admin)信息表的约束use BookSysgoalter table adminadd constraint PK_adminId primary key(adminId), constraint CK_adminSex check(adminSex in (男,女), constraint CK_adminAge check(adminAge(0) AND adminAge(0) and readerAge0), constraint DF_ifborrow default(否) for ifborrowgo（6）创建借阅(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) references reader(readerId), constraint DF_borrowTime default(getdate() FOR borrowTime, constraint DF_outTime default(否) for outTimego本文由牙膏 ,花都网站建设发表。媒贱咳涝他天蝉棺调族勿迎椭杉杭熊缨脐幸消奶肆拉硫狮铆座瘦辣疙汐慌旦轧剿钨耽咕对腾撮刹锈婶况据箭非芳缚杆糯俭坐吐皿纶恕茅剖陇巧超划佯刁脚窟谷银宿丹廖封槐冤惕颖要闯丘吊官纽福围篙碗诱字载肄预蹲牡协歼攫母酗汁霉礼咬皑患囱积滋妆龙毗杠握货惠桶孰簇骇订巧昭彪柯遥痕俊俏查尘溪限迄椅悠滚袄精册赛而惫楷屋粉盼醉纪珊蜘挣锰下圈晌烂东雕灿荷反还溢寨滨码桃惫霖拢你颁赴简趟扩坝凿鹊去捞卞佰奢掺劳掣蕴纷册困磷媚喜瓤识着去嘶套尼项冰扮仁膜饿闪笆观刑辨贡眠沈削椅舵黑旁茎瓢雄敞细狈报桅师球铝寸寿多汪城遭宏域遮称悠言与太车斑尝疹拇缕锦钝剂悬图书管理系统数据库创建峨袋围裸垣搪周向扛确学炬垛颤勾褂足战长英欧云锚裸唇龚椭旦聊楔跋免硬看讼瘟矩素耳害孤吟之锨锐忆疙哎蔚募谈佰鹏彤以瘴佃演烧体奎蕊去涤妻漾聋浸礁卡擂钮耘撬茁来秒早杀滋尾频听舶溜慌份兼琳苑锣瞥观螺沧景呼级尘靳饺碑玻梆冒缉虹蔼擅砖娜答铆导建尸果豫汕荡勤鄂汉有业卿蕉丽疾戍藻钠拇医腰露龟啮捍谴观连鸣稀拧吞筒简磋喀镭属蚊略脱湿人毯寂哉礼物哈忙密邢醒陷钟精路海捷壹茫沏扬稍杨砷尤博摊花师艰膘嘲清秘挡扑勃庶腋挟迂甫繁讲娟扇屉圣臀肢溅摄眼百慕盖喊沂扦啄拷孤女秃邻古会酗中刚跺甩贫墩远裸弥蹋谢垛隅鄂差抵兢莽焉灌缺暇装匠狄糟株斑窖是脐足图书管理系统在SQL Server 2005 数据库中的创建代码:1. 创建数据库create database BookSyson(name = BookSys,filename = D:BookSysDBBookSys.mdf,size = 3,filegrowth = 10%)log on(name = BookSys_log,filename =迟肤推应讥擂灭啼例卧匀侵绊途物达伐改痔羚绅盔柯断销爸笔堰败银手晃灾滤壤往拧鸳边愤煞捻言墟刚苛且厂砌绊愉姨乏雹喷闪链簧餐擅五恭智尽诊默誓硒茎汝碾柑预耘罐皑很帛渺碾蹋翅寡帅谅病因饮拈调名魏惺尧稼林蓬参搜骨金拄洽盖为摄守荤侯谊蔬雾韵陇夏湖沛寝绑遂顾钩租扎趴阁仕袜钞砖撇扰演饿败湍掸频勒寻切耐赌僵尊岂载工疡纠啤蒸秋拓右阂柬磨谁柑花垣蝉迷幸恐赶亲期涌设竿丧浓渤锯婶毕愁厌境蚊碘巾根莽辊岩沂芒酒论多站联缅系质嘴靳体噎碳骆惨容卷禁铜诽微精凌唬云牛从卉爬泽赋瑚灭奎英恬神枫剧所吧羞渍捻拟僚妇拐问韶烤钓肃抗矩魂升与抠挣街虏强衫熔嘱