API tools faq
paste
IhorD

Products_Purchases_DDL_DML

IhorD
Jul 11th, 2025
37
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 6.99 KB | None | 0 0
raw download clone embed print report
  1. -- Table: Customer
  2. CREATE TABLE Customer (
  3.     IdCustomer INTEGER  NOT NULL,
  4.     FirstName nvarchar2(50)  NOT NULL,
  5.     LastName nvarchar2(50)  NOT NULL,
  6.     DateOfBi DATE  NOT NULL,
  7.     CONSTRAINT Customer_pk PRIMARY KEY (IdCustomer)
  8. ) ;
  9.  
  10. -- Table: Product
  11. CREATE TABLE Product (
  12.     IdProduct INTEGER  NOT NULL,
  13.     Product nvarchar2(50)  NOT NULL,
  14.     Price NUMBER(7,2)  NOT NULL,
  15.     Decription nvarchar2(150)  NULL,
  16.     CONSTRAINT Product_pk PRIMARY KEY (IdProduct)
  17. ) ;
  18.  
  19. -- Table: Purchase
  20. CREATE TABLE Purchase (
  21.     IdPurchase INTEGER  NOT NULL,
  22.     Product_IdProduct INTEGER  NOT NULL,
  23.     Customer_IdCustomer INTEGER  NOT NULL,
  24.     "Date" DATE  NOT NULL,
  25.     Quantity INTEGER  NOT NULL,
  26.     CONSTRAINT Purchase_pk PRIMARY KEY (IdPurchase)
  27. ) ;
  28.  
  29. -- Reference: Purchase_Customer (table: Purchase)
  30. ALTER TABLE Purchase ADD CONSTRAINT Purchase_Customer
  31.     FOREIGN KEY (Customer_IdCustomer)
  32.     REFERENCES Customer (IdCustomer);
  33.  
  34. -- Reference: Purchase_Product (table: Purchase)
  35. ALTER TABLE Purchase ADD CONSTRAINT Purchase_Product
  36.     FOREIGN KEY (Product_IdProduct)
  37.     REFERENCES Product (IdProduct);
  38.  
  39. -- Insert sample data into Customer table
  40. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  41. (1, 'John', 'Smith', DATE '1985-03-15');
  42.  
  43. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  44. (2, 'Sarah', 'Johnson', DATE '1990-07-22');
  45.  
  46. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  47. (3, 'Michael', 'Brown', DATE '1978-11-08');
  48.  
  49. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  50. (4, 'Emily', 'Davis', DATE '1992-01-14');
  51.  
  52. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  53. (5, 'David', 'Wilson', DATE '1987-09-03');
  54.  
  55. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  56. (6, 'Jessica', 'Garcia', DATE '1995-05-18');
  57.  
  58. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  59. (7, 'Christopher', 'Miller', DATE '1983-12-27');
  60.  
  61. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  62. (8, 'Amanda', 'Martinez', DATE '1988-04-11');
  63.  
  64. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  65. (9, 'Robert', 'Anderson', DATE '1976-08-30');
  66.  
  67. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  68. (10, 'Lisa', 'Taylor', DATE '1993-02-07');
  69.  
  70. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  71. (11, 'James', 'Thomas', DATE '1981-06-19');
  72.  
  73. INSERT INTO Customer (IdCustomer, FirstName, LastName, DateOfBi) VALUES
  74. (12, 'Jennifer', 'Jackson', DATE '1989-10-25');
  75.  
  76. -- Insert sample data into Product table
  77. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  78. (1, 'Laptop Pro 15', 1299.99, 'High-performance laptop with 16GB RAM and 512GB SSD');
  79.  
  80. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  81. (2, 'Wireless Mouse', 29.99, 'Ergonomic wireless mouse with optical sensor');
  82.  
  83. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  84. (3, 'Mechanical Keyboard', 89.99, 'RGB backlit mechanical keyboard with cherry switches');
  85.  
  86. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  87. (4, 'Monitor 27 inch', 249.99, '27-inch 1440p IPS monitor with 144Hz refresh rate');
  88.  
  89. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  90. (5, 'USB-C Hub', 45.99, '7-in-1 USB-C hub with HDMI, USB 3.0, and SD card slots');
  91.  
  92. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  93. (6, 'Webcam HD', 79.99, '1080p HD webcam with auto-focus and noise cancellation');
  94.  
  95. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  96. (7, 'Smartphone 128GB', 699.99, 'Latest smartphone with 128GB storage and triple camera');
  97.  
  98. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  99. (8, 'Bluetooth Headphones', 149.99, 'Noise-cancelling wireless headphones with 30h battery');
  100.  
  101. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  102. (9, 'Tablet 10 inch', 329.99, '10-inch tablet with 64GB storage and WiFi connectivity');
  103.  
  104. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  105. (10, 'External Hard Drive', 99.99, '2TB external hard drive with USB 3.0 connectivity');
  106.  
  107. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  108. (11, 'Gaming Chair', 199.99, 'Ergonomic gaming chair with lumbar support and armrests');
  109.  
  110. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  111. (12, 'Desk Lamp LED', 39.99, 'Adjustable LED desk lamp with touch controls');
  112.  
  113. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  114. (13, 'Power Bank 20000mAh', 34.99, 'High-capacity power bank with fast charging support');
  115.  
  116. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  117. (14, 'Wireless Charger', 24.99, 'Qi wireless charging pad compatible with most devices');
  118.  
  119. INSERT INTO Product (IdProduct, Product, Price, Decription) VALUES
  120. (15, 'Cable Management Kit', 19.99, 'Complete cable management solution with clips and ties');
  121.  
  122. -- Insert sample data into Purchase table
  123. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  124. (1, 1, 1, DATE '2024-01-15', 1);
  125.  
  126. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  127. (2, 2, 1, DATE '2024-01-15', 2);
  128.  
  129. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  130. (3, 7, 2, DATE '2024-01-18', 1);
  131.  
  132. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  133. (4, 8, 2, DATE '2024-01-18', 1);
  134.  
  135. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  136. (5, 4, 3, DATE '2024-01-22', 1);
  137.  
  138. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  139. (6, 3, 3, DATE '2024-01-22', 1);
  140.  
  141. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  142. (7, 9, 4, DATE '2024-02-01', 1);
  143.  
  144. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  145. (8, 13, 4, DATE '2024-02-01', 2);
  146.  
  147. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  148. (9, 10, 5, DATE '2024-02-05', 1);
  149.  
  150. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  151. (10, 5, 6, DATE '2024-02-10', 1);
  152.  
  153. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  154. (11, 6, 7, DATE '2024-02-14', 1);
  155.  
  156. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  157. (12, 11, 8, DATE '2024-02-18', 1);
  158.  
  159. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  160. (13, 12, 9, DATE '2024-02-22', 3);
  161.  
  162. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  163. (14, 14, 10, DATE '2024-02-25', 2);
  164.  
  165. INSERT INTO Purchase (IdPurchase, Product_IdProduct, Customer_IdCustomer, "Date", Quantity) VALUES
  166. (15, 15, 11, DATE '2024-03-01', 1);
  167.  
  168. COMMIT;
Add Comment
Please, Sign In to add comment
Public Pastes
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!