CREATE TABLE `GUESTS` (
	`Guest_Id` int PRIMARY KEY,
	`Fname` varchar(255),
	`Mname` varchar(255),
	`Lname` varchar(255),
	`Sex` varchar(255),
	`Nationality` varchar(255)
);
CREATE TABLE `RESERVATION` (
	`Reservation_Code` int PRIMARY KEY,
	`Guest_Id` int,
	`Date` datetime,
	`Check-In_Date` datetime,
	`Check-Out_Date` datetime,
	`IsCancelled` bool,
	`Payment` varchar,
	FOREIGN KEY(`Guest_Id`) REFERENCES `GUESTS` (`Guest_Id`)
);
CREATE TABLE `ROOMS` (
	`Room_No` int PRIMARY KEY,
	`RoomType_Code` varchar(255),
	`Floor_No` int,
	`IsOccupied` bool,
	`Free_Date` datetime,
	`Reservation_Code` int,
	FOREIGN KEY(`RoomType_Code`) REFERENCES `ROOM_TYPES` (`RoomType_Code`),
	FOREIGN KEY(`Reservation_Code`) REFERENCES `RESERVATION` (`Reservation_Code`)
);
CREATE TABLE `ROOM_TYPES` (
	`RoomType_Code` int PRIMARY KEY,
	`RoomType_Name` varchar(255),
	`Amenities` varchar(255),
	`Capacity` varchar(255),
	`Rate` varchar(255)
);