Question: following SQL statements, some tables are created with different constraints. Give two foreign key constraints and specify in which table each is given? CREATE

following SQL statements, some tables are created with different constraints. Give two foreign key

following SQL statements, some tables are created with different constraints. Give two foreign key constraints and specify in which table each is given? CREATE TABLE Customer T (Customer D CustomerName Customer Address CustomerCity CustomerState NUMBER(11,0) VARCHAR2(25) CustomerPostalCode CONSTRAINT Customer_PK PRIMARY KEY (CustomerID)); CREATE TABLE Product T (ProductID Product Description ProductFinish Product Standard Price VARCHAR2(30), VARCHAR2(20), CHAR(2), VARCHAR2(9), CREATE TABLE Order T (OrderID OrderDate Customer D CONSTRAINT Order_PK PRIMARY KEY (OrderID), CONSTRAINT Order FK FOREIGN KEY (CustomerID) REFERENCES Customer T (CustomerID)); CREATE TABLE OrderLine T (OrderID ProductID NOT NULL, NOT NULL, NUMBER(11,0) DATE DEFAULT SYSDATE, NUMBER(11,0), NUMBER(11,0) VARCHAR2(50), VARCHAR2(20), DECIMAL (6,2), NUMBER(11,0), ProductLineID CONSTRAINT Product PK PRIMARY KEY (ProductID)); NOT NULL, NOT NULL, NUMBER(11,0) NUMBER(11,0) OrderedQuantity NUMBER(11,0), CONSTRAINT OrderLine PK PRIMARY KEY (OrderID, ProductID), CONSTRAINT OrderLine_FK1 FOREIGN KEY (OrderID) REFERENCES Order_T (OrderID), CONSTRAINT OrderLine FK2 FOREIGN KEY (ProductID) REFERENCES Product_T (ProductID)); NOT NULL, NOT NULL,

Step by Step Solution

★★★★★

3.53 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Query to add artistid foreign key constraint ... View full answer

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!

Find all mixed strategy Nash Equilibria of the game in table 4 by first eliminating any strictly dominated actions and then constructing the players' best response functions. Player 2 LMR T 2,2 0,3...

1. What are common shares and preferred shares, and what are the key differences between the two? 2. What factors should investors consider when evaluating a company's shares for potential...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

Homework #3 Due: see Syllabus Total: 20 Points What to submit: Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen...

CIS-336: Lab7: Working with Views LAB OVERVIEW Lab 7 will introduce the concept of database views. This lab may be completed using either DeVrys Omnymbus EDUPE-APP lab environment, or a local copy of...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

1. We will create a concerts database: create the following tables that will store information about 11. Write the SQL statement to update the performance type name for 'dancer performance types (ex....

Part 1: Atlas Corporate Human Resource Data Requirements This document describes the needs of the Atlas Corporate Human Resources department in managing the data surrounded its employees and their...

You buy a constant growth stock today for $100. It pays a dividend in year 1 of $5 and grows at 10 percent per year. Draw a cashflow diagram for the stock if you sell it at the end of year 2. What is...

Use the ML Practitioner Assessment project to answer this question. Which two of the following statements about the "grade" column in the schools_data dataset are true? It has a mean of 10.56 and a...

= CPPREP4104 Establish buyer re lationships -NSW ? Item 10 of 13 You have received two (2) first home buyer enquiries via email - they have both filled out a buyer profile. Open and read through...

1. The December 31, 2010, balance sheet of Ming Inc. included 12% bonds with a face amount of $100 million. The bonds were issued in 1998 and had a remaining discount of $3,400,000 at December 31,...

Compare the properties of a simple ester, for instance, methyl acetate, with those of a salt, for instance, sodium chloride.

When a mass of 2 kilograms is attached to a spring whose constant is 32 N/m, it comes to rest in the equilibrium position. Starting at t = 0, a force equal to f(t) = 68e -2t cos 4t is applied to the...

3. As shown in the figure, a closely wound toroidal coil inner radius a and outer radius b have N turns and carry a current I. Find the magnetic flux density distribution. 1 1

The information below shows the cost for a year of college at a public and at a private college in 200809 and 201819. For the period of time between 200809 and 201819, what is the annual rate of...

The accounting basis that records revenues when cash is received and expenses when cash is paid is referred to as: Multiple Choice Accrual - basis. Reporting - basis. Cash - basis. Realization -...

In Example 23 on page 58, would you get the same result if you performed the PROJECT command before the JOIN command? Why or why not?

What is a sub query? When is a sub query executed?

For the following exercises, you will answer problems and questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. Fragment the...

What is the maximum amount of foreign tax credit that a company will be allowed to take with respect to the income earned by a foreign operation?

What is the difference between the worldwide and territorial approaches to taxation?

Avioco Limited has two branches located in Hong Kong and Australia, each of which manufactures goods primarily for export to countries in the Asia-Pacific region. The corporate income tax rate in...