Normalization in Oracle database. Hello Everyone , Today I am going to discuss about Normalization . Before starting this topic I suggest you to please go through my previous blogs for your reference. Let’s discuss about Normalization. Normalization rules divide larger tables into smaller tables and links them using relationships. Normalization in Database is very important as it is the process of taking data from a problem and reducing it to a set of relations while ensuring data integrity and eliminating data redundancy. In Simple word Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion . Below are the Key Points in Normalization. Data Integrity : All of the data in the database are consistent , and satisfy all integrity constraints. Data Redundancy : If data in the database can be found in two different locations( Direct redundancy)
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.