Question

A relation in a relational database is also known as:

• A. A data type
• B. An attribute
• C. A schema
• D. A table

Answer 1

The Correct Option is D

A table is the term used for a relation in a relational database. The reasoning is as follows:

• A relation in a relational database comprises a set of tuples, where each tuple shares the same properties defined by a set of attributes. This structure is functionally identical to a table in database terminology.
• Tables consist of rows and columns. Each row corresponds to a tuple in the relational model, and each column represents an attribute.
• The term schema denotes the database's overall design and structure, encompassing tables and other elements. It dictates data organization and the associations between relations.
• Attributes are the specific fields within a table's structure, defining the type of data in a column but not the entire relation.
• The concept of a data type dictates the kind of value permissible in an attribute or field within a table; it does not define a relation on its own.

Consequently, the accurate identification is: A table.