Question No.1 Create two tables namedCustomers (having fields / columns Customer

Question

Question No.1

Create two tables namedCustomers (having fields / columns Customer_No, First_Name,Last_Name, and Address) and Order (having fields / `columnsOrder_No, Customer_No, OrderDate and PromisedDate). Therelationship between these two tables is one-to-many (i.e. a singleCustomer may have many Orders; a single Order belongs to one andonly one Customer). The code you use to create the tablesmust enforce uniqueness integrity and referential integrity. Show the SQL code used to create the tables.

Visit this link forparticular data types you will use: http://msdn.microsoft.com/en-us/library/ms187752.aspx

Question No.2

Explanation / Answer

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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