单选

在书店受订管理中涉及到以下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)
参考答案
您可能感兴趣的试题

(88)

  • A.synonymously
  • B.equivalently
  • C.substitutionally
  • D.homomorphously

(86)

  • A.experience
  • B.know-how
  • C.expertise
  • D.skillfulness

(87)

  • A.renew
  • B.improve
  • C.upgrade
  • D.amend

(85)

  • A.supervisory
  • B.manipulating
  • C.management
  • D.processing

(83)

  • A.calculation
  • B.in account
  • C.audit
  • D.attention

(81)

  • A.automaton
  • B.robot
  • C.manipulator
  • D.man-machine system

(82)

  • A.counterexample
  • B.specification
  • C.particular
  • D.special case

(78)

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

(80)

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

订单号:

遇到问题请联系在线客服

订单号:

遇到问题请联系在线客服