Description
Database normalization is a technique for minimizing the duplication of information in order to make the database safe and easy to handle by redesigning the relational database tables into small and less redundant tables. As the world creates more and more large sized database tables, the need for database normalization also increases. So this is a very necessary topic in database theory. But this topic is somewhat abstract and theoretical, and its proper understanding is difficult for many students. They profit from working many examples. This thesis is focused on creating an interactive Java tool for normalizing the tables in a database to higher normal forms, i.e., 2NF,3NF and BCNF. This will help students to learn the normalization of database tables by giving them an interactive user interface for creating the database tables and then normalizing them. The user interface is created keeping in mind the design must be easy to use and clear in its outputs. This report describes the design and development of NF-Calculator (Normal Form Calculator). The report also contains several running examples to so that the reader can understand it properly.
