一起答
单选

在书店受订管理中涉及到以下3个关系模式:

 书籍  Books(Bid,Bname,Price,Author, Publisher)

 订单  Orders(Ordend,Orderdate,Cid)

 订单明细 Orderlist(Orderid,Bid,Qty)

 其中各属性的含义是:Bid书籍编号,Price单价,Author作者,Publisher出版商,Ordend订单编号, Orderdate下订日期,Cid客户编号, Qty数量。每张订单具有唯一的订单编号;每张订单编号中可包含多种书籍,但每种书籍的编号仅允许出现一次。则“订单”实体的主键是(33),“订单明细”实体的主键是(34)。请将正面的SQL语句空缺部分补充完整。

 CREATE TABLE ORDERLIST(ORDERID CHAR(20),

 BD CHAR(6),

 QTY NUMBERIC(9),

(35)(ORDERID,BID),

(36)(ORDERID)

(37)(BID))

  • A.Orderid
  • B.Cid
  • C.(Orderid,Orderdate)
  • D.(Orderdate,Cid)
参考答案
查看试卷详情
相关试题
  1. (88)

    • A.synonymously
    • B.equivalently
    • C.substitutionally
    • D.homomorphously
  2. (86)

    • A.experience
    • B.know-how
    • C.expertise
    • D.skillfulness
  3. (87)

    • A.renew
    • B.improve
    • C.upgrade
    • D.amend
  4. (85)

    • A.supervisory
    • B.manipulating
    • C.management
    • D.processing
  5. (83)

    • A.calculation
    • B.in account
    • C.audit
    • D.attention
  6. Artificial intelligence (AI) ,an interdisciplinary field, is usually regarded as a branch of computer science, dealing with models and systems for the performance of functions generally associated with human intelligence, such as(71)and learning.In AI, knowledge-based system is an information(72)system that provides for solving problems in a particular domain or application area by drawing inferences from a knowledge base. Moreover, some knowledge-based systems have learning capabilities. Expert system (ES) indicates the knowledge-based system that provides for solving problems in a particular domain or application area by drawing inferences from a knowledge base developed from human(73). Some expert systems are able to(74)their knowledge base and develop new inference rules based on their experience with previous problems. The term "expert system" is sometimes used(75)with "knowledge-based system", but should be taken to emphasize expert knowledge.

    • A.inferring
    • B.reasoning
    • C.deriving
    • D.proving
  7. (81)

    • A.automaton
    • B.robot
    • C.manipulator
    • D.man-machine system
  8. (82)

    • A.counterexample
    • B.specification
    • C.particular
    • D.special case
  9. (78)

    • A.PRIMARY KEY
    • B.FOREION KEY
    • C.FOREIGN KEY (ORDERID) REFERENCES ORDERS
    • D.FOREIGN KEY (BID) REFERENCES BOOKS
  10. (80)

    • A.idea
    • B.observation
    • C.point of view
    • D.viewport