Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Design We have discussed several queries in the class involving the S, P,J and SPJ tables. The S table contains the information about supplier
Database Design
We have discussed several queries in the class involving the S, P,J and SPJ tables. The S table contains the information about supplier number (S#), supplier name (sname), status, and the city where the supplier is located. The status is maintained as a numerical number while the values for all the other attributes in the S table are strings. The P table contains the part number [PF), part name tname), color, and weight of each part as well as the city where the part is located. The weight is maintained as a numerical number while the values for all the other attributes in the P table are strings. The J table contains the project number (M) and project name iname) information about each project as well as the city where the project is located. The values for all the attributes in the /table are strings. Finally, the SPJ table keeps tracking the relationships among suppliers, parts, and projects. For example, the very first record in the SPJ table shown below indicates that supplier s1 supplies part p1 to project j1 with a quantity of 200. In this table, the quantity information is maintained as a numerical number while the values for all the other attributes are strings. s# SNAMI Smith Jones Blake Clark STATUS 20 10 CITY London Paris Paris London Athens s4 20 s5 30 p# p1 p2 p3 p4 p5 p6 PNAME COLOR WEIGHT nut bolt screw tapler carm CITY London Paris Rome London Paris London red blue blue cor 19 JH JNAME CITY sorter Paris j2 punch Rome reader Athens j4 console Athens j5 collator London j6 terminal Oslo j7 tape London p# s1 j4 s2 p3 p3 p3 p3 s2 2 s2 2 D3 p3 D3 7 p5 j2 100 D3 p4 p6 300 The above tables illustrate the schema and contain some sample records for the S, P, J, and SPJ tables. Using SQL, find the names of those suppliers who do not supply red parts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started