数据库系统原理与设计实验四

实验41.createdatabasebookDBon(name='bookDB',filename='D:\萌萌哒财务\bookDB.mdf',size=3,maxsize=20,filegrowth=1)2.createtablebookclass(classnochar(3)notnullprimarykey,/*图书分类号*/classnamevarchar(20)notnull/*图书分类名称*/)3.createtablebook(booknochar(10)notnullprimarykey,/*图书编号*/classnochar(3)notnull,/*分类号*/booknamevarchar(40)notnull,/*图书名称*/authornamevarchar(8)notnull,/*作者姓名*/publishingnamevarchar(20)null,/*出版社名称*/publishingnochar(17)null,/*出版社编号*/pricenumeric(7,2)null,/*单价*/publishingdatedatetimenull,/*出版日期*/shopdatedatetimenull,/*入库时间*/shopnumnumeric(3,0)/*入库数量*/)4.createtablereader(readernochar(8)notnull,/*读者编号*/readernamevarchar(8)notnull,/*姓名*/sexchar(2)null,/*性别*/identifycardchar(18)null,/*身份证号*/workunitvarchar(50)null,/*工作单位*/borrowcounttinyintnull/*借书数量*/)5.createtableborrow(readernochar(8)notnull,/*读者编号*/booknochar(10)notnull,/*图书编号*/borrowdatedatetimenotnull,/*借阅时间*/shoulddatedatetimenotnull,/*应归还日期*/returndatedatetimenull/*归还日期*/)6.altertablebookaltercolumnpublishingnamevarchar(20)notnullaltertablebookaltercolumnshopdatedatetimenotnullaltertablereaderaltercolumnidentifycardchar(18)notnull