SHARE
TWEET

Untitled

a guest Jul 23rd, 2019 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE Hotels(
  2.     hotel_number int NOT NULL,
  3.     hotel_name varchar(50) NOT NULL,
  4.     City varchar(20) NOT NULL)
  5.  
  6. CREATE TABLE Rooms(
  7.     room_number int NOT NULL,
  8.     hotel_number int NOT NULL,
  9.     type varchar(10) NOT NULL,
  10.     price money NOT NULL)
  11.  
  12.  CREATE TABLE Guests(
  13.     guest_number int NOT NULL,
  14.     guest_name varchar(50) NOT NULL,
  15.     guest_addressvarchar(100) NOT NULL)
  16.  
  17. CREATE TABLE Bookings(
  18.     hotel_number int NOT NULL,
  19.     guest_number int NOT NULL,
  20.     room_number int NOT NULL,
  21.     date_from date NOT NULL),
  22.     date_to date NOT NULL);
  23.  
  24. INSERT INTO Hotels VALUES   (1,'SOGO','Pasay')
  25. INSERT INTO Hotels VALUES   (2,'Victoria Court','Manila')
  26. INSERT INTO Hotels VALUES   (3,'Astrotel','Paranaque')
  27. INSERT INTO Hotels VALUES   (4,'Euretol','Las Pinas')
  28. INSERT INTO Hotels VALUES   (5,'Shangri-la','Makati')
  29. INSERT INTO Hotels VALUES   (6,'Holiday Inn','Manila')
  30. INSERT INTO Hotels VALUES   (7,'Microtel','Boracay')
  31. INSERT INTO Hotels VALUES   (8,'Diplomat Hotel','Baguio')
  32. INSERT INTO Hotels VALUES   (9,'St.Giles','Makati')
  33. INSERT INTO Hotels VALUES   (10,'Nobu','Pasay')
  34. GO
  35.  
  36. INSERT INTO Rooms VALUES    (312,1,'1BR',699)
  37. INSERT INTO Rooms VALUES    (411,2,'2BR',1499)
  38. INSERT INTO Rooms VALUES    (101,3,'1BR',499)
  39. INSERT INTO Rooms VALUES    (209,4,'1BR',899)
  40. INSERT INTO Rooms VALUES    (1001,5,'PENT',16999)
  41. INSERT INTO Rooms VALUES    (888,6,'3BR',12999)
  42. INSERT INTO Rooms VALUES    (100,7,'1BR',1099)
  43. INSERT INTO Rooms VALUES    (212,8,'2BR',7999)
  44. INSERT INTO Rooms VALUES    (900,9,'PENT',18999)
  45. INSERT INTO Rooms VALUES    (11111,10,'PENT',23999)
  46. GO
  47.  
  48. INSERT INTO Guests VALUES   (10,'Dani','Manila')
  49. INSERT INTO Guests VALUES   (11,'Edward','Pasay')
  50. INSERT INTO Guests VALUES   (12,'Jairus','Las Pinas')
  51. INSERT INTO Guests VALUES   (13,'Charl','Makati')
  52. INSERT INTO Guests VALUES   (14,'Francis','Makati')
  53. INSERT INTO Guests VALUES   (15,'Kevin','Pasay')
  54. INSERT INTO Guests VALUES   (16,'Kenneth','Makati')
  55. INSERT INTO Guests VALUES   (17,'John','Cavite')
  56. INSERT INTO Guests VALUES   (18,'Harry','Manila')
  57. INSERT INTO Guests VALUES   (19,'David','Las Pinas')
  58. GO
  59. INSERT INTO Bookings VALUES (1,10,312,'7/17/19','7/18/19')
  60. INSERT INTO Bookings VALUES (2,11,411,'6/18/19','6/17/19')
  61. INSERT INTO Bookings VALUES (3,12,101,'5/20/19','5/20/19')
  62. INSERT INTO Bookings VALUES (4,13,209,'8/15/19','8/20/19')
  63. INSERT INTO Bookings VALUES (5,14,1011,'7/8/19','7/9/19')
  64. INSERT INTO Bookings VALUES (6,15,888,'7/22/19','7/24/19')
  65. INSERT INTO Bookings VALUES (7,16,100,'7/1/19','7/2/19')
  66. INSERT INTO Bookings VALUES (8,17,212,'8/28/19','9/1/19')
  67. INSERT INTO Bookings VALUES (9,18,900,'7/29/19','8/2/19')
  68. INSERT INTO Bookings VALUES (10,19,11111,'6/1/19','7/1/19')
  69. GO
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top