PPT Slide
Kao rezultat ovoga ce biti da cemo eliminisati grupu koja se ponavlja tako sto cemo podatke razbiti u tri manje tabele: Students, Stud_Classes i Professors.
Obviously, the original table contains several sets of repeating groups of data, namely classID, className, classTime, classLocation, professorID, professorName. Each attribute is repeated three times, allowing for each student to take three classes. However, what if the student takes more than three classes?
SNET_STUDENT(studentID, studentName, Major, college, collegeLocation, Loan, Gender)
SNET_STUD_CLASS(studentID, classID, className)
SNET_PROFESSOR(professorID, professorName)