IPA IP 2022 Question 83
A question IPA Japan published in 令和4年度 ITパスポート試験 公開問題 問83, translated into English. ITPEC is based on the same exams.
Same question on ITPEC: Oct 2023 Q29
Which of the following is a database model that represents data in a table that is composed of rows and columns?
Explanation
Relational model — data is held in two-dimensional tables of rows and columns.
In the relational model each table (relation) has columns (attributes) with a name and type, and each row (tuple) is one record. Tables are related not by pointers but by matching values, such as a foreign key that holds the primary key of another table. SQL databases are built on this model.
Answer (c)
Why not others:
- •(a) Object model — data is held as objects that combine attributes with methods, as in object-oriented programming
- •(b) Hierarchical model — records are arranged in a tree, each child with exactly one parent
- •(d) Network model — records are linked by pointers into a graph, so a record may have several parents
Key rule: Tables of rows and columns mean the relational model; a tree means hierarchical, a graph of linked records means network, objects with methods mean the object model.
Databases · AI-written, may contain errors
This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.