Table 2 Subject (1NF)

Table 3 Instructor (1NF)

Table 1 Student (1NF) Subject Code Subject Name
Student Student Name Instructor ID Subject Name
Number Math Math
1 Mr. Santos
101 Cruz
Pil Pilipino
2 Ms. Dee
102 Dela Pena SocSci Social Science
3 Mr. Reyes
103 Feliciano COM101 Communication 101
4 Mr. Torres
104 Roxas COM102 Communication 102
5 Ms. Vergara
COMw Communication
105 Zamora Writing 6 Mr. De Leon

Table 4 Grades (2NF) Table 5 Subject Instructor (3NF)

Table 4 Grades (1NF)
Student Subject Grad Instructor Subject Code Instructor ID
Subject Grade Instructor
Numbe Code e ID
Code ID Math 1
r
Math 1.25 1 Pil 2
101 Math 1.25 1
Pil 1.00 2
101 Pil 1.00 2 SocSci 3
SocSci 2.00 3
102 SocSci 2.00 3 COM101 4
COM101 1.50 4
102 COM101 1.50 4 COM102 5
COM102 2.50 5 103 COM102 2.50 5 COM101 4
COM101 1.50 4
104 COM101 1.50 4 COM102 5
COM102 2.00 5
104 COM102 2.00 5 COMw 6
COMw 1.22 6
105 COMw 1.22 6 Math 1
Math 1.50 1
105 Math 1.50 1
Table 4 Grades (3NF)

Student Subject Code Grade

Number
101 Math 1.25

102 Pil 1.00

103 SocSci 2.00

104 COM101 1.50

105 COM1