最新中南大学大二计算机专业数据库系统概论英文试卷及答案.docVIP

班号 学号 姓名 成绩 中南大学? 数据库系统概论 ?期末考试卷 考前须知：1、考试时间2小时； 2、答案写在答题纸上 Problem 1: TRUE or FALSE QUESTIONS (30 points). For each of the following statements, indicate whether the entire statement is TRUE or FALSE 1. There are five different entities and five binary relationships in an ER diagram. Two of the relationships are 1:1 relationship; 3 of them are M:N. After translating from ER model to Relation model, we can probably get 9 relations (tables). TURE 2. An E-R diagram will translate uniquely to a relational schema. FALSE 3. 3. A relation with two attributes is always in 3NF, but may not be in BCNF. FALSE 4. R ?? (S ∩ T) = (R ?? S) ∩ (R ?? T) TRUE 5. In relational algebra, join is a derived operator. TRUE 6. In a table, there is exactly one key, but there can be multiple candidate keys. TRUE 7. The natural join of two relations R(A,B) and S(C,D), which have no common attributes, is equivalent to their Cartesian product. TRUE 8. In SQL, without GROUP BY, we cannot use HAVING. TRUE 9. Triggers can operate on insertion, deletion, and updates. TRUE 10. There are two relations: Stu_Course(stu_name, course, score), Score_Sum(stu_name, Sum). The user wants to define a constraint as: for the same student, the value of Sum attribute in score_sum table equals the sum of all score attribute values in stu_course table. We can use Check constraint to apply this requirement. FALSE Problem 2: (10 Points) Consider the following schedule： T1 STARTS T1 reads item B T1 writes item B with old value 11, new value 12 T2 STARTS T2 reads item B T2 writes item B with old value 12, new value 13 T3 STARTS T3 reads item A T3 writes item A with old value 29, new value 30 T2 reads item A T2 writes item A with old value 30, new value 31 T