数据库2005学年期末考试试卷.docVIP

华南农业大学期末考试试卷（A卷） 2005　学年第一学期　 考试科目： 数据库原理与方法 　 考试类型：（闭卷）　　　 考试时间： 120 分钟 学号 姓名 年级专业 2003 ___ Instructions to candidates: 1. This paper consists of 6 questions. 2. Answer all questions on the answer sheets. 3. Hand in the answer sheets, and this paper can be taken away. Question 1: (25 marks) Define the following terms. Each term is worth 2.5 marks. a. Database b. Physical data independence c. Data dictionary d. Transaction e. Serializable schedule f. Relational schema and relational instance g. Data mining h. Foreign key i. Functional dependency j. Checkpoints Question 2: (17 marks) Consider a university database including the following data objects: Departments: Each department has a unique id, a name, a location, and a telephone number. Departments employ professors and offer courses. Professors: Each professor has a unique id, a name, a rank and a salary. All professors with the same rank have the same salary. Professors teach courses and advise students. Students: Each student has a unique id, a name, gender, and age. Students enroll in courses. Courses: Each course has a course code. Courses also have a meeting day, time, and room. Loans: Students can take out a loan to help with their expenses. Each loan has a unique loan id, a loan amount, and the anticipated starting date for the payments. The system requirements are: Departments can employ more than one professor and each professor can work for multiple departments. There is a percent time associated with each department a professor works in. Departments also offer multiple courses each semester. Professors can teach multiple courses in each semester, and the same course in different semesters. Professors advise students and can have multiple advisees. Students enroll in several courses in each semester. For each course, a student receives a grade. Students are advised by a single professor. Students may