Databases Relational over Flat File

?

Databases Relational over Flat File

Advantages

  • Data Integrity, You Only need to change the data in one of the tables, it will then update itself
  • Data Redundancy, By having a relational databse it ensures that no attributes are repeated
  • Data Consistency, There is no chance of the same attribute being stored in a different format in a different file
  • Data Flexibility, When dealing with queries, it gets much easier creating deeper queries with a relational Databse
  • Greater Efficiency, as you only have to input the data only once into a relational database it saves time and human resources

Disadvantages

  • Complex, Relational databases can be very complex and without the necessary training can be very hard to break down.
  • Expensive, Relational databases are mostly commercial and require the user to buy that piece of software or licenses for more than one machine

Evaluation

Relational files can be linked into more than one table than are linked from one to another.

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »