CREATE TABLE Hotels(
	hotel_number int NOT NULL,
	hotel_name varchar(50) NOT NULL,
	City varchar(20) NOT NULL)

CREATE TABLE Rooms(
	room_number int NOT NULL,
	hotel_number int NOT NULL,
	type varchar(10) NOT NULL,
	price money NOT NULL)

 CREATE TABLE Guests(
	guest_number int NOT NULL,
	guest_name varchar(50) NOT NULL,
	guest_addressvarchar(100) NOT NULL)

CREATE TABLE Bookings(
	hotel_number int NOT NULL,
	guest_number int NOT NULL,
	room_number int NOT NULL,
	date_from date NOT NULL),
	date_to date NOT NULL);

INSERT INTO Hotels VALUES	(1,'SOGO','Pasay')
INSERT INTO Hotels VALUES	(2,'Victoria Court','Manila')
INSERT INTO Hotels VALUES	(3,'Astrotel','Paranaque')
INSERT INTO Hotels VALUES	(4,'Euretol','Las Pinas')
INSERT INTO Hotels VALUES	(5,'Shangri-la','Makati')
INSERT INTO Hotels VALUES	(6,'Holiday Inn','Manila')
INSERT INTO Hotels VALUES	(7,'Microtel','Boracay')
INSERT INTO Hotels VALUES	(8,'Diplomat Hotel','Baguio')
INSERT INTO Hotels VALUES	(9,'St.Giles','Makati')
INSERT INTO Hotels VALUES	(10,'Nobu','Pasay')
GO

INSERT INTO Rooms VALUES	(312,1,'1BR',699)
INSERT INTO Rooms VALUES	(411,2,'2BR',1499)
INSERT INTO Rooms VALUES	(101,3,'1BR',499)
INSERT INTO Rooms VALUES	(209,4,'1BR',899)
INSERT INTO Rooms VALUES	(1001,5,'PENT',16999)
INSERT INTO Rooms VALUES	(888,6,'3BR',12999)
INSERT INTO Rooms VALUES	(100,7,'1BR',1099)
INSERT INTO Rooms VALUES	(212,8,'2BR',7999)
INSERT INTO Rooms VALUES	(900,9,'PENT',18999)
INSERT INTO Rooms VALUES	(11111,10,'PENT',23999)
GO

INSERT INTO Guests VALUES	(10,'Dani','Manila')
INSERT INTO Guests VALUES	(11,'Edward','Pasay')
INSERT INTO Guests VALUES	(12,'Jairus','Las Pinas')
INSERT INTO Guests VALUES	(13,'Charl','Makati')
INSERT INTO Guests VALUES	(14,'Francis','Makati')
INSERT INTO Guests VALUES	(15,'Kevin','Pasay')
INSERT INTO Guests VALUES	(16,'Kenneth','Makati')
INSERT INTO Guests VALUES	(17,'John','Cavite')
INSERT INTO Guests VALUES	(18,'Harry','Manila')
INSERT INTO Guests VALUES	(19,'David','Las Pinas')
GO
INSERT INTO Bookings VALUES	(1,10,312,'7/17/19','7/18/19')
INSERT INTO Bookings VALUES	(2,11,411,'6/18/19','6/17/19')
INSERT INTO Bookings VALUES	(3,12,101,'5/20/19','5/20/19')
INSERT INTO Bookings VALUES	(4,13,209,'8/15/19','8/20/19')
INSERT INTO Bookings VALUES	(5,14,1011,'7/8/19','7/9/19')
INSERT INTO Bookings VALUES	(6,15,888,'7/22/19','7/24/19')
INSERT INTO Bookings VALUES	(7,16,100,'7/1/19','7/2/19')
INSERT INTO Bookings VALUES	(8,17,212,'8/28/19','9/1/19')
INSERT INTO Bookings VALUES	(9,18,900,'7/29/19','8/2/19')
INSERT INTO Bookings VALUES	(10,19,11111,'6/1/19','7/1/19')
GO