3NF Relational Schema

Published on Slideshow
Static slideshow
Download PDF version
Download PDF version
Embed video
Share video
Ask about this video

Scene 1 (0s)

3NF Relational Schema.

Scene 2 (47s)

NORMALIZATION. 1NF Functional Dependency StudentID, attendanceID => studentName, age, MyKid, Gender, Date, isAttend, teacherID, teacherName, teacherPass, classCode, className, parentID, parentName, parentAddress, telephoneNumber, icNumber.

Scene 3 (1m 26s)

NORMALIZATION. 2NF Partial Dependency StudentID => studentName, age, MyKid, Gender attendanceID => Date, isAttend StudentID, attendanceID => teacherID, teacherName, teacherPass, classCode, className, parentID, parentName, parentAddress, telephoneNumber, icNumber.

Scene 4 (1m 39s)

NORMALIZATION. Transitive Dependency teacherID => teacherName, teacherPass classCode => className parentID => parentName, parentAddress, telephoneNumber, icNumber StudentID, attendanceID => teacherID, classCode, parentID.

Scene 5 (2m 0s)

NORMALIZATION. 3NF StudentID => studentName, age, MyKid, Gender attendanceID => Date, isAttend teacherID => teacherName, teacherPass classCode => className parentID => parentName, parentAddress, telephoneNumber, icNumber StudentID, attendanceID => teacherID, classCode, parentID.