一起答
单选

设有一个SPJ数据库,包括S,P,J,SPJ 4个关系模式:    S(SNO,SNAME,STATUS,CITY):    P(PNO,PNAME,COLOR,WEIGHT):    J(JNO,JNAME,CITY):    SPJ(SNO,PNO,JNO,QTY):    供应商表S由供应商代码(SNO)、供应商姓名(SNAME)、供应商状态(STATUS)、供应商所在城市(CIIY)组成。    零件表P由零件代码(PNO)、零件名(PNAME)、颜色(COLOR)、重量(WEIGH)组成。    工程项目表J由工程项目代码(JNO)、工程项目名(JNAME)、工程项目所在城市(CITY)组成。    供应情况表SPJ由供应商代码(SNO)、每件代码(PNO)、工程项目代码(JNO)、供应数量(QTY)组成,表示某供应商供应某种零件给某工程项目的数量OTY。    那么用关系代数完成查询“供应工程J1红色零件的供应商号SNO”,应是(44)。

  • A.πSNOSNO,PNOJNO='J1'(S))×πPNOCOLOR='红'(P)))
  • B.πSNOSNO,PNOJNO='J1'(S))πPNOCOLOR='红'(SPJ)))
  • C.πSNOSNO,PNOJNO='J1'(SPJ))πPNOCOLOR='红'(P)))
  • D.πSNOSNO,PNOJNO='J1'(SPJ))×πPNOCOLOR='红'(P)))
参考答案
查看试卷详情
相关试题
  1. (80)

    • A.evidence
    • B.evidenced
    • C.evidences
    • D.evidencing
  2. (79)

    • A.more
    • B.little
    • C.a matter
    • D.important
  3. (78)

    • A.logic
    • B.function
    • C.flexible
    • D.application
  4. Structured programming practices(71)rise to Pascal, in which constructs were introduced to make programs more readable and better(72)C provided a combination of assembly and high -level  structure to create a general -purpose language that could be used from system to(73)programming.  Next came object orientation, which is(74)of a metrology and design philosophy than a language  issue. This is(75)by the addition of so - called OO extensions to current language, such as C++.

    • A.giving
    • B.given
    • C.gave
    • D.gives
  5. (77)

    • A.structure
    • B.structured
    • C.constructs
    • D.structures
  6. (74)

    • A.graphics
    • B.graph
    • C.graphitic
    • D.graphical
  7. (75)

    • A.visually
    • B.lively
    • C.quickly
    • D.specially
  8. (73)

    • A.choose
    • B.selections
    • C.choice
    • D.select
  9. (72)

    • A.interfaces
    • B.pictures
    • C.graphs
    • D.books
  10. Application development increasingly means Windows development, and the popularity of visual development tools has(66)in tandem with Windows itself. These tools create beautiful windows wing(67)and their fast development cycles and easy learning curves make them a good(68)for many types of PC development projects. Today's developers are leveraging these tools and the abundance of cheap, powerful PCs to shift the balance of power to the desktop. As the world moves inexorable toward Window and other(69). user interfaces, developers can choose from an abundance of(70)oriented tools. Popular examples include Microsoft Corp's Visual Basic, powersoft Corp's PowerBuilder, Gupta Technology Corp's SQL Windows, and so on.

    • A.rise
    • B.risen
    • C.rised
    • D.rising