在书店受订管理中涉及到以下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))
(88)
(86)
(87)
(85)
(83)
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.
(81)
(82)
(78)
(80)
高级经济师考试试题精选练习(1)
高级经济师考试模拟练习题之单选题(1
高级经济师考试试题精选练习(2)
高级经济师考试试题精选练习(3)
高级经济师考试试题:经济法案例试题精
高级经济师考试模拟试题及答案
高级经济师考试试题及答案:单选练习题
高级经济师考试试题:经济法案例试题精
高级经济师考试模拟题及答案练习(1)
高级经济师考试模拟题及答案练习(2)