7/26/2023 0 Comments Database normalization![]() ![]() Boyce-code Normal Form(BCNF) 1.First Normal Form/1st Normal Form: There are following Four Normal Forms used in Database Normalization:Ĥ. To Overcome these kind of issues there is need to use the database normalized forms.When we try to normalize database check following 4 important points:ġ.Arrangement of data into logical groups.ģ.Organize the data in such way that when modification needed then there should be only one place modification required.Ĥ.User can access and manipulate data quickly and efficiently. If Employee_id 101 has only 1 department and we delete that temparary then Entire student record will be deleted. If new employee joined company and he or she has not alloted to department.Hence We need to insert nulll value there which leads to insertion Anamoly. If we want to update the city of employee who occurred twice or more than twice in the table then we need to update city of all the employees.Hence data will become inconsistent.Example is Employee named Amit is associated with two departments and the values of the departments are not Automic. Lets take Example of Employee Table: Employee ID Real Life Example of data which is not normalized: If your database objects are not in structured or normalized way it is difficult to update the database without facing the database loss.Insertion,Updation and deletion are very frequent if data is not normalized.Normalization is part of successful database design.Without Database normalization the database system can be slow,Inaccurate and inefficient. To Ensure data dependencies and data is logically stored.ĬLICK HERE TO GET INFORMATION ABOUT JOINS IN SQL Need Of Database Normalization :.To Ensure the relationship between tables as well as data in the tables. ![]() To Eliminate the redundant or useless data.Database normalization is nothing but organizing the tables and columns of the tables in such way that it should reduce the data redundancy and complexity of data and improves the integrity of data.ĭatabase Normalization is nothing but technique of designing the database in structured way to reduce redundancy and improve data integrity.ĭatabase Normalization is used for following Purpose: ![]() Database Normalization is organizing non structured data in to structured data. In this article we will focus on Database Normalization with real examples. In my previous article I have given details about SQL normalization with real industry examples. ![]()
0 Comments
Leave a Reply. |