Create two tables named Customers (havingfields / columns Customer_No, First_Nam

Q: Create two tables named Customers (havingfields / columns Customer_No, First_Nam

Create table Customers ====================== create table customers (Customer_no integer PRIMARY KEY, First_Name varchar(20), Last_Name varchar(20), Address varchar(50)); Create table Order ====================== create table Order (Order_No integer PRIMARY KEY, Customer_no references CUSTOMERS(Customer_no), Order_Date date, Promise_Date date);

ID: 3616529 • Letter: C

Question

Create two tables named Customers (havingfields / columns Customer_No, First_Name, Last_Name, and Address)and Order (having fields / `columns Order_No, Customer_No,OrderDate and PromisedDate). The relationship between thesetwo tables is one-to-many (i.e. a single Customer may have manyOrders; a single Order belongs to one and only one Customer). The code you use to create the tables must enforce uniquenessintegrity and referential integrity. Show the SQL code usedto create the tables.

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

Explanation / Answer

Create table Customers
 ======================
 create table customers
 (Customer_no integer PRIMARY KEY,
 First_Name varchar(20),
 Last_Name varchar(20),
 Address varchar(50));


 Create table Order
 ======================
 create table Order
 (Order_No integer PRIMARY KEY,
 Customer_no references CUSTOMERS(Customer_no),
 Order_Date date,
 Promise_Date date);

Navigate

Create two tables in your database as USERS(UserFullName, Username, Password) an

Create two tables, TI (ename, jobno) and T2Ciobno, jobdesc). Let jobno be data-t

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

Create two tables named Customers (havingfields / columns Customer_No, First_Nam

Question

Explanation / Answer

Related Questions

Navigate