问题 多项选择题

[说明]


某企业决定开发一个企业仓储管理系统,由李工承担系统的设计工作。该系统的网络连接如图4-26所示。


该企业有多个仓库,如图4-26所示的中心数据库存储了各个仓库中每种货物的库存信息。每个仓库配备一台前端机,进出货物均由前端机辅助实现。管理员每天上班时,通过前端机从中心数据库的库存表中读取本仓库各种货物的库存数,每个仓库的当日业务数据也都暂存在前端机中,当天业务结束后,再将前端机中存储的数据传输到主机进行存储与汇总。
每个仓库可以存放多种货物,但同一种货物不能存放在不同的仓库中。每个仓库有多个管理员,但每个管理员只管理一个仓库。货物出库/入库时,由仓库管理员将货物的条码通过阅读器输入前端机中,货物数量的默认值为1,可以由管理员修改。前端机根据输入的货物信息,打印“出库/入库”清单。出库/入库单中同一种货物最多只出现一次,每份出库/入库单由流水号唯一标识。表4-35是一个出库单的实例。


该系统处理业务的过程如下。
(1) 初始化:前端机根据仓库号从货物表中读取本仓库中每种货物的货物编码、库存量、货物名称和单价。
(2) 登记出库/入库信息:由前端机存储每一笔“出库/入库”记录。
(3) 汇总:在每个工作日结束前汇总当日各种货物的“出库/入库”量至日汇总表。
(4) 更新库存表:根据当日的汇总信息更新货物的库存。
图4-27所示为与该系统对应的实体联系图(不完整)。


李工经过分析,设计出如下关系模式。
出入库单(流水号,出入库标志,管理员号,时间)
出入库记录(货物编码,数量,流水号)
日汇总表(日期,货物编码,数量,出入库标志)
仓库(仓库号,仓库名,仓库电话)
管理员(管理员号,姓名,仓库号)
货物( (a) )
注:时间格式为年-月-日 时:分;日期格式为年-月-日。
1. 根据题意,请将货物关系模式的属性(即(a)空缺处)补充完整。

答案

参考答案:出入库单(流水号,出入库标志,管理员号,时间)
出入库记录(货物编码,流水号,数量)
日汇总表(日期,货物编码,数量,出入库标志)
仓库(仓库号,仓库名,仓库电话)
管理员(管理员号,姓名,仓库号)
货物(货物编码,货物名称,单价,仓库号,库存量)

阅读理解

阅读理解。

      There are many unusual hotels around the world. In Greenland, there is a hotel made out of ice, open

between December and April every year. In Turkey, there is a cave hotel with a television, furniture, and a

bathroom in each room. And in Bolivia, there is the Salt Palace Hotel.

      Thousands of years ago, the area around the Salt Palace Hotel was a large lake. But over time, all the

waiter disappeared. Today, the area has only two small lakes and two salt deserts.

      The larger of the two deserts, the Uyuni salt desert, is 12,000 square kilometres. During the day, the

desert is bright white because of the salt. There are no roads across the Uyuni desert, so local people must

show guests the way to the hotel. In the early 1990s, a man named Juan Quesada built the hotel. He cut big

blocks of salt from the desert and used the blocks to build it. Everything in the hotel is made out of salt: the

walls, the roof (屋顶), the tables, the chairs, the beds, and the hotel's bar.

      The sun heats (使变热) the walls and roof during the day. At night the desert is very cold, but the rooms

stay warm. The hotel has twelve rooms. A single room costs$40 a night, and a double room costs$60.

      A sign on the hotel's wall tells guests,"Please don't lick (添) the walls." 

1. What is unique about the Salt Palace Hotel?

A. its long history.

B. the price of the rooms.

C. the guests that stay there.

D. what it is made of.

2. Which sentence about the area around the Salt Palace Hotel is NOT true?

A. It was a lake many years ago.

B. It is white during the day.

C. There are several roads to the hotel.

D. It is more than 10,000 square kilometers.

3. Where did the salt used for the hotel come from?

A. a salt factory

B. the ground

C. Turkey

D. the walls of the hotel

4. What keeps the rooms warm at night?

A. heat from the walls

B. the desert air

C. the sun

D. the furniture

单项选择题