问题 问答题

[说明]


某宾馆需要建立一个住房管理系统,部分的需求分析结果如下。
(1) 一个房间有多个床位,同一房间内的床位具有相同的收费标准,不同房间的床位收费标准可能不同。
(2) 每个房间有房间号(如201、202等)、收费标准和床位数目等信息。
(3) 每位客人有身份证号码、姓名、性别、出生日期和地址等信息。
(4) 对每位客人的每次住宿,应该记录其入住日期、退房日期和预付款额信息。
(5) 管理系统可查询出客人所住房间号。
根据以上的需求分析结果,设计一种关系模型,如图4-28所示。


1. 根据上述说明和实体联系图,得到该住房管理系统的关系模式如下所示,请补充住宿关系。
房间(房间号,收费标准,床位数目)
客人(身份证号,姓名,性别,出生日期,地址)
住宿(______,住日期,房日期,款额)

答案

参考答案:表:住宿
属性:入住日期
类型:聚簇索引
原因:表中记录的物理顺序与索引项的顺序一致,根据索引访问数据时,一次读取操作可以获取多条记录数据,因而可减少查询时间

阅读理解

In my profession as an educator and health care provider, I have worked with numerous children infected with the virus that causes AIDS. The relationships that I have had with these special kids have been gifts in my life. They have taught me so many things, but I have especially learned that great courage can be found in the smallest of packages. Let me tell you about Tyler.

Tyler was born infected with HIV: his mother was also infected. From the very beginning of his life, he was dependent on medications to enable him to survive. When he was five, he had a tube surgically inserted in a vein in his chest. This tube was connected to a pump, which he carried in a small backpack on his back. Medications were hooked up to this pump and were continuously supplied through this tube to his bloodstream. At times, he also needed supplemented oxygen to support his breathing.

Tyler wasn’t willing to give up one single moment of his childhood to this deadly disease. It was not unusual to find him playing and racing around his backyard, wearing his medicine - laden backpack and dragging his tank of oxygen behind him in his little wagon. All of us who knew Tyler marveled at his pure joy in being alive and the energy it gave him. Tyler’s mom often teased him by telling him that he moved so fast she needed to dress him in red. That way, when she peered through the window to check on him playing in the yard, she could quickly spot him.

This dreaded disease eventually wore down even the likes of a little dynamo like Tyler. He grew quite ill and, unfortunately, so did his HIV - infected mother. When it became apparent that he wasn’t going to survive, Tyler’s mom talked to him about death. She comforted him by telling Tyler that she was dying too, and that she would be with him soon in heaven.

A few days before his death, Tyler beckoned me over to his hospital bed and whispered, " I might die soon. I’m not scared. When I die, please dress me in red. Mom promised she’s coming to heaven, too. I’ll be playing when she gets there, and I want to make sure she can find me. "

64. What is the boy Tyler's attitude towards death?

A.  optimistic.      B.  pessimistic.   C. sorrowful.              D. fearful.

65. Tyler requested the writer to dress him in red when he died simply because ________.

A. red is a lucky color                 B. red might help to cure him

C. his mom could spot him easily        D. he could find more mates by wearing red

66. Which of the following might serve as a possible title for this passage?

A. My unusual profession.                 B. A caring mother.

C. Mother and son.                         D. Dying in red.

67. The underlined word dynamo in the fourth paragraph here means ________.

A. a promising and helpful youth       B. an extremely energetic person

C. a rare and beautiful flower          D. a magic and understanding superstar

单项选择题