DBI202Xuất hiện trong 1 đề thi
Consider the following table: (StudentID, StudentName, CourseID, CourseName, InstructorName, InstructorEmail) Redesign the table structure to achieve at least Third Normal Form (3NF).
Các lựa chọn
AStudents (StudentID, StudentName)
Courses (CourseID, CourseName, InstructorName, InstructorEmail)
Enrollments (StudentID, CourseID)
BStudents (StudentID, StudentName, CourseID)
Courses (CourseID, CourseName, InstructorName, InstructorEmail)
CCourses (CourseID, CourseName, InstructorName, InstructorEmail)
Enrollments (StudentID, StudentName, CourseID)
DStudents (StudentID, StudentName, CourseID)
Courses (CourseID, CourseName, InstructorName, InstructorEmail)
Enrollments (StudentID, InstructorName)