Question: Table: product PROD_ PROD_NAM COM_NAM LIFE CODE E E PR001 TV SONY 7 PR002 DVD Player LG 9 PR003 IPOD PHOLIPS 9 PR004 SOUND SONY

Table: product PROD_ PROD_NAM COM_NAM LIFE CODE E E PR001 TV SONY 7 PR002 DVD Player LG 9 PR003 IPOD PHOLIPS 9 PR004 SOUND SONY 8 SYSTEM PR005 MOBILE NOKIA 6 Table: purchase PUR PROD PU PUR_ _NO _COD R Q AMO E TY UNT 2 PR001 1 120 1 PR003 2 300 3 PR0073 300 4 PR005 1 200 5 PR002 2 250 6 PR006 2 150 Questions: - Given tables "product" and "purchase", write SQL Server queries to answers the following questions. 15. Write two SQL queries to create tables "product" and "purchase". 16. Create two stored procedures in SQL for inserting the tables information given in above tables into "product" and "purchase" tables. You can take help from the PPT uploaded on moodle Questions: Given tables "product" and "purchase, write SQL Server queries to answers the following questions. 15. Write two SQL queries to create tables "product" and "purchase. 16. Create two stored procedures in SQL for inserting the tables information given in above tables into "product" and "purchase" tables. You can take help from the PPT uploaded on moodle 17. Call stored procedures multiple times for inserting the information in the tables. 18. Create two stored procedures in SQL for "select * from product" and "select * from purchase? 19. Write SQL query to join "product" and "purchases tables using Cartesian product? 20. Write SQL query to join "product" and "purchases" tables using Inner join? Write SQL query to join "product" and "purchases" tables using Outer "Full join? 21

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!

Summary this parts17.1 and 17.2 in this lesson and give one Case study with this lesson. 548 Lext 17 Leadership, Organization, 7 and Corporate Social Responsibility LEARNING OBJECTIVES the companies...

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....

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....

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...

Using the 2 tables below : Identify primary and foreign keys. Draw the relational schema to show the relationship between two tables using Crow Foot Notation Suppose you have two tables: Table...

I am having trouble creating SQL code to put this data in a database. Could someone help me with a couple of examples of how I can implement this data properly? Here is what I have so far. /*...

Assessment Description Using the INVOICE table structure shown in Table 1 , do the following: Table 1 : Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV _ NUM 1 0 0...

Write SQL statements to answer the following questions using Assignment 2s schema (Customer-Invoice-Line-Product-Vendor). (Please see attached images from assignment 2) 1 - Find the count of unique...

a . Draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies.b . Remove all partial dependencies, and draw the new dependency diagrams. Identify...

FIGURE Q5.7 The PRODUCT data model for questions 3 & 4 PRODUCT Prod Title Prod ReleaseDate Prod Price Prod_Type dProd_Type BOOK CD MOVIE PK,FK1 Prod Num PK,FK1 Prod Num PK,FK1 Prod Num Book CoverType...

The Excel file MLB 2012 Payroll. xlsx contains the total payroll in millions of dollars for each Major League Baseball team at the start of the 2012 season along with the total number of each teams...

Nida Hat Shop received a shipment of hats for which it paid the wholesaler $2,940. The price of the hats was $3,000, but Nida was given a $60 cash discount and required to pay freight charges of $75....

( a ) What are the categories of the sources of authoritative GAAP for various public and private sector organizations?

what are the factors that shape your organization external competitiveness to recruit and retain employees

4. Why is it important to think beyond ourselves as individuals in intercultural interaction?

2. Describe how technology can impact intercultural interaction.

7. Define cultural space.