What are the limitations of flat file databases?

Answer 1

• Data duplication

• Data inconsistency or update/deletion/insertion anomalies

• Data integrity errors (due to data inconsistency)

• Inconsistent search results in multi-value fields

Answer 2

Flat file databases have limitations such as lack of scalability, as they can become unwieldy and inefficient with large amounts of data. They also lack relational capabilities, making it challenging to establish connections between different sets of data. Additionally, flat file databases can be prone to data redundancy and inconsistency, as data is often duplicated across multiple files.