Database instance Query

 

3. Create a table

 

 

4. (1) Request the supplier number SnO for J1 parts of the project;

 

(2) request the supplier number SnO that supplies the J1 part P1 of the project;

 

(3) request the supplier number SnO whose J1 part is red;

 

(4) do not use the project No. jno for the red parts produced by the Tianjin supplier;

 

(5) At least use the project No. jno of all parts supplied by supplier S1.

 

5. (1) identify the names and cities of all suppliers;

 

(2) identify the names, colors, and weights of all parts;

 

(3) Identify the engineering Number of the parts supplied by supplier S1;

 

(4) identify the names and quantities of various parts used by the Project J2;

 

 

(5) Find all part numbers provided by Shanghai manufacturer;

 

(6) Identify the engineering name of the parts produced in Shanghai;

 

(7) Find the engineering Number of the parts not produced in Tianjin;