Guest User

Untitled

a guest
Feb 18th, 2019
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. create table Customers(Customer_No Number PRIMARY KEY NOT NULL,Name VARCHAR2(50) NOT NULL,Email VARCHAR2(40) NOT NULL);
  2.  
  3. 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);
  4.  
  5. Create Table Products(Product_No NUMBER PRIMARY KEY NOT NULL , Product_Name VARCHAR2(50) NOT NULL , List_Price NUMBER NOT NULL );
  6.  
  7. 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