问题 问答题

[说明]
某学校的教学系统描述如下:
学生信息包括:学号(Sno)、姓名(Sname)、性别(Ssex)、年龄(Sage)、入学年份(Syear)、主修专业(Smajor),其中学号是入学时唯一编定的。
教师信息包括:教工号(Tno)、姓名(Tname)、性别(Tsex)、年龄(Tage)、职称(Title),其中教工号是唯一编定的。
课程信息包括:课程号(Cno)、课程名称(Cname)、学时(Cpeiiod)、学分(Ccredit),其中课程号是唯一编定的。
每个专业每个年级只有一个班级,这样班级就可用入学年份标识。
每位教师只教授特定的一门的课程,每门课程可以有多个教师教授,各位老师的上课地点及上课时间有所不同。注意:一门课程至少有一位教师教授,否则这门课程就视为不存在。
每位学生可以同时选修多门不同的课程,一门课程至少要有10位学生选修,否则就取消这门课程的开设。注意:选修课程时要指定任课教师,不能重复选修同一门课程。课程结束后,任课教师给选修该课程的学生一个成绩(Grade)。注意:教师不能给没有选修他所教授课程的学生成绩,即使选修了其他教师教授的同一门课也不行。
图2-1是经分析得到的E-R图。
[图2-1]


1.根据题意,给出联系的属性。实体间的联系有“一对一”、“一对多”和“多对多”,指出各联系分别属于哪一种。

答案

参考答案:Sno IN
(2)AVG(Grade)>85

解析:SELECT [ALL|DISTINCT]<目标列表达式>[,(目标列表达式>]…
FROM <表名或视图名>[,<表名或视图名>]
[WHERE(条件表达式>]
[GROUI BY <列名1>[HAVING<条件表达式>]]
[ORDER BY <列名2>[ASC|DESC]…]
子句顺序为SELECT、FROM、WHERE、GROUP BY、HAVING、ORDER BY,但SELECT和FROM是必须的,HAVING子句只能与GROUP BY搭配起来使用。
子查询的语意应为“按学号分组、平均分大于85的学生的学号”,可得空(1)应填Sno IN,空(2)应填AVG(Grade)>85。

解答题
阅读理解

阅读理解。

     Henry was an office worker in a big city. He worked very hard and enjoyed traveling in his holidays.

He usually went to the seaside, but one year he saw an advertisement in a newspaper. "Enjoy country life. Spend a few weeks at West Hill Farm. Good food. Fresh air. Horse riding. Walking. Fishing. Cheap and

interesting."

     "This sounds a good idea," he thought. "I'll spend a month at West Hill Farm. I think I can enjoy horse

riding, walking and fishing. They'll make a change from sitting by the seaside and swimming."He wrote to

the farmer. In the letter he said that he would like to spend all of July there. Then on the first of July, he left for West Hill Farm.

      But four days later, he returned home.

      "What was wrong with West Hill Farm?" his best friend, Ed, asked him. "Didn't you enjoy country life

?" "Country life was very good," Henry said. "But there was another problem."

      "Oh. What?""Well,"he said,"the first day I was there a sheep died, and we had roast mutton for dinner.

     "What's wrong with that?" Ed asked. "Fresh meat is the best."

     "I know, but on the second day a cow died, and we had roast beef for dinner."

     "Lucky you!"

     "You don't understand," Henry said. "On the third day a pig died and we had roast pork for dinner."

     "A different meat every day," Ed said loudly, " and you are complaining!"

     "Let me finish," Henry said. "On the fourth day the farmer died, and I didn't dare (敢)stay for dinner!"

1.How did Henry find out about the farm?

A. He saw it in a newspaper advertisement.

B. His best friend told him.

C. He wrote to the farmer.              

D. Maybe he learned it from the radio.

2. Henry came back home several days later because ________.

A. he didn't like the country life at all    

B. the farmer wasn't friendly to him

C. his holiday was over                

D. he thought he might have to eat the farmer

3. "…and you are complaining!", the word "complain" means ________.

A.夸奖  

B.强词夺理  

C.抱怨  

D.故弄玄虚

4.Which of the following sentences is true?

A. Ed could eat a different kind of meat every day.

B. Henry thought he could enjoy a change.

C. Henry couldn't think of anything else to do, so he went to the farm.

D. The farmer died because of the bad meat he ate.

5.Which is the best title for the passage?

A. What a beautiful farm!    

B. Have a good time.

C the farmer died          

D. Henry and his short holiday