in the attachment CSc4710 / CSc6710 Spring 2011 Project

in the attachment CSc4710 / CSc6710 Spring 2011 Project Due Date: April 13, 2011 SUPPLIER S# char(3) Sname char(15) S tatus int C ity char(20) S1 Smith 20 London S2 Jones 10 Pari Document Preview: CSc4710 /CSc6710 Spring 2011 Project Due Date: April 13, 2011 SUPPLIER S# char(3) Sname char(15) Status int City char(20) S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens S6 Meyer 40 Atlanta S7 Carlis 60 Washington S8 Barry 50 Vancouver S9 Smithline 30 Athens S10 Othmer 40 Chicago PART p# char(3) pname char(15) color char(15) weight decimal(10) city char(20) P1 Nut Red 12.0 London P2 Bolt Green 17.0 Paris P3 Screw Blue 17.0 Rome P4 Screw Red 14.0 London P5 Cam Blue 12.0 Paris P6 Cog Red 19.0 London P7 Cam Green 13.0 Atlanta P8 Nut Green 15.0 London Job j# char(3) jname char(20) city char(20) J1 Sorter Paris J2 Display Rome J3 OCR Athens J4 Console Athens J5 RAID London J6 EDS Oslo J7 Tape London SPJ s# char(3) p# char(3) j# char(3) qty int S1 P1 J1 200 S1 P1 J2 700 S2 P3 J3 300 S2 P3 J6 200 S2 P3 J5 500 S2 P5 J2 600 S2 P5 J6 800 S3 P6 J4 900 S3 P7 J4 100 S3 P2 J7 200 S3 P2 J5 400 S4 P8 J1 500 S4 P2 J1 200 S4 P8 J2 600 S5 P3 J2 700 S5 P6 J4 400 S5 P4 J6 600 S5 P5 J6 200 S6 P5 J3 200 S6 P2 J3 200 S6 P2 J7 500 S7 P1 J7 700 S7 P1 J2 800 S7 P3 J2 300 S7 P7 J1 500 S8 P7 J1 300 S8 P7 J4 300 S9 P3 J4 600 S9 P2 J3 400 S10 P4 J5 200 Create the above four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the term all is to be taken to mean all currently represented in the database not all possible. 2. Get all supplier-number/part-number/job-number triples such that the indicated supplier, part, and job are colocated. 3. Get all supplier-number/part-number/job-number triples such that the no two of the indicated supplier, part, and job are colocated. 4. Get all pairs of part numbers such that some supplier supplies both the indicated parts. 5. Get job numbers for jobs whose city is first in the alphabetic list of such cities. 6. Get job numbers for jobs not supplied with any red part by any London supplier. 7. Get part Attachments: projectDAta.pdf; in the attachment CSc4710 / CSc6710 Spring 2011 Project Due Date: April 13, 2011 SUPPLIER S# char(3) Sname char(15) S tatus int C ity char(20) S1 Smith 20 London S2 Jones 10 Pari Document Preview: CSc4710 /CSc6710 Spring 2011 Project Due Date: April 13, 2011 SUPPLIER S# char(3) Sname char(15) Status int City char(20) S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens S6 Meyer 40 Atlanta S7 Carlis 60 Washington S8 Barry 50 Vancouver S9 Smithline 30 Athens S10 Othmer 40 Chicago PART p# char(3) pname char(15) color char(15) weight decimal(10) city char(20) P1 Nut Red 12.0 London P2 Bolt Green 17.0 Paris P3 Screw Blue 17.0 Rome P4 Screw Red 14.0 London P5 Cam Blue 12.0 Paris P6 Cog Red 19.0 London P7 Cam Green 13.0 Atlanta P8 Nut Green 15.0 London Job j# char(3) jname char(20) city char(20) J1 Sorter Paris J2 Display Rome J3 OCR Athens J4 Console Athens J5 RAID London J6 EDS Oslo J7 Tape London SPJ s# char(3) p# char(3) j# char(3) qty int S1 P1 J1 200 S1 P1 J2 700 S2 P3 J3 300 S2 P3 J6 200 S2 P3 J5 500 S2 P5 J2 600 S2 P5 J6 800 S3 P6 J4 900 S3 P7 J4 100 S3 P2 J7 200 S3 P2 J5 400 S4 P8 J1 500 S4 P2 J1 200 S4 P8 J2 600 S5 P3 J2 700 S5 P6 J4 400 S5 P4 J6 600 S5 P5 J6 200 S6 P5 J3 200 S6 P2 J3 200 S6 P2 J7 500 S7 P1 J7 700 S7 P1 J2 800 S7 P3 J2 300 S7 P7 J1 500 S8 P7 J1 300 S8 P7 J4 300 S9 P3 J4 600 S9 P2 J3 400 S10 P4 J5 200 Create the above four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the term all is to be taken to mean all currently represented in the database not all possible. 2. Get all supplier-number/part-number/job-number triples such that the indicated supplier, part, and job are colocated. 3. Get all supplier-number/part-number/job-number triples such that the no two of the indicated supplier, part, and job are colocated. 4. Get all pairs of part numbers such that some supplier supplies both the indicated parts. 5. Get job numbers for jobs whose city is first in the alphabetic list of such cities. 6. Get job numbers for jobs not supplied with any red part by any London supplier. 7. Get part Attachments: projectDAta.pdf

Focus Essays has been there for more than 10 years to offer students like you academic writing services.

Get our experience by placing an order with us and use the discount code PAPER15 to get 15% discount on all orders.

We deliver URGENT ORDERS within 6 hours. Get a quotation from the calculator below.

TRY OUR SERVICES TODAY.

[order_calculator]