Difficulty: Easy
Correct Answer: both (a) and (b)
Explanation:
Introduction / Context:
Relational database terminology distinguishes the logical model from physical storage. Understanding the terms helps when reading documentation and communicating design decisions between engineers, DBAs, and analysts.
Given Data / Assumptions:
Concept / Approach:
In relational theory, a relation is the abstract mathematical construct; in practice, DBMSs expose this as a table. Rows are tuples and columns are attributes. Therefore, saying an RDBMS organizes data as tables/relations is correct, while “tuple” refers to a row, not the whole organizational unit.
Step-by-Step Solution:
Verification / Alternative check:
Textbooks and DBMS manuals commonly equate “relation (table)” while reserving “tuple” for an individual record.
Why Other Options Are Wrong:
Common Pitfalls:
Using “file” to mean “table”; conflating physical storage files with logical tables; forgetting that a single table can span multiple physical files or partitions.
Final Answer:
both (a) and (b)
Discussion & Comments