Question: Suppose you wanted quick lookup capability to get a listing of all productssupplied by a given vendor. Create a view that lists all products in

Suppose you wanted quick lookup capability to get a listing of all productssupplied by a given vendor.

  1. Create a view that lists all products in alphabetical order and their vendors. Select all rows from the view and provide a screenshot.
  2. Find all productsthat were manufactured between February 15 and April 15, 2018. Provide SQL code and the screenshot of the result.
  3. Delete vendor AmeriMart form Vendor table. Provide SQL code and the result of select statement for both tables before deletion and after deletion. If you still have bed, dresser and chair in your product table, go back to #3 and fix foreign keys.
  4. Update table Products. Change the name of #1101 to Cherry Table.
  5. Find all vendors who supplied less than two products. Provide SQL code and the screenshot of the results.

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!

Q:

Scroll down to answer all parts of this task. Patrick and Amanda Thompson, married filing jointly (MFJ) taxpayers, have Year 2income from several sources. Tax documents for their Year 2income are...

Q:

Each part should have screenshot and SQL code. I am providing part 1-6 to help answer part 7-8. I do not need answers for 1-6, just for 7-8. Part 1: Identify primary and foreign keys. Create tables....

Q:

Lab 1.2 Instructions (1 point for each question) Suppose you have two tables: Table Product: PROD_ID PROD_NAME PROD_PRICE PROD_PROD_DATE PROD_VENDOR 1101 Table 100 1-Jan-18 2 1102 Chair 80 3-Mar-18 3...

Q:

Each part should have screenshot and SQL code. I am providing part 1-4 to help answer part 4-6. I do not need answers for 1-4, just for 4-6. Part 1: Identify primary and foreign keys. Create tables....

Q:

1. Suppose you wanted quick lookup capability to get a listing of all plays directed by a given director. Which table would be the basis for the INDEX table, and what would be the index key? Create...

Q:

Each part should have screenshot and SQL code Part 1: Identify primary and foreign keys. Create tables. Do not forget about primary and foreign keys. Provide SQL code and screenshot of DESC...

Q:

Due do questions 24-27 Database name: Ch03_Theater Table name: DIRECTOR Table name: PLAY 22. Identify the primary keys. 23. Identify the foreign keys. 24. Create the ERM. 25. Create the relational...

Q:

Please show all steps in Access and explanations. FIGURE Q3.18 The Ch03_Theater database tables Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 101...

Q:

Suppose you are using the database composed of the following tables: a. Identify the primary keys. b. Identify the foreign keys. c. Draw the relational schema to show the relationship between...

Q:

v In late 2008, less than 10 years after its founding, Zappos anticipated reaching annual gross sales of $1 billion. When its founder first proposed the idea of selling shoes online, the concept was...

Q:

2 3 4 5 6 7 8 9 10 11 12 13 14 15 Questions: 1. Matching customer demand to production scheduling is a crucial activity for any company. Explain why this was problematic for Geneva. 2. Describe...

Q:

A variable resistance R is connected across a potential difference V that remains constant. When R = R1, the current is 6.0 A. When R is increased to R2 = R1 + 10.0 , the current drops to 2.0 A. Find...

Q:

What was Myras hypothesis for the Armys dud shell research? What was the Armys hypothesis?

Q:

1. With reference to the cobe below, name, in each case, the angle between the line and the plane. (a) PV and PQRS (b) QV and PQRS (c) SU and PQRS (d) PV and SRVW (e) TV and SRVW (f) QW and PQUT W U...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

6-17 Identify the five problems of a traditional file environment and explain how a database management system solves them.

Q:

6-15 Identify some of the business intelligence features included in SAPs business software suite. The Lego Group, which is headquartered in Billund, Denmark, is one of the largest toy manufacturers...

Q:

6-18 Discuss how the following facilitate the management of big data: Hadoop, in-memory computing, analytic platforms.