令和4年度 ITパスポート試験問83

This question's explanation and your answers so far.

問83

頻出度★☆☆

データを行と列から成る表形式で表すデータベースのモデルはどれか。

出典　令和4年度 ITパスポート試験問83

解説

問 83

Incorrectア
The object model handles data in units of 'objects' that combine data and operations (methods) into a single whole; it does not represent data in a tabular form composed of rows and columns.
Incorrectイ
The hierarchical model represents data in a tree structure (a tree-shaped hierarchy) with parent-child relationships, not in a tabular form. A child can have only one parent.
ウ
正解 The relational model is a database model that represents data in two-dimensional tables (tables) made up of rows (records/tuples) and columns (fields/attributes). The question's description, 'represented in a tabular form composed of rows and columns', is exactly the definition of this model, so the correct answer is ウ. The most widely used RDBMS (Relational Database Management System) today is based on this relational model.
Incorrectエ
The network model represents the relationships between data by connecting them in a net-like (graph) structure. Unlike the hierarchical model, a child can have multiple parents. It is not a tabular form.

ここがポイント

Relational model = a database model that represents data in two-dimensional tables of rows (records) and columns (attributes); it is the foundational concept of RDBMS.
Distinguishing the main data models: relational model (tables) / hierarchical model (tree structure) / network model (net structure) / object model (object-based).

用語

解答問83ウ