関係データベースを構成する要素の関係を表す図において,図中の a ~ c に入れる字句の適切な組合せはどれか。 図(関係データベースの構成要素の関係): - 「関係データベース」全体の中に,複数の四角形が含まれており,それらを指して「a の集まり」と示す。 - そのうちの一つを取り出すと,「項目1」「項目2」「項目3」… を列に持つ表であり,この各行(横一列)を指して「b の集まり」と示す。 - さらにその中の 1 行を取り出すと,複数のセルが横に並んだものであり,その各セルを指して「c の集まり」と示す。
令和6年度 ITパスポート試験 問60
This question's explanation and your answers so far.
問 60
Incorrectア
a = Table is correct, but b and c are swapped. A horizontal line (row) of the table is one piece of data, namely a record, not a field. The rows that “collection of b” points to in the figure are a collection of records, so a field cannot go in b.
- イ
正解 The figure represents the elements of a relational database nested in order from largest to smallest. (a) The inside of the relational database (the cylinder) is a collection of several boxes, that is, tables, so a = Table. (b) Taking out one table gives a table whose columns are Item 1, Item 2, Item 3 ...; one horizontal line (a row) of it is one piece of data, namely a record. Since the arrow points to a collection of rows, b = Record. (c) Breaking a single row down further gives each cell arranged horizontally, that is, the value of each individual item (column), which corresponds to a field. Since the arrow points to a collection of cells, c = Field. Therefore option イ, the combination a: Table, b: Record, c: Field, is correct.
Incorrectウ
a = Field is wrong. The boxes lined up inside the relational database (the cylinder) are tables, not fields that represent columns. The top-level element is the table, and placing a table in b also does not match the figure.
Incorrectエ
a = Record is wrong. What is lined up directly under the database is the table, and a record (row) is an element inside a table, so the hierarchy is off by one level. Placing a table in b also contradicts the nesting relationship in the figure.
- The elements of a relational database form a hierarchy. From largest to smallest they are nested in the order relational database ⊃ table ⊃ record (row) ⊃ field (column/item).
- A record refers to a horizontal line of the table (one piece of data), and a field refers to each individual item corresponding to a column. The key point is not to confuse their hierarchical relationship (table > record > field).