Normalisation (Database)

March 20, 2017 antony 0

Data normalisation organises data in a database (across multiple tables/entities/relations) to ensure there is no data redundancy and to avoid anomalies (insert, deletion, update).  There […]

Data Integrity (database)

March 27, 2016 antony 0

Data integrity is about ensuring all data is consistent and accurate throughout a database. Referential integrity ensures all foreign keys have a primary key in another […]