ITPEC FE Morning April 2023 Question 25

Which of the following is an appropriate explanation of a relational database?

a)It connects a parent record and a child record by using a pointer.b)It represents data in the form of a two-dimensional table.c)It represents the structure and meaning of data by using tags.d)It retains data and procedures in an integrated (or encapsulated) form.

Explanation

Data in the form of two-dimensional tables — the relational model keeps all data in tables (relations) of rows and columns.

Each row (tuple) is one record and each column (attribute) one data item. Tables are related through matching values, a foreign key holding the value of another table's primary key, not through physical pointers, and they are queried with SQL.

Answer (b)

Why not others:

•(a) — parent and child records linked by pointers is the hierarchical model (the network model also uses pointers).
•(c) — tags that describe the structure and meaning of data are XML, a markup language.
•(d) — data and procedures encapsulated together describe the object-oriented model.

Key rule: Match each data model to its structure: tables for relational, a pointer tree for hierarchical, a pointer graph for network, objects with methods for object-oriented.

Databases · AI-written, may contain errors

Previous Next

Practice this exam

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 FE past-paper collection or Report an issue.