2014数据库系统期末试题及答案.doc

华南农业大学期末考试试卷（A卷） 2014-2015学年第一学期　 考试科目： 数据库系统 考试类型：闭卷 　　　 考试时间：　120 分钟 学号 姓名 年级专业 题号 一 二 三 五 六 总分 得分 评阅人 1: true-false question (15 points) For each of the following statements, indicate whether it is TRUE or FALSE (Using √ for TRUE and × for FALSE). You will get 1 point for each correct answer, -0.5 point for each incorrect answer, and 0 point for each answer left blank. Be sure to write your answer in the answer sheet. A primary key is a field (or group of fields) that uniquely describes each record in the database. Data redundancy improves the integrity of a database. SQL is the language used by relational databases to create objects and to manipulate and retrieve data. A relational database management system does not include tools for backing up restoring databases. An attribute is also known as a row in most databases. An association between entities is known as a relationship. Integrity constraints limit the number of entities that can be placed in a table or database. The Entity-Relationship data model is often used in the physical design phase. The concept “relation” in relation model is exactly the same as the concept “relationship” in ER model. Most relationship sets in a database system involves two entity sets. The closure of an attribute set contains that attribute set. Lossless decomposition is necessary in a decomposition algorithm. If A → B and C → D hold, then AC → BD also holds. It is not necessary that a legal schedule preserves the order in which the instructions appear in each individual transaction. Update operations in database must be written into log before updating database. Question 2 single-choice question (2 points for each problem, 30 points in total) 1. is the only one incorrect description from the followings: A. R=(R-S)∪(R∩S) B. R-S=R-(R∩S) C. R∩S=S-(R-S) D. R∩S=S-(S-R) 2. Choose the only one correct expression from th