Question: SQL problems 1.) 2.) 1 Display itemcode. Item description and supplier name for all items for which quotations have been received from suppliers. Write your

SQL problems

1.)

name for all items for which quotations have been received from suppliers.

Write your query here Item (Itemcode, Itemtype. Descr. Price, Reorderlevel SELECT S.

2.)

itemcode, S. itemdescription, S.sname, Qtyonhand. Category itemcode From Quotations inner join Orders

1 Display itemcode. Item description and supplier name for all items for which quotations have been received from suppliers. Write your query here Item (Itemcode, Itemtype. Descr. Price, Reorderlevel SELECT S. itemcode, S. itemdescription, S.sname, Qtyonhand. Category itemcode From Quotations inner join Orders o on SQuotationid- o. QuotationId where QtyOrdered > Quotation (Quotationid, Sname Itemcode. Quotedprice. Qdate. Ostatus) Orders (Orderid, Quotationid. Qtyordered. Orderdate. Status, Pymtdate. Delivereddate. Amountpaid. Pymtmode) Retailoutlet (Rold, Location Managerid) Verify Submit Empdetails (Empid, Empname Designation, Emailid, Fant in Display itemcode. Item description and supplier name for all items for which quotations have been received from suppliers. Write your query here Retalloutlet (Roid, Location Managerid) 1 SELECT S. itemcode, s.itemdescription, S.sname, itemcode From Quotations inner join Orders o on Empdetails (Empid, Empname, Designation, Emailid, SQuotationid. 0. QuotationId where QtyOrdered >- Contactno, Worksin, Salary) Retailstock (Rold. Itemcode Unitprice. Otyavailable) Customer (Custid, Custtype, Custname Gender. Spouse. Emailid, Address) Verify Submit Purchasebill (Billid. Roid, Itemcode. Custid. Billamount Billdate. Quantity) Expected Result ITEMCODE DESCR SNAME 11002 Best Rice W Electronics 11002 Best Rice EBATS 11005 Levis T-Shirt Giant Store 11005 Levis T-Shirt Shop Zilla 11008 Xbox gamepad EBATS 11008 Xbox gamepad Giant Store 11009 Microsoft Mouse W Electronics 11009 Microsoft Mouse Giant Store 11010 Intel C2D Processor Shop Zilla 11010 Intel C2D Processor EBATS 11012 500GB Hard disk Giant Store 11012 500GB Hard disk Shop Zilla 11012 500GB Hard disk Shop Zilla Display id, name manager id and manager name of those employees who are allocated a computer and whose manager is also allocated a computer. Also display the model of computer allocated to the employee and the manager. Write your query here Database structure Computer Compid. Make Model. Myear) Employee (ld. Ename. Doj, Salary, Bonus. Dept. Designation, Manager, Compid) 1 ( Verify Submit

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!

!!!!!DO NOT DO THIS IN SQL!!!! (2a). Create a new table for Suppliers, set the primary key, input data (Note: the supplier data are from Week 1 Assignment). (2b). Change the structure of the original...

This is SQL, I need help with these statements please!!! Here is everything needed to do it: Write SQL statements for questions given below for the PetStore database. Save your SELECT statements as...

rite an SQL command that will find any customers who have not placed orders. Query 2 : List the names and number of employees supervised ( label this value HeadCount ) for each supervisor who...

I am begging you to refer to my part one code to solve this question I will write my part one code here check it then read part 2 which is my issue now then answer part two. already I lost 4 monthly...

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Hello. I would like help with this assignment? Will you review it and let me know if you can help? CASE 18-1 Practical Database Design Hands-on practice in database design is important. Use a...

Step 1: Table Creation Create a new database and execute the code below in SQL Server's query window to create the database tables CREATE TABLE PhysicianSpecialties (Specialty integer, Sascialtxams,...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Here is a incomplete pos server program, receiving input from posclient, inserting traction detail data into sql database. create a database Client Server Program Search TMA02 in POSServer.java, to...

i need to follow the instruction in tge first document to edit the access document GO16_AC_VOL1_GRADER_CAP_AS - Inventory Supplies Project Description: In this project, you will apply skills you...

Granger Stokes, managing partner of the venture capital firm of Halston and Stokes, was dissatisfied with the top management of PrimeDrive, a manufacturer of computer disk drives. Halston and Stokes...

QUESTION 1 Construction industries have accomplished extensive growth worldwide particularly in past few decades. To be successful construction project, safety of the structures as well as for the...

The amount you need to save each year to have enough at retirement depends on how much you deposit regularly. how many years you make deposits. your rate of return on deposits. a . and b . a . , b ....

Question 2 1 pts Nitrogen from a gaseous phase is to be diffused into pure iron at 6 7 5 C . If the surface concentration is maintained at 0 . 2 w t % N , what will be the concentration 2 m m from...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...