Britannica
Sources used in this answer
How do records and fields organize data in a database?
Created from Britannica articles
using AI.
AI can make mistakes, so verify using Britannica articles.
information system
A woman taking a driver's license test on a computer, an example of a government using an information system to provide services to citizens.
In the context of computer science, databases are organized to facilitate the efficient storage, retrieval, and management of information. Records and fields serve as the fundamental building blocks of this structure:12
- Fields: These are the basic units of data storage. Each field contains information pertaining to a single attribute or property of an entity, such as a person's name, address, or phone number.12
- Records: A record is a collection of related fields that provides a complete description of a specific entity. For example, in a personnel file, a single record would contain all the fields associated with one individual employee.12
These components are typically organized into files or tables. In a relational database, records are represented as rows (or tuples) in a table, where each column corresponds to a specific field. This structure allows a database management system to link data across different tables using common attributes, enabling complex queries and the maintenance of data integrity.321