台大研所備考 | 資管所 & 資工所

106年

第 1 題

2.5 分

答案已完成可重現的技術覆核；非官方答案。查看原始試卷

Which of the following design is better (although not the best) than the others?

a.A single table containing all fields of data needed for the database.b.Two tables, one contains students' profiles (Student_ID, Student_Name, Student_Address), while the other contains all the other fields.c.Three tables, the 1st table contains students' profiles (Student_ID, Student_Name, Student_Address), the 2nd table contains Student_ID and the courses (Course_ID, Course_Name) they registered, the instructors (Instructor_ID, Instructor_Name), and grades, and the 3rd table contains the classroom information (Course_Name, Classroom, Course_Schedule).d.A table for students' profiles (Student_ID, Student_Name, Student_Address), a table for each course containing the registered students' names and their grades (i.e., Student_ID, Course_ID, GRADE), a table of instructors containing the faculty ID of each instructor, his name, and the courses s/he teaches (Instructor_ID, Instructor_Name, Course_ID), a table of classrooms containing the classrooms, the courses and time of the courses at each classroom (Classroom, Course_ID, Course_Schedule).e.A table containing (Student_ID, Student_Name), a table containing (Student_Name, Student_Address), a table for each course containing the registered students' names and their grades (Student_Name, Grade), a table for each instructor containing his ID, name and the courses s/he teaches (Instructor_ID, Instructor_Name, Course), a table for each classroom containing the courses and time of the courses using the classroom (Classroom, Course_Name, Course_Schedule). [Context: Suppose we wish to build a campus database containing tables of records about student profiles, courses registered, and grades. Fields include: Student_ID, Student_Name, Student_Address, Course_ID, Course_Name, Instructor_ID, Instructor_Name, Classroom, Course_Schedule (e.g., Wed. 9~12AM), Grade. A good database design practice is to avoid too much data overlapping between tables.]