Em Andamento

Database Assignment

The S-P-J-SPJ database in this assignment. 1. Table Structures: Table S: s#: VARCHAR2(5) sname: VARCHAR2(20) status: NUMBER(5) city: VARCHAR2(15) Primary key: s# Table P: p#: VARCHAR2(6) pname: VARCHAR2(20) color: ARCHAR2(6) weight: NUMBER(5,1) city: VARCHAR2(15) Primary key: p# 2 Table J: j#: VARCHAR2(4) jname: VARCHAR2(20) city: VARCHAR2(15) Primary key: j# Table SPJ: s#: VARCHAR2(5) p#: VARCHAR2(6) j#: VARCHAR2(4) qty: NUMBER(9) Primary key: (s#,p#,j#) Foreign keys: s# references to column s# in table S p# references to column p# in table P j# references to column j# in table J [url removed, login to view] data: S S# SNAME STATUS CITY ----------------------------------------- S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens P P# PNAME COLOR WEIGHT CITY --------------------------------------------- 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 J J# JNAME CITY -------------------------------- J1 Sorter Paris J2 Display Rome J3 OCR Athens J4 Console Athens J5 Raid London J6 EDS Oslo J7 Tape London SPJ S# P# J# QTY ----------------------------------- S1 P1 J1 200 S1 P1 J4 700 S2 P3 J1 400 S2 P3 J2 200 S2 P3 J3 200 S2 P3 J4 500 S2 P3 J5 600 S2 P3 J6 400 S2 P3 J7 800 S2 P5 J2 100 S3 P3 J1 200 S3 P4 J2 500 S4 P6 J3 300 S4 P6 J7 300 S5 P2 J2 200 S5 P2 J4 100 S5 P5 J5 500 S5 P5 J7 100 S5 P6 J2 200 S5 P1 J4 100 S5 P3 J4 200 S5 P4 J4 800 S5 P5 J4 400 S5 P6 J4 500

## Deliverables

[url removed, login to view] Notes: -All the questions are the queries against the S-P-J-SPJ database.-Execute a SQL script to create the tables and load the data into the tables in the S-P-J-SPJ database. The SQL script should contain correct CREATE TABLE, INSERT, and COMMIT statements. Q1. Print all SNAME, PNAME pairs such that the indicated supplier is in Paris and the indicated part is in London and the indicated supplier ships the indicated part to a project in Paris. Q2. Print all S#s such that the indicated supplier supplies a Paris project with a red part and also supplies a non-Paris project with a red part. Write this query in two ways: a) as a FLAT SELECT statement. b) as a NESTED SELECT statement that does not contain any JOIN_CLAUSEs. Q3. Print the J#s of projects that are not supplied with any part that is available from a Paris supplier. Q4. Print the pairs of J#s such that the indicated projects are supplied by a common supplier and are supplied with a common part (This common part is not necessarily supplied by the same/common supplier).Note: In Q4, do NOT print any records of the form (x,x). In addition, if (x,y) is printed do NOT print (y,x). Q5. Print the P#s of parts that are supplied by at least one Paris supplier but are not supplied to any London project. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Use the "set echo on" and "spool" commands to generate the following desired output to turn in: for each query, a print-out of each SELECT statement followed by the output from that SELECT statement.

## Platform

windows and unix

Habilidades: Programação C, Engenharia, Linux, Microsoft, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, UNIX, Área de trabalho do Windows

Ver mais: set of pairs, set data structures, questions on data structures, programming structures, programming statement, programming database, php programming notes, notes php programming, data structures set, data structures questions, data structures in c notes, database programming sql, c programming if statement, common query, common data structures, c. j. adams, blake clark, b j's, assignment out source, as 400 programming, adams 14, s3 database, p sql, h4 working, h4 work

Acerca do Empregador:
( 16 comentários ) United States

ID do Projeto: #2954998

Premiar a:

finecodervw

See private message.

$17 USD em 3 dias
(148 Avaliações)
6.2

20 freelancers estão ofertando em média $35 para este trabalho

TakeRealUK

See private message.

$25.5 USD in 3 dias
(765 Comentários)
7.0
prabhatsaini

See private message.

$25.5 USD in 3 dias
(144 Comentários)
6.9
harisraheem

See private message.

$8.5 USD in 3 dias
(23 Comentários)
6.1
ziksainc

See private message.

$21.25 USD in 3 dias
(61 Comentários)
5.2
vw139994vw

See private message.

$42.5 USD in 3 dias
(60 Comentários)
4.5
teamvw

See private message.

$29.75 USD in 3 dias
(36 Comentários)
3.8
lubnavw

See private message.

$12.75 USD in 3 dias
(10 Comentários)
3.8
parasoftvw

See private message.

$20.4 USD in 3 dias
(10 Comentários)
3.4
smartsoftwarevw

See private message.

$21.25 USD in 3 dias
(5 Comentários)
3.4
tzunivw

See private message.

$17 USD in 3 dias
(26 Comentários)
2.9
oradevvw

See private message.

$21.25 USD in 3 dias
(7 Comentários)
2.2
cdhimanc

See private message.

$255 USD in 3 dias
(11 Comentários)
2.1
nmaxx

See private message.

$29.75 USD in 3 dias
(7 Comentários)
2.0
crysmvw

See private message.

$17 USD in 3 dias
(3 Comentários)
0.0
alecsvw

See private message.

$12.75 USD in 3 dias
(1 Comentário)
0.0
rakeshsrini

See private message.

$13.6 USD in 3 dias
(0 Comentários)
0.3
pikervw

See private message.

$17 USD in 3 dias
(0 Comentários)
0.0
anatolivw

See private message.

$85 USD in 3 dias
(0 Comentários)
0.0
maghajan

See private message.

$34 USD in 3 dias
(0 Comentários)
0.0
chupendra

See private message.

$8.5 USD in 3 dias
(0 Comentários)
0.0