Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Customer
- (
- Customer_Id NUMBER PRIMARY KEY,
- Cust_First_Name varchar2(50),
- Cust_Last_Name varchar2(50)
- )
- CREATE TABLE Orders
- (
- Order_Id NUMBER PRIMARY KEY,
- Customer_Id NUMBER NOT NULL REFERENCES Customer(Customer_Id)
- )
- CREATE TABLE Product_Info
- (
- Product_Id NUMBER PRIMARY KEY,
- Product_Name varchar2(50),
- Category varchar2(50)
- )
- CREATE TABLE Order_Items
- (
- Order_Item_Id NUMBER PRIMARY KEY,
- Order_Id NUMBER NOT NULL REFERENCES Orders(Order_Id),
- Product_Id NUMBER NOT NULL REFERENCES Product_Info(Product_Id)
- )
- INSERT INTO Customer VALUES ('1','Martin','Davids')
- INSERT INTO Customer VALUES ('2','John','Hugs')
- INSERT INTO Customer VALUES ('3','Maria','Shay')
- INSERT INTO Customer VALUES ('4','Mallorie','Hay')
- INSERT INTO Customer VALUES ('5','Sophia','Valdes')
- INSERT INTO Orders VALUES ('1','1')
- INSERT INTO Orders VALUES ('2','1')
- INSERT INTO Orders VALUES ('3','2')
- INSERT INTO Orders VALUES ('4','2')
- INSERT INTO Orders VALUES ('5','2')
- INSERT INTO Orders VALUES ('6','3')
- INSERT INTO Orders VALUES ('7','4')
- INSERT INTO Order_items VALUES ('20','1','1')
- INSERT INTO Order_items VALUES ('21','2','1')
- INSERT INTO Order_items VALUES ('22','2','3')
- INSERT INTO Order_items VALUES ('23','1','2')
- INSERT INTO Order_items VALUES ('24','2','2')
- INSERT INTO Order_items VALUES ('25','3','1')
- INSERT INTO Order_items VALUES ('26','4','1')
- INSERT INTO Order_items VALUES ('27','5','1')
- INSERT INTO Order_items VALUES ('28','6','2')
- INSERT INTO Order_items VALUES ('29','6','1')
- INSERT INTO Order_items VALUES ('30','6','3')
- INSERT INTO Order_items VALUES ('31','7','5')
- INSERT INTO Product_info VALUES ('1','Lenovo netbook','Computer')
- INSERT INTO Product_info VALUES ('2','Dell PC','Computer')
- INSERT INTO Product_info VALUES ('3','MSI All-in-one','Computer')
- INSERT INTO Product_info VALUES ('4','Samsung','Dishwasher')
- INSERT INTO Product_info VALUES ('5','Panasonic SmartTv','TV')
- INSERT INTO Product_info VALUES ('6','Phillips','Toaster')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement