1.)Get S# values for suppliers who supply both projects J1 and J2. 2.)Get S# val
ID: 3739439 • Letter: 1
Question
1.)Get S# values for suppliers who supply both projects J1 and J2.2.)Get S# values for suppliers who supply project J1 with a red part.
3.) Get P# values for parts supplied to any project in London.
4.)Get P# values for parts supplied to any project by a supplier in the same city.
5.)Get J# values for projects supplied by at least one part available from supplier S1. SPJ: Table 11 S : Table S# ! SName | Status | City S1 Smith S2 Jones S3 Blake S4 Clak S5 Adams 20 London LE1.PI JI · 10 ParisS1 P1 J4 700 30 Paris Status 20 London S2 P3 2 20 P: Table | | P#| PName | Color | Weight | City S2 P3 J6 400 SPJ er +P1 Nut Red | 1-1 + P2-Bolt . Green 17 ParisS2 P5 2 100 P3 Screw Blue P4 Screw Red +P5 Cam Blue 4 LondonS3 PA J2500 2 Paris Color +P6 Cog Red 19 London City S5P2?JA 100 S5 P5135 | S5 P5 100 ? J : Table J#?JName! City Sorter Paris 2 Punch Rome Jf JName City J3 Reader Athens IJA ?Console-Athens- E95 |PATJA 5 Collator London tJ6 Terminal Oslo 195P5?JA 1400 P6
Explanation / Answer
1.)Get S# values for suppliers who supply both projects J1 and J2.
select s.s# from s, spj, j where s.s# = spj.s# and spj.j# = j.j# and j.j# = 'J1' and j.j# = 'J2'
2.)Get S# values for suppliers who supply project J1 with a red part.
select s.s# from s, spj, j where s.s# = spj.s# and spj.j# = j.j# and spj.p# = p.p# and j.j# = 'J1' and p.color= 'Red'
3.) Get P# values for parts supplied to any project in London.
select p# from p where p.city = 'London'
4.)Get P# values for parts supplied to any project by a supplier in the same city.
select p# from p, s , spj where spj.s# = s.s# and spj.p# = p.p# and s.city = p.city
5.)Get J# values for projects supplied by at least one part available from supplier S1.
select j.j# from s, p, spj, j where j.j# = spj.j# and spj.p# = p.p# and spj.s# = s.s# and s.s# = 'S1'
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.