问题 问答题

设有某简化的网上购物系统,其ER图如下:

该系统数据之间存在下列约束:

Ⅰ. 一个客户(编号唯一)可以拥有多个订单,每个订单仅属于一个客户;

Ⅱ. 一个订单(编号唯一)可以包含多个订购细目,每个订购细目只属于一个订单;

Ⅲ. 一种商品可以出现在多个订购细目中,一个订购细目只包含一种商品;

Ⅳ. 一个商品类别可以包含多种商品,一种商品只属于一个商品类别。

请修改所设计的关系模式使之支持下列功能(仅列出发生修改的关系模式)。

Ⅰ. 使客户能方便了解每个订购细目的处理状态和到货时间;

Ⅱ. 使客户能方便查询商品供应商的编号、名称、所在城市、联系电话和信誉。(限定一个供应商可以供应多种商品,一种商品只选自一个供应商)

答案

参考答案:

在订购细目中添加发货时间和到货时间;添加供应商关系模式,修改商品关系模式

businessInfo(businessID, businessName, businessCity, businessTel, businessCredit)主码businessID;commodityInfo(comID, comName, comPrice, comDate, typeID, itemID, businessID)主码comID,外码typeID,itemID,businessID;

阅读理解

It seems to be strange to you that there is a blind spot (盲点)on the eyes. Here is an interesting experiment (实验) that can make something disappear, when one eye is open.

Make a card about the size of a postcard and write two English letters L and R on it, L on the left and R on the right. First, hold the card about 80 cm away and you see both the letters. Then close your right eye and look at the letter R only with your left eye. And now, as you move the card slowly towards you, you’ll find the letter L disappearing. But if you move the card nearer to your face, the letter will be seen again. Now do the same experiment with your left eye closed, you’ll find the letter R disappearing.

Why does the letter disappear? It is because there is a blind spot on the eyes. When the image (影像) of the letter falls on the blind spot, it won’t be seen. That is why either of the letters disappears.

小题1:The writer of the passage thinks that ________ there is a blind spot on the eyes.

A.few people know

B.no one knows

C.most people know

D.all the people know小题2:The word “disappear” in the passage means ________ in Chinese.

A.出现

B.远离

C.消失

D.靠近小题3:You fail to see the letter L in the experiment because ________.

A.your eyes are poor

B.its image falls on the blind spot

C.your left eye is not open

D.you move it close to your eye小题4:In which order (顺序) should you do the experiment?

①Hold the card

②Move the card nearer

③Close your right eye

④Write two English letters

⑤Look at the letter R

⑥Make a card

A.④⑥①②③⑤

B.①③⑥④⑤②

C.⑥①④③②⑤

D.⑥④①③⑤②小题5:The passage mainly (主要) tells us ________.

A.the blind spot can move

B.an interesting experiment

C.where the blind spot is

D.there is a blind spot on the eyes

单项选择题 A1型题