create database hotel; use hotel go -- Creating a Table Menu CREATE TABLE Menu ( menuID int identity primary key, itemName varchar(100) unique, description varchar(100), price float, category varchar(100) ); -- check for table creation SELECT * FROM Menu; -- create table user CREATE TABLE Users ( userID int identity primary key, username varchar(100), password nvarchar(100), email varchar(100), role varchar(100) ); -- check for table creation SELECT * FROM Users; -- create table customer CREATE TABLE Customer ( customerID int identity primary key, userID int, phoneNumber varchar(15), address varchar(100), checkIn datetime, checkOut datetime, foreign key (userID) References Users(userID) ); -- check for table creation SELECT * FROM Customer; -- create table department CREATE TABLE Department ( departmentID int identity primary key, departmentName varchar(100) ) -- create table staff CREATE TABLE Staffs ( staffID int identity primary key, userID int, departmentID int, position varchar(100), salary float, FOREIGN KEY (userID) REFERENCES Users(userID), FOREIGN KEY (departmentID) REFERENCES Department(departmentID), ); -- check for table creation SELECT * FROM Staffs; -- create table room CREATE TABLE Rooms ( roomID int identity primary key, roomNumber int, beds int, status varchar(20), ); -- check for table creation select * from rooms; -- create table order CREATE TABLE Orders ( orderID int identity primary key, menuID int, customerID int, roomID int, quantity int, orderTime datetime, status varchar(100), FOREIGN KEY (menuID) REFERENCES Menu(menuID), FOREIGN KEY (customerID) REFERENCES Customer(customerID), FOREIGN KEY (roomID) REFERENCES Rooms(roomID) ); SELECT * FROM Orders; -- create table reservation CREATE TABLE Bookings ( bookingID int identity primary key, customerID int, roomID int, checkIn datetime, checkOut datetime, FOREIGN KEY (customerID) REFERENCES Customer(customerID), FOREIGN KEY (roomID) REFERENCES Rooms(roomID) ); select * from bookings