3NF Relational Schema

1 of
Published on Video
Go to video
Download PDF version
Download PDF version
Embed video
Share video
Ask about this video

Page 1 (0s)

3NF Relational Schema.

Page 2 (47s)

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

Page 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.

Page 4 (1m 39s)

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

Page 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.