SHOW:
|
|
- or go back to the newest paste.
| 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); |
