问题 问答题

[说明]

某汽车维修站拟开发一套小型汽车维修管理系统,对车辆的维修情况进行管理。

1.对于新客户及车辆,汽车维修管理系统首先登记客户信息,包括:客户编号、客户名称、客户性质(个人、单位)、折扣率、联系人、联系电话等信息;还要记录客户的车辆信息,包括:车牌号、车型、颜色、车辆类别等信息。一个客户至少有一台车。客户及车辆信息如表2-1所示。

2.记录维修车辆的故障信息。包括:维修类型(普通、加急)、作业分类(大、中、小修)、结算方式(自付、三包、索赔)等信息。维修厂的员工分为:维修员和业务员。车辆维修首先委托给业务员。业务员对车辆进行检查和故障分析后,与客户磋商,确定故障现象,生成维修委托书。如表2-2所示。

3.维修车间根据维修委托书和车辆的故障现象,在已有的维修项目中选择并确定一个或多个具体维修项目,安排相关的维修工及工时,生成维修派工单。维修派工单如表2-3所示。

4.客户车辆在车间修理完毕后,根据维修项目单价和维修派工单中的工时计算车辆此次维修的总费用,记录在委托书中。

根据需求阶段收集的信息,设计的实体联系图(见图2-1)和关系模式(不完整)如下所示。图2-1中业务员和维修工是员工的子实体。

[逻辑结构设计]

客户( (5) ,折扣率,联系人,联系电话)

车辆(车牌号,客户编号,车型,颜色,车辆类别)

委托书( (6) ,维修类型,作业分类,结算方式,进厂时间,预计完工时间,登记日期,故障描述,总费用)

维修项目(维修项目编号,维修项目,单价)

派工单( (7) ,工时)

员工( (8) ,工种,员工类型,级别)

根据问题描述,填写图2.1中(1)~(4)处联系的类型。联系类型分为一对一、一对多和多对多三种,分别使用1:1、1:n或1:*、m:n或*:*表示。

答案

参考答案:

(1) n 或 m 或*

(2) 1

(3) n 或 m 或*

(4) n 或 m 或*

阅读理解

第二部分阅读理解(共20小题,每小题2分,满分40分)

A

Theodore,the manager of the Paradise Hotel,told a middle-aged couple that that would have to leave the hotel after just one night.The couple,visiting from Texas,had booked a room for eight nights.

“They wanted a sterile (消毒了的) environment,”Theodore said,“They should have rented a room in a hospital,maybe an operating room.This hotel is clean,hut it isn't that clean.”

Theodore said that,on the very first day,the couple brought all the sheets,pilloweases,and bedspreads down to the main hall and just dropped them next to the front desk.They stood there next to this pile of bedding while other guests looked,pointed,and murmured.The hotel got three cancellations within the hour from people who witnessed this strange,event.

When Theodore asked the couple what the problem was,they said that their bedding was filthy and they wanted it replaced.The couple could not identify any specific“filth”on the bedding.The wife just said,“We’re paying good money to stay here.How dare you doubt us?We know the filth is there.That's all the proof you need,”Theodore called room service,and the bedding was replaced immediately.

Early the next evening,however,the couple marched to the front desk again and demanded seven cans of sterilizer,“We need a can for each night.We have to spray the phone,the TV,all the door handles,the toilet handle,the shower stall,the faucet,the sink,and any hotel staff entering our room.”

Worried,Theodore politely suggested that a hotel more suitable for them was just around the corner.He then called ahead to reserve a“very clean”room,and gave them free transportation in the hotel Rolls-Royce.Also,he told the couple that they wouldn’t he charged for the second day.

The couple were surprised but they really liked the idea of free room for a night and that expensive car service.

56.The underlined word “filthy” means     in this article.

A.clean               B.dirty                C.smelly                    D.old

57.Why was Theodore worried?

A.The couple might have more demands the following days.B.The hotel was not clean enough.

C.The hotel would run out of cleaning stuff.D.More guests would make the same requests.

58.What word could best describe the couple?

A.Narrow-minded.             B.Expensive        C.Particular         D.Easy-going

单项选择题