酒店管理系统数据库代码.docx

酒店管理系统数据库代码 酒店管理系统数据库代码 PAGE PAGE 1 / 81 / 8 酒店管理系统数据库代码 use Hotel_Management1 select *from Customer select *from Employee select *from RoomType select *from Room select *from OrderInfo select *from Checkout drop database Hotel_Management1 创 建 数 据 库 Hotel_Management create database Hotel_MDB on primary ( name=Hotel_Management1, =F:\Hotel_Management\Hotel_Management.MDF, size=10MB, =20% ) log on (name=Hotel_Management1, =F:\Hotel_Management\Hotel_Management1.LDF, size=10MB, =2MB) --使用数据库 USE Hotel_Management1 创建表 --1顾客表 create table Customer (CustomerID int primary key, CustomerName nvarchar(40) not null, CustomerInfo nvarchar(18) not null, Csex nvarchar(1), CPhone nvarchar(11)not null, Notes ntext ) --drop table Customer --2员工表 酒店管理系统数据库代码 酒店管理系统数据库代码 PAGE PAGE 2 / 82 / 8 create table Employee (EmployeeID int primary key, UserName nvarchar(40) not null, Password nvarchar(40)not null, EmployeeName nvarchar(40) not null, Esex nvarchar(1), EPhone nvarchar(11)not null, Notes ntext ) --3客房表(有外键) create table Room (RoomID int primary key, RoomTypeID int not null, RoomState nvarchar(1)not null, Notes ntext, FOREIGN KEY (RoomTypeID) REFERENCES RoomType(RoomTypeID), ) --drop table Room --4客房类型表(有外键) create table RoomType (RoomTypeID int primary key, RoomTypeName nchar(20) not null, Cost float, Total int, Surplus int, Notes ntext, ) --drop table RoomType --5订房表 select* from OrderInfo create table OrderInfo (OrderID int not null primary key, RoomID int not null , CustomerID int, EmployeeID int, Entertime datetime not null, Deposit float, ORstatic nvarchar(10)not null , Notes ntext, FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID), FOREIGN KEY (RoomID) REFERENCES Room(RoomID), 酒店管理系统数据库代码 酒店管理系统数据库代码 PAGE PAGE 3 / 83 / 8 FOREIGN KEY (EmployeeID) REFERENCES Employee(EmployeeID), ) --alter table add constraint OI_D ORstatic default use --drop table OrderInfo --6退房表check-out create table Checkout (CheckoutID int primary key, RoomID int not null, CustomerID