Which of the following best describes the structure of a relational database?
2024
Which of the following best describes the structure of a relational database?
- A.
Data organized into tables with rows and columns
- B.
Data organized into files and folders
- C.
Data organized into a hierarchical tree structure
- D.
Data organized into a network of interconnected nodes
Attempted by 2413 students.
Show answer & explanation
Correct answer: A
Answer: Data organized into tables with rows and columns
Why this is correct:
Relational databases use tables as the primary structure. Each table stores records as rows and attributes as columns.
Tables have schemas that define column names and data types, helping ensure consistent data storage.
Relationships between tables are expressed using keys: a primary key uniquely identifies rows in one table, and a foreign key in another table refers back to that primary key.
Structured Query Language (SQL) is commonly used to query and manipulate relational data, including joining tables based on keys.
Brief example:
An Employee table (rows are employees, columns include employee_id, name, department_id) and a Department table (columns include department_id, department_name). The department_id links employees to their department.
A video solution is available for this question — log in and enroll to watch it.