API tools faq
paste
Advertisement
IhorD

Untitled

IhorD
Jul 12th, 2025
322
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 6.68 KB | None | 0 0
raw download clone embed print report
  1. -- Table: Booking
  2. CREATE TABLE Booking (
  3.     IdBooking INTEGER  NOT NULL,
  4.     DateFrom DATE  NOT NULL,
  5.     DateTo DATE  NOT NULL,
  6.     IdGuest INTEGER  NOT NULL,
  7.     RoomNo INTEGER  NOT NULL,
  8.     Paid INTEGER  NOT NULL,
  9.     CONSTRAINT Booking_pk PRIMARY KEY (IdBooking)
  10. ) ;
  11.  
  12. -- Table: Category
  13. CREATE TABLE Category (
  14.     IdCategory INTEGER  NOT NULL,
  15.     Name VARCHAR2(20)  NOT NULL,
  16.     Price numeric(8,2)  NOT NULL,
  17.     CONSTRAINT Category_pk PRIMARY KEY (IdCategory)
  18. ) ;
  19.  
  20. -- Table: Guest
  21. CREATE TABLE Guest (
  22.     IdGuest INTEGER  NOT NULL,
  23.     FirstName VARCHAR2(20)  NOT NULL,
  24.     LastName VARCHAR2(30)  NOT NULL,
  25.     DiscountPercent INTEGER  NULL,
  26.     CONSTRAINT Guest_pk PRIMARY KEY (IdGuest)
  27. ) ;
  28.  
  29. -- Table: Room
  30. CREATE TABLE Room (
  31.     RoomNo INTEGER  NOT NULL,
  32.     IdCategory INTEGER  NOT NULL,
  33.     NumberOfBeds INTEGER  NOT NULL,
  34.     CONSTRAINT Room_pk PRIMARY KEY (RoomNo)
  35. ) ;
  36.  
  37. -- foreign keys
  38. -- Reference: FK_0 (table: Room)
  39. ALTER TABLE Room ADD CONSTRAINT FK_0
  40.     FOREIGN KEY (IdCategory)
  41.     REFERENCES Category (IdCategory);
  42.  
  43. -- Reference: FK_1 (table: Booking)
  44. ALTER TABLE Booking ADD CONSTRAINT FK_1
  45.     FOREIGN KEY (IdGuest)
  46.     REFERENCES Guest (IdGuest);
  47.  
  48. -- Reference: FK_2 (table: Booking)
  49. ALTER TABLE Booking ADD CONSTRAINT FK_2
  50.     FOREIGN KEY (RoomNo)
  51.     REFERENCES Room (RoomNo);
  52.  
  53. -- End of file.
  54.  
  55.  
  56.  
  57.  
  58. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (1, 'Marcin', 'Niewiński', 20);
  59. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (2, 'Jan', 'Kowalski', NULL);
  60. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (3, 'Andrzej', 'Nowak', 10);
  61. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (4, 'Ferdynand', 'Kiepski', 30);
  62. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (5, 'Arnold', 'Boczek', NULL);
  63. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (6, 'Marian', 'Paździoch', 5);
  64. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (7, 'Halina', 'Kiepska', 15);
  65. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (8, 'Edward', 'Listonosz', 20);
  66. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (9, 'Helena', 'Paździoch', NULL);
  67. INSERT INTO Guest (IdGuest, FirstName, LastName, DiscountPercent) VALUES (10, 'Alfred', 'Iksiński', 20);
  68.  
  69. INSERT INTO Category (IdCategory, Name, Price) VALUES (1, 'Tourist', 30);
  70. INSERT INTO Category (IdCategory, Name, Price) VALUES (2, 'Regular', 60);
  71. INSERT INTO Category (IdCategory, Name, Price) VALUES (3, 'Luxury', 120);
  72.  
  73. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (101, 1, 2);
  74. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (102, 1, 2);
  75. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (103, 1, 3);
  76. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (104, 2, 2);
  77. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (105, 2, 2);
  78. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (201, 1, 2);
  79. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (202, 3, 4);
  80. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (203, 3, 2);
  81. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (204, 3, 2);
  82. INSERT INTO Room (RoomNo, IdCategory, NumberOfBeds) VALUES (205, 2, 3);
  83.  
  84. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (1, TO_DATE('2009-07-01', 'YYYY-MM-DD'), TO_DATE('2009-07-05', 'YYYY-MM-DD'), 1, 101, 1);
  85. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (2, TO_DATE('2008-01-03', 'YYYY-MM-DD'), TO_DATE('2008-01-15', 'YYYY-MM-DD'), 1, 102, 1);
  86. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (3, TO_DATE('2009-07-15', 'YYYY-MM-DD'), TO_DATE('2009-08-02', 'YYYY-MM-DD'), 2, 101, 1);
  87. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (4, TO_DATE('2008-12-12', 'YYYY-MM-DD'), TO_DATE('2008-12-14', 'YYYY-MM-DD'), 3, 103, 1);
  88. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (5, TO_DATE('2009-05-01', 'YYYY-MM-DD'), TO_DATE('2009-05-05', 'YYYY-MM-DD'), 3, 201, 1);
  89. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (6, TO_DATE('2009-04-01', 'YYYY-MM-DD'), TO_DATE('2009-05-01', 'YYYY-MM-DD'), 4, 201, 0);
  90. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (7, TO_DATE('2008-11-15', 'YYYY-MM-DD'), TO_DATE('2008-11-20', 'YYYY-MM-DD'), 4, 105, 0);
  91. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (8, TO_DATE('2009-10-01', 'YYYY-MM-DD'), TO_DATE('2009-10-07', 'YYYY-MM-DD'), 10, 104, 1);
  92. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (9, TO_DATE('2009-07-03', 'YYYY-MM-DD'), TO_DATE('2009-07-20', 'YYYY-MM-DD'), 10, 204, 1);
  93. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (10, TO_DATE('2009-03-12', 'YYYY-MM-DD'), TO_DATE('2009-03-20', 'YYYY-MM-DD'), 9, 201, 1);
  94. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (11, TO_DATE('2009-12-01', 'YYYY-MM-DD'), TO_DATE('2009-12-02', 'YYYY-MM-DD'), 9, 202, 1);
  95. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (12, TO_DATE('2009-12-01', 'YYYY-MM-DD'), TO_DATE('2009-12-10', 'YYYY-MM-DD'), 8, 202, 1);
  96. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (13, TO_DATE('2008-03-03', 'YYYY-MM-DD'), TO_DATE('2008-03-12', 'YYYY-MM-DD'), 1, 203, 0);
  97. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (14, TO_DATE('2009-08-25', 'YYYY-MM-DD'), TO_DATE('2009-09-01', 'YYYY-MM-DD'), 6, 205, 1);
  98. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (15, TO_DATE('2009-04-16', 'YYYY-MM-DD'), TO_DATE('2009-04-21', 'YYYY-MM-DD'), 6, 101, 0);
  99. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (16, TO_DATE('2009-04-17', 'YYYY-MM-DD'), TO_DATE('2009-04-20', 'YYYY-MM-DD'), 6, 105, 1);
  100. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (17, TO_DATE('2009-02-12', 'YYYY-MM-DD'), TO_DATE('2009-02-14', 'YYYY-MM-DD'), 5, 104, 1);
  101. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (18, TO_DATE('2008-11-10', 'YYYY-MM-DD'), TO_DATE('2008-11-20', 'YYYY-MM-DD'), 1, 103, 1);
  102. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (19, TO_DATE('2009-06-07', 'YYYY-MM-DD'), TO_DATE('2009-06-15', 'YYYY-MM-DD'), 2, 101, 1);
  103. INSERT INTO Booking (IdBooking, DateFrom, DateTo, IdGuest, RoomNo, Paid) VALUES (20, TO_DATE('2009-07-01', 'YYYY-MM-DD'), TO_DATE('2009-07-05', 'YYYY-MM-DD'), 3, 101, 1);
  104.  
  105.  
  106.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!