Foreign key: A primary key attribute in one table is the foreign key for another table. In logical way, a foreign key is used to establish a relationship between two tables. A foreign key is used for identifying a row of another table uniquely. Foreign keys are represented in italic form. ALTER TABLE Statement: “ALTER TABLE” statement comes under Data Definition Language (DDL). It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on. Syntax: The Syntax to drop constraint is as follows: ALTER TABLE table_Name ADD CONSTRAINT constraint_Name;

Question

Using nwind database, create a query to show company name, product name, and quantity for items ordered where the quantity is greater that the average quantity for that customer. If the average of a customer is 15, than items ordered by that customer with a quantity more than 15 should be shown in the results. Note quantity field is in order_details table. You must use a corelated subquery for this problem. sql workbench

Answer 1

Question

Chapter 7, Problem 11SCG

Program Plan Intro

Foreign key:

A primary key attribute in one table is the foreign key for another table. In logical way, a foreign key is used to establish a relationship between two tables.

A foreign key is used for identifying a row of another table uniquely.

Foreign keys are represented in italic form.

ALTER TABLE Statement:

“ALTER TABLE” statement comes under Data Definition Language (DDL).

It is used to modify column, add constraints, add column(s), drop column, rename column name and table name, drop constraints, and so on.

Syntax:

The Syntax to drop constraint is as follows:

ALTER TABLE table_Name ADD CONSTRAINT constraint_Name;

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Using nwind database, create a query to show company name, product name, and quantity for items ordered where the quantity is greater that the average quantity for that customer. If the average of a customer is 15, than items ordered by that customer with a quantity more than 15 should be shown in the results. Note quantity field is in order_details table. You must use a corelated subquery for this problem. sql workbench

Write an appropriate SQL query to determine if there are any students that are not registered for any modules.Sample results:STUDENT_ID STUDENTS654321 Joe, ThaboRequirementsCorrect SELECT statement used. Correct JOIN used. Correct WHERE clause. Question 7 Write an appropriate SQL query to delete the following record from the STUDENTS table: STUDENT_ID: S654321STUDENT_SURNAME: JoeSTUDENT_NAME: ThaboRequirementsCorrect DELETE statement used. Correct WHERE clause.

please assist with the following questions. need to write a syntax in SQL server. Create an UPDATE trigger called tr_check_qty on the OrderDetails table to prevent the updating of the quantity in the OrderDetails table if the quantity amount is greater than the units in stock in the Products table.