问题 单项选择题

某商场的部门、员工和商品3个实体之间的关系如图所示,它们各自的信息表分别见表1、表2、表3。假设每个部门有若干名员工,每种商品只能由一个部门负责销售。如果用户要求得到如表4所示的结果,则需要(1),并增加关系模式(2)。如果要求查询某部门负责销售的商品,则需要(3)

表1 部门信息表
部门号名称电话
001家电部1001
002百货部1002
003食品部1003
表2 商品信息表
商品号名称单价库存量
30023微机480026
30024打印机16507
30101毛巾10106
30102牙刷3.8288
表3 员工信息表
员工号姓名住址
E001王军南京路
E002李晓斌淮海路
E021柳烨江西路
E026田波西藏路
E028李晓斌西藏路
E029刘丽华淮海路
E030李彬彬唐山路
表4 具体关系表
员工号改名部门号月销售额
E001王军001528900
E002李晓斌001368000
E02l柳烨00212500
E028李晓斌00382500
    

(1)是()

A.修改表1的结构,在表1中增加一个员工号

B.修改表2的结构,在表2中增加一个员工号

C.修改表2的结构,在表2中增加一个部门号

D.修改表3的结构,在表3中增加一个部门号

答案

参考答案:D

解析:

由题干中关键信息“每个部门有若干名员工,每种商品只能由一个部门负责销售”可知,实体“部门”与“员工”是一对多(1:n)的关系,实体“部门”与“商品”也是一对多(1:n)的关系。表4中的每条元组代表所有员工在某个部门中的月销售额,为了表达部门和员工之间的一对多关系,需要在表3中增加一个部门号。因此空缺处的正确答案为选项D。

为了统计月销售额,需要建立员工和销售商品之间的联系,这个联系可通过新的关系来表达,该关系中应该包含属性“员工号”、“部门号”、“商品号”和“数量”。因此空缺处的正确答案为选项D。

表1代表的是部门实体,表2代表商品实体。如果查询某部门负责销售的商品,则需要表达出部门实体和商品实体间的一对多关系,把商品实体添加一个部门号属性,用来表达负责该商品销售的部门。因此空缺处的正确答案为选项B。

阅读理解

阅读理解。

    New China received a great gift on September 29,2011—the successful launch (发射) of Tiangong-I.

Scientists sent the country's first space lab module (太空实验舱) from the Jiuquan Satellite Launch

Center in Gansu into space at 9:16 pm on Thursday.

     The Tiangong-I is a new spacecraft made by China. It's bigger and heavier than Shenzhou

spaceships, about 8 tons. It is 10.4 meters tall, as high as a 3-story building.

     The Tiangong-I spacecraft will stay 350km above the Earth for two years. It will join with three

spaceships, Shenzhou VIII, Shenzhou IX and Shenzhou X. The Shenzhou VIII spaceship, also

unmanned, was launched in early November. Scientists will launch Shenzhou IX and Shenzhou X in

2012. Astronauts will enter Tiangong-I after successsfully joining their ships with the module. The

Shenzhou X will be China's 6th manned spacecraft. It may carry the first woman astronaut into space.

     The launch of the Shenzhou spaceships and the Tiangong-I are all in preparation for building China's

space station. The space lab and future space station are for experiments that can't be done on Earth.

The main purpose of China's manned space station is to peacefully explore space, and through it, serve

man," One of the scientists said.

1. When did the scientists send the Tiangong-I into space?

A. On September 29, 2012.

B. On Octobert 3, 2011.

C. On September 29, 2011.

D. On Octobert 3, 2011.

2. How many spaceships will the Tiangong-I join?

A. One.

B. Two.

C. Three.

D. Four.

3. What is the Chinese meaning for the underlined word "preparation"?

A. 探测

B. 项目

C. 计划

D. 准备

4. What's the main purpose (目的) of China's manned space station?  

A. To explore space and serve man.  

B. To join with three spaceships.  

C. To do experiments in the Tiangong-I in the future.  

D. To carry the first woman astronaut into space.

多项选择题