Question

Underlining in Relational Schema

A. Underline both foreign and primary keys
B. Underline only foreign keys
C. Underline only primary keys
D. No underlining for keys

Answer 1

In a relational schema, only primary keys are underlined to identify them as unique identifiers for records in a table, while foreign keys are not underlined.

Step-by-step explanation:

In a relational schema, the convention is to underline only primary keys. Foreign keys are not typically underlined, but they may be annotated or identified differently, such as through comments or naming conventions. The primary key is a unique identifier for a record in a table and is crucial for ensuring data integrity. In contrast, foreign keys are attributes that establish a relationship between tables by referring to the primary key in another table.