Question No. 1 Createtwo tables named Customers (having fields / columnsCustomer

Question

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.

Explanation / Answer

SQL Command for creating customer table is given below:-

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 references CUSTOMERS(Customer_No),

Order_Date date,

Promise_Date date);

Hope you will rate higher…

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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