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. ConcatenationConceptIn a large schema, names should preserve enough context to distinguish attributes that play different roles. A schema-level naming convention can…

  1. A.

    Relational-and

  2. B.

    Concatenation

  3. C.

    Dot representation

  4. 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.

Explore the full course: Lti Mindtree Preparation

Loading lesson…