This assignmentshould be completed individually. If you work in a group, it isyo
ID: 3616548 • Letter: T
Question
This assignmentshould be completed individually. If you work in a group, it isyour responsibility to understand all of the material your groupproduces to ensure that you are prepared for questions on the finalexamination.
What to Submit:
Question No. 1
Createtwo tables named Customers (having fields / columnsCustomer_No, First_Name, Last_Name, and Address) and Order (havingfields / `columns Order_No, Customer_No, OrderDate andPromisedDate). The relationship between these two tables isone-to-many (i.e. a single Customer may have many Orders; a singleOrder belongs to one and only one Customer). The code you useto create the tables must enforce uniqueness integrity andreferential integrity. Show the SQL code used to create thetables.
Visit this linkfor particular data types you will use: http://msdn.microsoft.com/en-us/library/ms187752.aspx
Question No. 2
Create aview named CustOrder that includes thefollowing fields: Customer_No, Order_No, First_Name andLast_Name. Show the SQL code used to create this view.
UploadInstructions
Explanation / Answer
CREATE TABLECustomers { Customer_Number int PRIMARYKEY, First_Namevarchar(20), Last_Namevarchar(20), Address varchar(100)) };CREATE TABLE Order { Order_No int PRIMARYKEY, Customer_Number REFERENCESCustomers(Customer_Number), Order_Date date, Promise_Date date };
Answer No.2
CREATEVIEW [CustOrder] AS SELECT Customer_Number, Order_No, First_Name,Last_Name FROMCustomers, Order;
CREATE TABLE Order { Order_No int PRIMARYKEY, Customer_Number REFERENCESCustomers(Customer_Number), Order_Date date, Promise_Date date };
Answer No.2
CREATEVIEW [CustOrder] AS SELECT Customer_Number, Order_No, First_Name,Last_Name FROMCustomers, Order;
CREATEVIEW [CustOrder] AS SELECT Customer_Number, Order_No, First_Name,Last_Name FROMCustomers, Order;