Advertisement
Guest User

sqlschema

a guest
Jun 22nd, 2012
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.97 KB | None | 0 0
  1. CREATE TABLE Customer
  2. (
  3. Customer_Id NUMBER PRIMARY KEY,
  4. Cust_First_Name varchar2(50),
  5. Cust_Last_Name varchar2(50)
  6. )
  7.  
  8. CREATE TABLE Orders
  9. (
  10. Order_Id NUMBER PRIMARY KEY,
  11. Customer_Id NUMBER NOT NULL REFERENCES Customer(Customer_Id)
  12. )
  13.  
  14. CREATE TABLE Product_Info
  15. (
  16. Product_Id NUMBER PRIMARY KEY,
  17. Product_Name varchar2(50),
  18. Category varchar2(50)
  19. )
  20.  
  21. CREATE TABLE Order_Items
  22. (
  23. Order_Item_Id NUMBER PRIMARY KEY,
  24. Order_Id NUMBER NOT NULL REFERENCES Orders(Order_Id),
  25. Product_Id NUMBER NOT NULL REFERENCES Product_Info(Product_Id)
  26. )
  27.  
  28. INSERT INTO Customer VALUES ('1','Martin','Davids')
  29. INSERT INTO Customer VALUES ('2','John','Hugs')
  30. INSERT INTO Customer VALUES ('3','Maria','Shay')
  31. INSERT INTO Customer VALUES ('4','Mallorie','Hay')
  32. INSERT INTO Customer VALUES ('5','Sophia','Valdes')
  33.  
  34. INSERT INTO Orders VALUES ('1','1')
  35. INSERT INTO Orders VALUES ('2','1')
  36. INSERT INTO Orders VALUES ('3','2')
  37. INSERT INTO Orders VALUES ('4','2')
  38. INSERT INTO Orders VALUES ('5','2')
  39. INSERT INTO Orders VALUES ('6','3')
  40. INSERT INTO Orders VALUES ('7','4')
  41.  
  42. INSERT INTO Order_items VALUES ('20','1','1')
  43. INSERT INTO Order_items VALUES ('21','2','1')
  44. INSERT INTO Order_items VALUES ('22','2','3')
  45. INSERT INTO Order_items VALUES ('23','1','2')
  46. INSERT INTO Order_items VALUES ('24','2','2')
  47. INSERT INTO Order_items VALUES ('25','3','1')
  48. INSERT INTO Order_items VALUES ('26','4','1')
  49. INSERT INTO Order_items VALUES ('27','5','1')
  50. INSERT INTO Order_items VALUES ('28','6','2')
  51. INSERT INTO Order_items VALUES ('29','6','1')
  52. INSERT INTO Order_items VALUES ('30','6','3')
  53. INSERT INTO Order_items VALUES ('31','7','5')
  54.  
  55. INSERT INTO Product_info VALUES ('1','Lenovo netbook','Computer')
  56. INSERT INTO Product_info VALUES ('2','Dell PC','Computer')
  57. INSERT INTO Product_info VALUES ('3','MSI All-in-one','Computer')
  58. INSERT INTO Product_info VALUES ('4','Samsung','Dishwasher')
  59. INSERT INTO Product_info VALUES ('5','Panasonic SmartTv','TV')
  60. INSERT INTO Product_info VALUES ('6','Phillips','Toaster')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement