Database Normalisation (0108)

Course Course : 0108

Duration : 5 days- 10am – 2pm UK time

• Database Normalisation is the process of organising a database to reduce data duplication and improve data accuracy and consistency
• Achieved by applying a set of guidelines (forms), each with specific rules and requirements
• Enhances database efficiency and maintainability
• Provides consistency within the database

Types of Forms

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Boyce and Codd Normal Form (3.5NF)

Practical examples

OLTP

Data Warehouse