4.3 Building large databases

• Relational databases


  Divide data between two or more tables
• Normalisation


  The process of reorganising the flat database to identify related data as well as unwanted or duplicated data
• Converting a flat database into a relational database


  1. Identify related data

  2. Identify unwanted or duplicated data

  3. Reorganise the database