图书借阅管理系统课程设计

l(外主键)书籍编号borrowdateVarcharNotnull读者借书时间return_record借阅记录信息表5表中列名数据类型可否为空说明readernameVarcharNotnull(外主键)读者借阅证编号readeridVarcharNotnull(外主键)书籍编号returndatedatetimeNotnull读者还书时间reader_fee罚款记录信息表6readeridvarcharNotnull读者借书证编号readernamevarcharNotnull读者姓名bookidvarcharNotnull(外主键)书籍编号booknamevarcharNotnull书籍名称bookfeevarcharNotNull罚款金额borrowdatedatetimeNotNull借阅时间4创建数据库4.1创建数据库USEmastergoCREATEDATABASE图书管理系统ON(NAME=librarysystem,FILENAME='c:\tangzhangsenlibrary.mdf',SIZE=10,MAXSIZE=50,FILEGROWTH=5)LOGON(NAME='library',FILENAME='c:\tangzhangsenlibrary.ldf',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)go4.2书本类别建立(书籍类别表)createtablebook_style(bookstylenovarchar(30)primarykey,//书本类别编号bookstylevarchar(30)//书本类别)4.3创建书库表(表)createtablesystem_books(bookidvarchar(20)primarykey,//书本编号booknamevarchar(30)Notnull,//书籍名称