|
Normalization
For this project we have applied normalization. Currently, First Normal Form (1NF) and Second Normal Form (2NF) are the normal forms applied. First Normal Form First normal form (1NF or Minimal Form) is a normal form used in database normalization. A relational database table that adheres to 1NF is one that meets certain criteria which are basically concerned with ensuring that the table is a faithful representation of a relation and that it is free of repeating groups. Matriculation Number in table Student, ID in Course, Subject and in Teacher table acts as unique key thereby avoiding the repeating groups. Second Normal Form Table Course is in Second Normal Form (2NF) since none of its non-prime attributes are functionally dependent on a part (proper subset) of a candidate key. Subjects contain a unique list of Students recognized by Matriculation Number and also contain a list of Subjects list in which the students are enrolled in. Given any candidate key (student matriculation number) and any attribute that is not a constituent of a candidate key; the non-key attribute depends upon the whole of the candidate key rather than just a part of it. |