Skip to main content

Posts

Showing posts with the label Normalization in Database

Normalization in Oracle database #Diksha Oracle Training Centre

                             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 Redun...