create table Orders( OrderID nvarchar (10) primary key, Date date, CustomerID nvarchar (5), Amount float foreign key (CustomerID) references Customers(CustomerID) )
