What are limitations of flat file?

Answer 1

Flat files have several limitations, including data redundancy, as they often store duplicate information, which can lead to inconsistencies. They lack the ability to enforce data integrity and relationships, making it difficult to manage complex data structures. Additionally, flat files are not optimized for querying and can become unwieldy as data volume increases, resulting in slower access and processing times. Finally, they typically do not support concurrent access, making collaboration challenging in multi-user environments.