PPT Slide

Treca Normalna Forma

“U okviru logickog zapisa ne smije postojati atributi koji nisu u funkcionalnoj zavisnosti od primarnog kljuca”

SNET_STUDENT(studentID, studentName, Major,  college, collegeLocation, Loan, Gender)

SNET_STUDENT(studentID, studentName, Major)

SNET_COLLEGE(Major, College, collegeLocation)

Third Normal Form

This rule seeks to eliminate all attributes from a table that are not directly dependent upon the primary key. In the case of the Student table, the college and collegeLocation attributes are less dependent upon the studentID than they are on the major attribute. Therefore, I’ll create a new table that relates the major, college and collegeLocation information:

Previous slide

Next slide

Back to first slide

View graphic version