Translations:Basic Excel Trainer/37/en

Features of a relational database include:

  • reduction in, or elimination of, data duplication
  • copes with relationships between pieces of data (for example, a record in one table may be linked to many records in another table)
  • easy to change data format
  • data can be added or removed easily
  • easy to modify (edit) data
  • easy to maintain data integrity
  • access to data can be restricted
  • can monitor who has done what, and when, with data (audit trail for changes)
  • data can be shared easily and multiple users can access it at the same time.