问题 问答题


阅读下列说明和图,回答问题1至问题3。
【说明】
图书管理系统详细记录图书库存情况、读者信息及读者借阅记录(包括借书日期和还书日期)。
新书入库时要为该书编制图书卡片,包括分类目录号、图书流水号(要保证每本书都有唯一的流水号,即使同类图书也是如此)、书名、作者、内容摘要、价格和购书日期。同一个书名由于版次、作者等不同有可能存在多“种”图书,其间用“分类目录号”区分。
系统为每一位合法读者编制一个唯一的借书证号,读者需要提供姓名、单位。
一个读者最多可以同时借阅5本图书。借阅图书时,新添借阅记录,并将对应的“归还标记”字段置为“false”,表示“尚未归还”;归还图书时,将相应的“归还标记”字段置为“true”,表示“已经归还”。一本书可能供多位读者借阅,同一本书读者可以重复借阅。
如图9-17所示为该系统的E-R图。

【问题2】
由于同一个分类目录号(同一种图书)有多个副本,若用表Book(图书流水号,分类目录号,书名,作者,内容摘要,价格,购书日期)存储图书信息则有很多的冗余信息,该如何分解使之满足BCNF,并指出分解后的关系模式的主键。

答案

参考答案:

解析:图书(分类目录号,书名,作者,内容摘要,价格,购书日期),主键:分类目录号 副本(图书流水号,分类目录号),主键:图书流水号

[分析]: 由于同一个分类目录号(同一种图书)有多个副本,同一个分类目录号具有相同的很多信息:书名、作者、内容摘要、价格等,同—种书中的不同副本由图书流水号区分。故可分解如下: 图书(分类目录号,书名,作者,内容摘要,价格,购书日期),主键:分类目录号 副本(图书流水号,分类目录号),主键:图书流水号

单项选择题
完形填空

第II卷非选择题(共35分)
第一节:任务型阅读(共10小题;每小题1分,满分10分)
请认真阅读下列短文,并根据所读内容在文章后表格中的空格里填入最恰当的单词。
This year, about 2,300 teenagers from all over the world will spend about 10 months in US homes. At the same time about 1,300 American teenagers will go to other countries to learn new languages and learn the rest of the world.
Here is a 2-way student exchange in action .Fred,19, spent last year in Germany with George’s family. In turn, George’s son Mike spent a year in Fred’s home in America.
Fred, a lively young man, knew little German when he arrived .But after 2 months of studying, the language became easy for him. School was completely different from what he had expected and it was much harder. Students rose respectfully when the teacher entered the room. They took 14 subjects instead of 6 that were usually taken in the US.
Family life ,too, was different. The father’s word was the law. All the activities were done with the family rather than individually .Fred found the food to be too simple at first. He also missed having a car.
“Back home ,you pick up some friends in a car and go out to have a good time .In Germany, you walk but you soon learn to like it .”
At the same time, in America, Mike ,a friendly German boy, was also forming his own ideas. “I suppose I should criticize American schools” he says , “It is far too easy for our level but I have to say that I like it a lot In Germany, we do nothing but study. Here we take part in many other activities. I think that maybe American schools are better than in training their citizens. There ought to be some middle ground between the two.”
Differences between American school life and German school life
Items(项目)
American students
German students
Class rules
They don’t have to stand up
They have to _76_ and show respect to their 77
78   life
They do their own things individually.
They have to listen to their 79
School 80
They have six which are very 81  to learn
They have 14 which are much more difficult
Going out
They can 82  cars
They have to 83  all the way
School activities
They have 84 other activities
They have to 85  hard all the time