数据库英文课件5.pptVIP

Exercises of SQL Answer the following questions, based on the database below. Supplier(SNO, SNAME, STATUS, CITY) Part(PNO, PNAME, COLOR, WEIGHT) Project(JNO, JNAME, CITY) SPJ(SNO, PNO, JNO, QTY) The schema has four relations. The key attributes for each relation are shown in red. 1.Give suitable declarations for each relation. 2.Write the following queries: (1)Find the name and city of all the Supplier. (2)Find the name, color and weight of all the parts. (3)Find the number of all the projects using the parts that provided by S1. (4)Find the name and quantity of all the parts used by J2. (5)Fi