数据库英文课件5.pptVIP

  • 4
  • 0
  • 约1.67千字
  • 约 4页
  • 2018-02-04 发布于河南
  • 举报
数据库英文课件5

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

文档评论(0)

1亿VIP精品文档

相关文档