How to do I add the foreign keys to the commands below: 1. create table vendor (

Question

How to do I add the foreign keys to the commands below:

1.

create table vendor (V_VendorID NUMBER,V_VendorName VARCHAR(20) ,V_PhoneNumber NUMBER, V_Address VARCHAR(20), V_DirectToStore VARCHAR(10),
V_Status VARCHAR(5),V_LastUpdatedBy DATE, V_Password VARCHAR(10), V_LasteUpdateTime TIMESTAMP,PRIMARY KEY(V_VendorID,V_vendorName));

2.

create table Purchase_Order(P_OrderNo number PRIMARY KEY,P_NameofRetailer varchar(20),P_VendorID number refeeences vendor(V_VendorID),P_VendorAddress varchar(20) references vendor(V_Address),P_Quantity number,
P_UnitPrice number,P_TotalAmount number);

3,

create table Inventory(I_Flower_Name varchar(20) ,I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY
(I_Flower_Name,I_FlowerNumber));

Below you will see the uml diagram.

Customer Employee Vendor Purchase Order C Number (PK) C Lname C Fname C_Address 1 C_Address 2 C_City C State C_Zip4 C Phone1 C_Comments Emp_ID (PK) Emp_Lname Emp_Fhame EMP_SSN Emp_Address1 Emp_Address2 Emp City Emp_State Emp_Zip5 Emp Zip4 Emp_PayClass (Salaried, Hourly, Commission) Emp_Position (Owner, Manager, Salesperson) Emp_Payrate _VendorlD_PK P_OrderNo (PK) P NameofRetailer (FK) P_VendorlD (FK) P_VendorAddress (FK) P _Quantity P UnitPrice P_TotalAmount VendorName (FK) V_PhoneNumber (FK) Address (FK) V_DirectToStore Status LastUpdatedBy V_Password V_LasteUpdateTime Inventory Customer Invoice Timecard Flower_Name (PK) C_Invoice Number (PK) C_Number (FK Customer) Invoice _Date ltem_Number (FK Inventory) Emp_ID (FK Employee) Payment_Cash Payment_CC Payment_Check Reg_TicketNum _FlowerNumber (FK) Location Emp_ID (FK Employee) Emp_PayClass (FK Employee) Hours Emp_Payrate (FK Employee) ICondition |_Search - Delete Add Quantity

Explanation / Answer

add foreign key to the table syntax:

alter table table_name1 add foreign key(column_name) references table_name2(column_name);

Query

1. alter table Vendor

add foreign key(V_VendorID) references Purchase_Order(P_VendorID),

add foreign key(V_Address) references Purchase_Order(P_Vendor_Address),

add foreign key(V_Vendorname) references Purchase_Order(P_VendorAddress);

2. alter table Inventory

add foreign key(I_Quantity) references Purchase_Order(P_Quantity),

add foreign key(I_FlowerName) references Customer_Invoice(Item_Number),

add foreign_key(I_Location) references Vendor(V_Address);

----------------------------------------------------------

foreign key can be added to the table during creation as

1. create table vendor (V_VendorID NUMBER,V_VendorName VARCHAR(20) ,V_PhoneNumber NUMBER, V_Address VARCHAR(20), V_DirectToStore VARCHAR(10), V_Status VARCHAR(5), V_LastUpdatedBy DATE, V_Password VARCHAR(10), V_LasteUpdateTime TIMESTAMP, PRIMARY KEY(V_VendorID,V_VendorName), foreign key(V_VendorID) references Purchase_Order(P_VendorID), foreign key(V_Address) references Purchase_Order(P_Vendor_Address),foreign key(V_Vendorname) references Purchase_Order(P_VendorAddress);

2. create table Inventory(I_Flower_Name varchar(20) ,I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY(I_Flower_Name,I_FlowerNumber), foreign key(I_Quantity) references Purchase_Order(P_Quantity), foreign key(I_FlowerName) references Customer_Invoice(Item_Number), foreign_key(I_Location) references Vendor(V_Address);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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