Database Systems Normalization Assignment for CS-630 Students

This document presents a comprehensive solution to a database normalization assignment, demonstrating the process of transforming a given table through the stages of First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF). The solution starts with an initial table and then progressively decomposes it into normalized tables, addressing redundancies and dependencies. The solution includes dependency diagrams to visually represent functional dependencies and the relationships between attributes. The normalized tables include EMPLOYEE_DETAILS, POSITION_DESCRIPTION, DEPARTMENT, and EMPLOYEE_DEPENDENT_DETAILS, each designed to adhere to the principles of normalization. Furthermore, the assignment incorporates enhancements by introducing new attributes such as gender, date of birth, contact information, email, address, and salary to the EMPLOYEE_DETAILS table. It also includes a lookup table for positions and foreign key constraints to ensure data integrity. This assignment is designed to provide a practical understanding of database normalization and its importance in designing efficient and reliable database systems.