Question: CREATE TABLE purchase_order ( order_number int NOT NULL, order_name char(50) NOT NULL, customer_address char(50), customer_zip int, customer_city char (50), order_total varchar(50), CONSTRAINT purchase_order_pk PRIMARY KEY

CREATE TABLE purchase_order ( order_number int NOT NULL, order_name char(50) NOT NULL, customer_address char(50), customer_zip int, customer_city char (50), order_total varchar(50), CONSTRAINT purchase_order_pk PRIMARY KEY (order_number) );

What is the code to add the foreign key for this table? Can you please add the entire code with mine included. Thank you in advance.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CREATE TABLE purchase_order ( order_number int NOT NULL, order_name char(50) NOT NULL, customer_address char(50), customer_zip int, customer_city char (50), order_total varchar(50), vendor_ID...

CREATE TABLE vendor ( vendor_id int NOT NULL, vendor_name char(50) NOT NULL, contact_name char(50), CONSTRAINT vendors_pk PRIMARY KEY (vendor_id) ); I cant find the foreign key for this table? CREATE...

8. Find out other warehouses whose average quantity on hand is not smaller than That of Atlanta warehouse. 9. List skus and descriptions for all products whose sku starts with a "2". Use the BETWEEN...

Query writing and relational algebra Expression, Write the following 4 QUESTION USING sql queries AND if needed using the Cape Codd DB on bottom 13. Get a list of departments and the total items on...

Query writing and relational algebra Expression Write the following sql queries using the Cape Codd DB on bottom 1. Write a SQL statement to show sku and Description for all products having a SKU...

Write the following sql queries using the Cape Codd DB on the bottom.. 4. Find out the total revenue collected by each store. 5. Which department is associated with the highest revenue? 6. Which...

Query writing and relational algebra Expression Write the following sql queries using the Cape Codd DB on bottom 8. Find out other warehouses whose average quantity on hand is not smaller than That...

1. Write a SQL statement to show sku and Description for all products having a SKU description that includes the word foot. 2. Write a SQL statement to display the warehouse and a count of...

11. List all order items for products currently out of stock in Atlanta. Use a subquery. 12. Get a list of buyers and their departments for any products out of stock (at any warehouse, not all...

The electron configuration for a chlorine atom is: 1s2 2s2 2p63s2 3p5. What electron configuration represents the electrons thatmake up only the core electrons for a chlorine atom? A. 1s2 2s2 2p6 3s2...

Often, we wish to monitor a Continuous-state system whose behavior switches unpredictably among a set of k distinct ?modes.? For example, an aircraft trying to evade a missile can execute a series of...

5 8 , 6 , 4 - 2 n e 2 5 q , The most liquid of the money market securities are: 0 : 2 8 : 2 1 Multiple Choice commercial paper. banker's acceptances. T - bills. Fed funds. repurchase agreements. Prev...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

The chapter notes that the rise in the U.S. trade deficit during the 1980s was due largely to the rise in the U.S. budget deficit. On the other hand, the popular press sometimes claims that the...

In 1998, the Russian government defaulted on its debt payments, leading investors worldwide to raise their preference for U.S. government bonds, which are considered very safe. What effect do you...

A case study in the chapter analyzed purchasing-power parity for several countries using the price of Big Macs. Here are data for a few more countries: Predicted Country Big Mac Rate Rate Indonesia...