Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Customers(Customer_No Number PRIMARY KEY NOT NULL,Name VARCHAR2(50) NOT NULL,Email VARCHAR2(40) NOT NULL);
- Create Table Orders(Order_NO Number PRIMARY KEY NOT NULL, Order_Date VARCHAR2(10) NOT NULL,Handling_Cost Number NOT NULL,Customer_No NUMBER REFERENCES Customers(Customer_No) NOT NULL);
- Create Table Products(Product_No NUMBER PRIMARY KEY NOT NULL , Product_Name VARCHAR2(50) NOT NULL , List_Price NUMBER NOT NULL );
- Create Table Includes(Order_NO NUMBER REFERENCES Orders(Order_NO) NOT NULL,Product_No NUMBER REFERENCES Products(Product_No) NOT NULL,Unit_Price NUMBER NOT NULL,Quantity NUMBER NOT NULL);
Add Comment
Please, Sign In to add comment