In this flat file database, the data on each member of staff is held together with all data for each department. This is unnecessary as some information is stored more than once (eg the same phone ...
Using flat file databases can lead to insertion, deletion and update anomalies. Use of relational databases where primary and foreign keys are used to link tables helps overcome these issues. Analysis ...