资源描述：
《酒店管理系统数据库代码》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、酒店管理系统数据库代码useHotel_Management1select*fromCustomerselect*fromEmployeeselect*fromRoomTypeselect*fromRoomselect*fromOrderInfoselect*fromCheckoutdropdatabaseHotel_Management1------------------------创建数据库Hotel_Management--------------------------------------------
2、--------------------------createdatabaseHotel_MDBonprimary(name=Hotel_Management1,filename='F:Hotel_ManagementHotel_Management.MDF',size=10MB,filegrowth=20%)logon(name=Hotel_Management1,filename='F:Hotel_ManagementHotel_Management1.LDF',size=10MB,filegrowt
3、h=2MB)--使用数据库USEHotel_Management1--------------------------------------------创建表-----------------------------------------------------------------1顾客表createtableCustomer(CustomerIDintprimarykey,CustomerNamenvarchar(40)notnull,CustomerInfonvarchar(18)notnull,Cse
4、xnvarchar(1),CPhonenvarchar(11)notnull,Notesntext)--droptableCustomer--2员工表精选范本,供参考！createtableEmployee(EmployeeIDintprimarykey,UserNamenvarchar(40)notnull,Passwordnvarchar(40)notnull,EmployeeNamenvarchar(40)notnull,Esexnvarchar(1),EPhonenvarchar(11)notnull,No
5、tesntext)--3客房表(有外键)createtableRoom(RoomIDintprimarykey,RoomTypeIDintnotnull,RoomStatenvarchar(1)notnull,Notesntext,FOREIGNKEY(RoomTypeID)REFERENCESRoomType(RoomTypeID),)--droptableRoom--4客房类型表(有外键)createtableRoomType(RoomTypeIDintprimarykey,RoomTypeNamenchar(
6、20)notnull,Costfloat,Totalint,Surplusint,Notesntext,)--droptableRoomType--5订房表select*fromOrderInfocreatetableOrderInfo(OrderIDintnotnullprimarykey,RoomIDintnotnull,CustomerIDint,EmployeeIDint,Entertimedatetimenotnull,Depositfloat,ORstaticnvarchar(10)notnull,No
7、tesntext,FOREIGNKEY(CustomerID)REFERENCESCustomer(CustomerID),FOREIGNKEY(RoomID)REFERENCESRoom(RoomID),精选范本,供参考！FOREIGNKEY(EmployeeID)REFERENCESEmployee(EmployeeID),)--altertableaddconstraintOI_DORstaticdefault'use'--droptableOrderInfo--6退房表check-outcreatetabl
8、eCheckout(CheckoutIDintprimarykey,RoomIDintnotnull,CustomerIDint,EmployeeIDint,Entertimedatetimenotnull,Endtimedatetimenotnull,Total_consumptionfloat,Notesntext,FOREIGNKEY(Employee
