Student Record Keeping System

Again this is only a rough and very basic student record keeping system done to illustrate the concepts of third normal form within a relational database.

Information needed:

Upon analyzing this, we discover we needed:

We needed to remove everything about the major except the major code, we needed to remove the course name and we needed to remove the repeating groups (the courses the students have taken) to put this into third normal form.

Student File

Student Course File

Course File

Major File


Student id# = KEY

Student id# + Course # +

Semester/year taken = KEY

Course # = KEY

Major code = KEY


Course Name

Major name

Major code


Dept chair






Date started college


Date graduated


Degree awarded