下载提示
- 1.该资料是网友上传的，本站提供全文预览，预览什么样，下载就什么样。
- 2.下载该文档所得收入归上传者、原创者。
- 3.下载的文档，不会出现我们的网址水印。
文档列表
文档介绍
****题
一、[12分]用英文解释
DBMS 2、Data Dictionary 3、Transaction[10 分]
二、单项选择题
. There may be instances where an attribute has a set of values for a specific entity. This type of attribute is said to be []
A. single valued attribute B. multivalued attribute
C . simple attribute D. composite attribute
In a particular bank, a loan can belong to only one customer, and a customer can have several loans, then the relationship set from customer to loan is []
A. one to many B. many to many C. many to one D. one to one
A [] contains metadata — that is, data about data.
A. table B . view C. data dictionary D. trigger
The phrase greater than at least one " is represented in SQL by []
A. >all B. <all C. <some D. >some
In general, all aggregate functions except [] ignore null values in their input collection.
A. sum B. avg C. min D. count
If a schedule S can be transformed into a schedule S ' by a series of swaps of non-conflicting
instructions, we say that S and S ' are []
A. non-conflicting equivalent B. conflict equivalent
C. non-conflicting serializable D. conflict serializable
The fundamental operations in the relational algebra are []。
A. U , -, X,兀和6 B. U , -, 8,九和6
c. u, n, % 九和（T d. u , n, 8,九和6
In SQL, =some is identical to in, and [] is identical to not in。
A. <>some B. =all C. <>all D. =some
The result of true and null is【】。
A. null B. true C. false D. not null
The function sum applied on the collection {1,1,3,4,4,11} returns the value [].
A. 24 B. 6 C, 4 D. 11
三、[10分]设有Course（课程）、Teacher（教师）、Student（研究生），其中：
Course有属性cno（课程号）、cname（课程名）和mark（学分）；
Teacher有属性tno（教师编号）、tname（教师姓名）和major（专业属性）；
Student有属性sno（学号）、sname（学生姓名）、age（年龄）、bno（班级号）、score（总成绩） 属性。
Teacher与Student之间有指导论文的联系，用 Supervise表示，每位教师可指导多名研 究生，每名研究生有且只能有一位指导教师；
Teacher与Course之间有讲授的联系，用 Teach表示，每位教师可以教授多门课程，每 门课程可同时由多位教师开设。
试画出E-R图。
四、[12分]题设与第三题相同，试根据你所画的 E-R图，设计出关系数据库，并指出每个关系中
的主键和外键。
五、［8分］题设与第三题相同，试用关系代数表达：
1 .检索编号为‘t01 ’的老师的姓名
2 .检索班级号为‘b01'或者年龄大于21岁所有学生的姓名
六、［12分］题设与第
一、[12分]用英文解释
DBMS 2、Data Dictionary 3、Transaction[10 分]
二、单项选择题
. There may be instances where an attribute has a set of values for a specific entity. This type of attribute is said to be []
A. single valued attribute B. multivalued attribute
C . simple attribute D. composite attribute
In a particular bank, a loan can belong to only one customer, and a customer can have several loans, then the relationship set from customer to loan is []
A. one to many B. many to many C. many to one D. one to one
A [] contains metadata — that is, data about data.
A. table B . view C. data dictionary D. trigger
The phrase greater than at least one " is represented in SQL by []
A. >all B. <all C. <some D. >some
In general, all aggregate functions except [] ignore null values in their input collection.
A. sum B. avg C. min D. count
If a schedule S can be transformed into a schedule S ' by a series of swaps of non-conflicting
instructions, we say that S and S ' are []
A. non-conflicting equivalent B. conflict equivalent
C. non-conflicting serializable D. conflict serializable
The fundamental operations in the relational algebra are []。
A. U , -, X,兀和6 B. U , -, 8,九和6
c. u, n, % 九和（T d. u , n, 8,九和6
In SQL, =some is identical to in, and [] is identical to not in。
A. <>some B. =all C. <>all D. =some
The result of true and null is【】。
A. null B. true C. false D. not null
The function sum applied on the collection {1,1,3,4,4,11} returns the value [].
A. 24 B. 6 C, 4 D. 11
三、[10分]设有Course（课程）、Teacher（教师）、Student（研究生），其中：
Course有属性cno（课程号）、cname（课程名）和mark（学分）；
Teacher有属性tno（教师编号）、tname（教师姓名）和major（专业属性）；
Student有属性sno（学号）、sname（学生姓名）、age（年龄）、bno（班级号）、score（总成绩） 属性。
Teacher与Student之间有指导论文的联系，用 Supervise表示，每位教师可指导多名研 究生，每名研究生有且只能有一位指导教师；
Teacher与Course之间有讲授的联系，用 Teach表示，每位教师可以教授多门课程，每 门课程可同时由多位教师开设。
试画出E-R图。
四、[12分]题设与第三题相同，试根据你所画的 E-R图，设计出关系数据库，并指出每个关系中
的主键和外键。
五、［8分］题设与第三题相同，试用关系代数表达：
1 .检索编号为‘t01 ’的老师的姓名
2 .检索班级号为‘b01'或者年龄大于21岁所有学生的姓名
六、［12分］题设与第
数据库考试题及答案 来自淘豆网www.taodocs.com转载请标明出处.