Question: Suppose you have the following table in SQL Server: VENDOR_STORE (VendorID, VendorName, VendorPhone, StoreID, StoreName) And you wish to transform this table into two tables

Suppose you have the following table in SQL Server:

VENDOR_STORE (VendorID, VendorName, VendorPhone, StoreID, StoreName)

And you wish to transform this table into two tables as follows:

VENDOR (VendorID, VendorName, VendorPhone)

STORE (StoreID, StoreName, VendorID)

Write the SQL statements needed for filling the VENTOR and STORE tables with data from VENDOR_STORE.

NOTE: These tables are NOT in SQL Server, but you should use SQL Server to create your SQL code and then copy and paste it in the solution area below.

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!

Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...

You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...

Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...

The following is the existing ITEM_PURCHASE table in the database: ITEM_PURCHASE (PurchaseID, PurchaseItem, PurchasePrice, PurchaseDate, VendorID, VendorName, VendorPhone) As this table has data...

Question 21 Below is relational design for the Customer table. The primary key is underlined. The foreign key is italicized. Customer (CustomerID, LastName, FirstName, Address, City, State,...

H Complete exercise # 3 through 7. I have question 1,2,3 and 8 complete. see attached pic 3 should help. SQL 2017 AP DATABASE FILE Chapter 4 How to retrieve data from two or more tables Generate the...

here are rhe six inquiry queries the six examples queries the following questions need to be answered: what is each query requesting from the database give a description of the following SQL keywords...

This case study assignment is based on (but not same as) the Queen Anne Curiosity Shop (QACS) Case Questions at the end of Chapters 7 and 8. Since there are important differences between the...

Assume that The Queen Anne Curiosity Shop designs a database with the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, Email) EMPLOYEE (EmployeeID,...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

10. For each pair of vectors, find cos 0, where 0 is the angle between them. 2); 2. a = (1, 0, 1) and b = (-1, 1, 1). 1. a = (1, 1, 1) and b = (1, 1, 2);

Manufacturing cost data for Meneses Company, which uses a job order cost system, are presented below. Indicate the missing amount for each letter. Assume that in all cases manufacturing overhead is...

as forecasted sales net of potential taxes due. by taking forecasted production and multiplying by a sensitivity factor. Question 2 A budget in which employees develop initial budgets based on their...

The following balance sheet for the Hubbard Corporation was prepared by the company: HUBBARD CORPORATION Balance Sheet At December 31, 2018 Buildings Land Cash Accounts receivable (net) Inventories...

The rod supports a weight of 320 lb and is pinned at its end A. It is also subjected to a couple moment of 100 lb?ft. The spring has an unstretched length of 2 ft and a stiffness of k = 50 lb/ft....

The magnitude of earthquakes since 1900 that measure 0.1 or higher on the Richter scale in California is normaly distributed with = 6.2 and = 0.5, according to data obtained from the U.S....

What is the practical significance of Region of convergence. Give an example where this is used in real life applications. (note: the subject is signal and systems)

Suppose that a motorboat is moving at 40 ft/s when its motor suddenly quits and that 10 seconds later the boat has slowed to 20 ft/s. Assume that the water-resistance the boat encounters is...

( 1 point ) You are a t the point ( 2 , 4 , 3 ) , standing upright and facing the y z - plane. You walk 3 units forward, turn left, and walk another 3 units. What i s your final position? Consider...

Explain how SQL Server 2014 produces XML output using the FOR XML RAW clause.

What are the functions of the DBMS?

How can you assess minimum cardinality for the entities in the form in Figure 5-17?

Write the meaning of each of the following terms without referring to the book (or your notes), and compare your definition with the version in the text for each: a. Dummy variable b. Omitted...

Use your own computers regression software and the weight (Y) and height (X) data from Table 1.1 to see if you can reproduce the estimates in Equation 1.19. There are two ways to load the data: You...

Not all regression coefficients have positive expected signs. For example, a Sports Illustrated article by Jaime Diaz reported on a study of golfing putts of various lengths on the Professional...