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

华南农业大学期末考试试卷（A卷） 2005学年第一学期 考试科目： 数据库原理与方法 考试类型：(闭卷) 考试时间：120 分钟 学号 姓名 年级专业 2003 Instructions to candidates: This paper consists of 6 questions. Answer all questions on the answer sheets. 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. Database Physical data in depe ndence Data diet ionary Tran sact ion Serializable schedule Relati onal schema and relati onal in sta nee Data mi ning Foreig n key Functional depe ndency Checkpo ints Question 2: (17 marks) Consider a university database including the following data objects: Departments: Each departme nt has a unique id, a n ame, a locatio n, and a teleph one nu mber. Departme nts employ professors and offer courses. Professors Each professor has a unique id, a n ame, a rank and a salary. All professors with the same rank have the same salary. Professors teach courses and advise stude nts. Students Each stude nt has a unique id, a n ame, gen der, and age. Stude nts en roll in courses. Courses Each course has a course code. Courses also have a meeti ng day, time, and room. Loans: Students can take out a loan to help with their expenses. Each loan has a unique loa n id, a loa n amount, and the an ticipated start ing date for the payme nts. The system requirements are: Departme nts can employ more tha n one professor and each professor can work for multiple departments. There is a percent time associated with each departme nt a professor works in. Departme nts 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 stude nt receives a grade. Stude nts are advised by a sin gle professor. Stude nts may apply for multiple loa ns. A sin gle course can only be taught once with in a giver semester, but can be repeated in