数据库试题参考..docVIP

（学生考试用） 课程名称： 数据库系统(英) 学分： 3 大纲编号 试卷编号： A 考试方式： 闭卷 满分分值： 70 考试时间： 120 分钟 组卷日期： 2010年1月20日 组卷教师（签字）： 审定人（签字）： 学生班级： 学生学号： 学生姓名： 说明：1.所有答案做在答卷纸上,并请标明题号 2.考试完毕后连考卷一起交上 Question 1 (20 points, 1 per part) 1. If a product can be manufactured in many plants, and a plant can manufacture many products, this is an example of which type of relationship from products to plants? A) Many-many B) Many-one C) One-one D) One-many 2. If we use the “E/R” approach of converting the following E/R diagram to relations, which of the following would be one of the relation schemas we construct? A) B(d,e,f) B) C(g,e) C) A(d,f,g) D) B(d,f) 3. Which of the following four expressions of relational algebra is not equivalent to the other three? They are all based on the relations R(A,B) and S(B,C). A) B) C) D) 4. Assume R and S are each relations with attributes a and b only. Q1: Q2: Which of the following is correct? 第 1 页 A) Q1 and Q2 produce the same answer. B) The answer to Q1 is always contained in the answer to Q2. C) The answer to Q2 is always contained in the answer to Q1. D) Q1 and Q2 produce completely different answers. 5. Suppose the relation R(A,B,C) has the following four tuples: A B C 3 1 2 4 1 2 3 1 4 4 1 4 Which of the following functional dependencies can you infer does not hold in R? A) A-B B) BC-A C) C-B D) AB-A The following two questions refer to a relation R(A, B, C, D,E) with functional dependencies ABC-DE, and D-AB. 6. Which of the following is the highest normal form of R? A) 1NF B) 2NF C) 3NF D) BCNF 7. The number of superkeys of R is: A) 2 B) 7 C) 10 D) 12 8. In the following, assume a is an attribute of some character-string type, e.g.