问题 多项选择题

[说明]


某公司信息管理系统的需求分析和部分关系模式设计的结果描述如下。
(1) 公司有多个部门,每个部门有一名负责人、一间办公室、一部电话和多名职员,每个职员最多属于一个部门,负责人也是一名公司职员。
(2) 公司职员的月工资大于等于1000元且小于等于8000元。
(3) 数据库的部分关系模式设计如下。
职员(职员号,职员姓名,月工资,部门号,办公室,电话)
部门(部门号,部门名,负责人代码,任职时间)
(4) “职员”和“部门”的关系示例分别如表3-27和表3-28所示。



1. 根据上述说明,请给出:
(1) “职员”关系模式的主键和外键。
(2) “部门”关系模式的主键和外键。

答案

参考答案:“职员”关系模式主要的问题如下
数据冗余问题。因为某部门的职员人数有多少,其办公室和电话将要重复存入多少
数据修改不一致问题。因为某部门的办公室变了可能会导致某些职员的修改了,某些职员的未修改
将关系模式修改为:职员(职员号,职员姓名,月工资,部门号)
部门(部门号,部门名,负责人代码,任职时间,办公室,电话)

配伍题 B1型题
填空题

A good translator is by definition bilingual. The opposite is not ______(1) true, however. A born and bred bilingual will still need two__________(2) to become a translator: first, the skills and experience necessary for__________(3); second, knowledge of the field in which he or she will__________(4). The skills and experience for translation include the ability to write ______(5) in the target language, the ability to read and understand the_________(6) language material thoroughly, and the ability to work with the latest__________(7) and communication hardware and software.Does a born and bred bilingual__________(8) a better translator than someone who learned language B later in__________(9) There is no definite answer, but the following issues are important.__________(10), a born and bred bilingual often suffers from not truly knowing __________(11) language well enough to translate, with some even suffering from what __________(12) known as a lingualism, a state in which a person lacks_________(13) full, fluent command of any language. Second, born and bred bilinguals__________(14) don’’t know the culture of the target language well enough to_________(15) top-quality translations, or cannot recognize what aspects of the source language__________(16) its culture need to be treated with particular care, as they_________(17) in a sense too close to the language. And last, they often_________(18) the analytical linguistic skills to work through a sticky text.On_________(19) other hand, the acquired bilingual may not have the same in-depth _________(20) of colloquialisms, slang, and dialect that the born bilingual has. Also, the acquired bilingual will not be able to translate as readily in both directions (from B to language A and A to language B). Finally, born bilinguals often have a greater appreciation of the subtleties and nuances of both their languages than someone who learns their B language later in life can ever hope to have.