SQA Higher Computing Science Practice Exam

In a relational database, a table is the fundamental structure that organizes information about a specific topic into rows and columns. Each table represents a distinct entity, such as customers, products, or orders. The rows of the table, also known as records, correspond to individual instances of that entity, while the columns, referred to as fields or attributes, contain specific data points or characteristics associated with each record.

This organization allows for efficient data management and retrieval, facilitating the use of Structured Query Language (SQL) for data manipulation and queries. The tabular format enhances readability and provides a straightforward way to relate data points between different entities through the use of primary and foreign keys.

Other options provide related concepts in database design but do not represent the complete structuring of information. An entity refers to the object or concept represented in a database, a record is a specific entry in a table, and a field represents a single piece of data within a record. The table is the comprehensive structure that incorporates both records and fields.