It is a topic that should be covered in detail and I am sure that there are many resources available online from where you can learn about different types of normalization and keep one more thing in mind that we do normalization till 3NF. When I was studying the Database in my 5th Semester our teacher told us the following rules that helped us to understand the concept of normalization very well. And those rules are as following:
Keep Data According to the Table. e.g. If you have created a table named "Students" then you have to put data of students only not of "Teachers" and "Subjects".
Make Every Row Distinct by the Means of Primary Key or Composite Primary Key.
Always Make a Third Table for the Purpose of Many-Many Relationship.
Before making any database make a clear and effective Entity Relationship Diagram that should be first step as it will make the creation of database simple and effective.
It is a topic that should be covered in detail and I am sure that there are many resources available online from where you can learn about different types of normalization and keep one more thing in mind that we do normalization till 3NF. When I was studying the Database in my 5th Semester our teacher told us the following rules that helped us to understand the concept of normalization very well. And those rules are as following:
Thank you, that's really helpful. Also good to know that you validate my believe that I should take a deep dive into this topic!