Question 28

A flat-file database is needed.

A flat-file database is a type of database that stores data in a single table, often in a plain text document format, with data entries separated by delimiters like commas. This structure is ideal for simple data storage without the complexity of relationships found in more sophisticated databases.

A) Hierarchical

A hierarchical database organizes data in a tree-like structure, where records have a parent-child relationship. This format is not suitable for storing data in a plain text document with delimiters, as it requires a more complex arrangement than what a simple flat-file setup provides.

B) Cloud

A cloud database refers to a database service hosted in a cloud environment, allowing for remote access and scalability. While it can support various types of databases, it does not specifically refer to the structure of data storage like a flat-file database does, making it an incorrect choice for this specific requirement.

C) Distributed

A distributed database consists of data spread across multiple locations or servers. This type of database requires a more complex architecture and management system than a flat-file database, which simply uses a single file format, thus making it unsuitable for the given context.

D) Flat-file

A flat-file database is defined by its use of a single table to store data in a plain text file format, using delimiters such as commas to separate entries. This directly aligns with the company’s need for a straightforward data storage solution without the added complexity of relational or distributed databases.

Conclusion

The flat-file database is definitively the correct answer as it meets the requirement of storing data in a plain text format with delimiters. In contrast, hierarchical, cloud, and distributed databases involve more complex structures and functionalities that do not align with the straightforward needs described in the question.