Question 25

A relational database is needed.

A relational database is designed to store data in multiple tables that can be interconnected through relationships. This structure allows for efficient data retrieval and manipulation using logical joins.

A) Hierarchical

A hierarchical database organizes data in a tree-like structure, where each record has a single parent. This model does not support the complex relationships and multiple joins between tables that a relational database does, making it unsuitable for scenarios requiring data stored in various tables.

B) Relational

A relational database is ideal for the scenario described, as it allows for data to be stored in different tables that can be joined based on related keys. This enables complex queries and efficient data management, which aligns with the needs outlined in the extract.

C) Cloud

A cloud database refers to a database service hosted in a cloud environment, which can be relational or non-relational. While it can support relational databases, the term "cloud" does not specify the necessary structure for data organization, making it an incorrect choice for the specific requirements presented.

D) Distributed

A distributed database spreads data across multiple locations or systems, which can be relational or non-relational. Although it can manage large volumes of data, it does not inherently provide the structured relationships found in relational databases necessary for the logical joining of tables.

Conclusion

The relational database is definitively the correct choice for the type of database needed due to its ability to manage data across multiple interrelated tables. In contrast, the hierarchical, cloud, and distributed options do not fulfill the requirement for logical joins and structured data organization as effectively as a relational database.