What to Submit: Question : Create twotables named Customers (having fields / col

Question

What to Submit:

Question : Create twotables 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 link for particular data types you will use: http://msdn.microsoft.com/en-us/library/ms187752.aspx

Explanation / Answer

create table Customers

(Customer_No integer PRIMARY KEY,

First_Name varchar(15),

Last_Name varchar(15),

Address varchar(80));

SQL Command for creating Order Table is given below:-

create table Order

(Order_No integer PRIMARY KEY,

Customer_No referencesCUSTOMERS(Customer_No),

Order_Date date,

Promise_Date date);

CREATE VIEW [CustOrder]

ASSELECT [Customers].[Customer_No],[Order].[Order_No],[Customers].[First_Name], [Customers].[Last_Name]FROM [Customers],[Order]

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.