Britannica
Sources used in this answer
How do relational databases organize data into tables?
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 a relational database, data is organized into a tabular format where each table represents a collection of related information. The structure functions as follows:
- Rows (Tuples): Each row in a table represents a single record or entity. It contains a set of attribute values that describe that specific entity.12
- Columns: Each column represents a specific property or attribute of the entities stored in the table. Data integrity is maintained by specifying the required data type for each column.2
- Relationships: The relational model allows for data to be linked across multiple tables. This is achieved through a "join" operation, which combines records from different tables that share identical values in common attributes, such as a unique identification number.2
By organizing data this way, the system provides a structured approach to managing information, allowing users to perform complex queries across disparate but related datasets efficiently.12