What is the best way to represent the attributes in a large database?
2024
What is the best way to represent the attributes in a large database?
Answer: B. Concatenation — ConceptIn a large schema, names should preserve enough context to distinguish attributes that play different roles. A schema-level naming convention can…
- A.
Relational-and
- B.
Concatenation
- C.
Dot representation
- D.
All of the mentioned
Attempted by 1335 students.
Show answer & explanation
Correct answer: B
Concept
In a large schema, names should preserve enough context to distinguish attributes that play different roles. A schema-level naming convention can combine a relation prefix with an attribute name to make that role explicit.
In this question, concatenation means forming one identifier from those name parts; it does not mean concatenating the stored data values.
Application
For a section attribute associated with instructor and student, the source convention forms inst_sec and student_sec. Each concatenated name carries a relation-specific prefix, so the two roles remain distinguishable.
Contrast
Relational-and is not a standard attribute-naming notation in the relational model.
Dot notation, such as instructor.section, qualifies a column reference in SQL; that is a different query-reference syntax from the concatenated schema-name convention tested here.
All of the mentioned cannot apply because Relational-and is not a defined representation method.
Cross-check
Both inst_sec and student_sec can be read as a relation-specific prefix joined to the attribute sec, matching the source explanation and official answer key. Therefore, the answer is Concatenation.