When files must be related (customers to orders, vendors to purchases, etc.), a relational database manager is used, not a flat file manager. Flat files can be related, but only if the ...

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 ...