My favorites | Sign in
Project Home Wiki Issues
READ-ONLY: This project has been archived. For more information see this post.
Search
for
Normalization  
Updated Jan 4, 2008 by vinya...@gmail.com

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.

Powered by Google Project Hosting