"Om Swastiastu"
Hi guys, this time I wanna tell you how to convert table into third normal form. In this table, StudentNum determines StudentName, NumCredits, AdvisorNum, and AdvisorName. AdvisorNum determines AdvisorName. CourseNum determines Description. The combination of StudentNum and CourseNum determines Grade.
Student (
StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, (CourseNum, Description, Grade))
STEP 1: Remove the repeating group to convert it to first normal form, yielding:
Student (
StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName,
CourseNum, Description, Grade)
The table is now in first normal form because it has no repeating groups. It is not, however, in second normal form, because StudentName, for example, is dependent only on StudentNum, which is only portion of primary key.Continue Reading »
