Database Normalization

This assignment focuses on database normalization, a crucial aspect of database design. It presents two case studies: one involving charity donations and another concerning customer supplies. For each case study, the assignment demonstrates the process of normalizing the database from the first normal form (1NF) to the Boyce-Codd normal form (BCNF). The solutions detail the tables created at each normalization level, explaining the rationale behind the changes and addressing potential dependencies. The assignment highlights the importance of minimizing data redundancy and ensuring data integrity through proper normalization techniques. The solutions provide a clear understanding of how to identify and resolve anomalies in database design, leading to a more efficient and reliable database system.