Which term best describes a system designed to store and manage structured information about items?

• A. Database
• B. File
• C. Spreadsheet
• D. Archive

Answer: (A)

When you need to store and manage structured information about items, a database is the right fit. A database organizes data into tables with rows (records) and columns (attributes), making it easy to store details like item IDs, names, categories, prices, and stock levels. It supports relationships between tables (for example, linking an item to its supplier or category), enforces data types and rules to keep information accurate, and allows powerful queries to retrieve, update, or analyze data quickly. It also handles multiple users and uses indexing to speed up searches, which is essential for keeping inventories or catalogs up to date.

A simple file is just a stream of data with little built-in structure for querying or enforcing consistency. A spreadsheet stores data in cells and is excellent for calculations and simple lists but isn’t ideal for managing complex relationships or ensuring data integrity across many records. An archive is intended for long-term storage and preservation, not for active data management or frequent updates.