ITPEC IP October 2023 Question 29
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 an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.