CS403

Assignment # 6
Question No. 1

Create two tables named Customers (having fields / columns Customer_No, First_Name, Last_Name, and Address) and Order (having fields / `columns Order_No, Customer_No, OrderDate and PromisedDate). The relationship between these two tables is one-to-many (i.e. a single Customer may have many Orders; a single Order belongs to one and only one Customer). The code you use to create the tables must enforce uniqueness integrity and referential integrity. Show the SQL code used to create the tables.
Visit this link for particular data types you will use: http://msdn.microsoft.com/en-us/library/ms187752.aspx

Question No. 2

Create a view named CustOrder that includes the following fields: Customer_No, Order_No, First_Name and Last_Name. Show the SQL code used to create this view.