ITPEC FE Subject A April 2025 Question 19

Which of the following is the primary goal of conceptual database design?

a)To create a physical data model of the databaseb)To define the logical structure of the databasec)To determine the exact data types for every database attributed)To implement database security measures

Explanation

Defining the logical structure of the database — conceptual design decides what data exists and how it relates, independent of any DBMS.

Conceptual design models the business's entities, their attributes and the relationships between them, typically as an E-R diagram. Later steps turn that model into tables for the chosen data model and then into storage details such as data types, indexes and files for a specific DBMS.

Answer (b)

Why not others:

•(a) — the physical data model is the output of physical design, the last step
•(c) — exact data types are fixed later, in logical and physical design, once a DBMS is chosen
•(d) — security measures such as access rights are implemented when the database is built and operated, not in conceptual design

Key rule: Conceptual design fixes what data exists and how it relates; logical design turns it into tables and keys; physical design decides how it is stored on a specific DBMS.

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.