In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables.
Implementation of Normal Forms
Let us start with a table, named StudentProject. I added few records in the table as per the defined structure. I will verify if the table satisfies different normal forms. I will modify the table structure or will split the data in multiple tables to fulfill the requirements