In the logical organization of data, a group of related fields is combined to form which higher-level structure used to represent one instance of an entity?

Difficulty: Easy

Correct Answer: data record

Explanation:


Introduction / Context:
Understanding the building blocks of data organization helps you design, normalize, and query databases effectively. This question asks you to identify the next level up from “field” when representing a single business object like a customer or an order line.


Given Data / Assumptions:

  • A field is a single attribute (e.g., price, quantity).
  • Related fields are grouped to represent one entity instance.
  • Files/tables store multiple such instances.


Concept / Approach:
A data record (row) is the standard unit that aggregates fields to describe one entity instance. A data file (or table) is a collection of many records. “Menu” and “bank” are unrelated to the data modeling hierarchy in this context.


Step-by-Step Solution:

Start from fields (atomic attributes). Group fields into a record (one instance). Recognize that many records form a file/table. Select “data record.”


Verification / Alternative check:
Any relational table schema demonstrates this hierarchy: columns→row→table→database.


Why Other Options Are Wrong:

  • Data file: too broad; holds many records.
  • Menu/Bank: not modeling primitives.
  • None: incorrect because “data record” is correct.


Common Pitfalls:
Confusing record with file; overlooking that records are the immediate aggregation of fields.


Final Answer:
data record

More Questions from Database Systems

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion