ITPEC FE Subject A April 2025 Question 19
ITPEC FE Subject A April 2025 — Question 19 of 60
Conceptual Database Design — define the logical structure of data independently of any specific DBMS.
Conceptual design focuses on what data to store and how entities relate, producing an ER diagram.
Three levels of database design:
- Conceptual — entities, attributes, relationships (ER diagram)
- Logical — tables, columns, keys, normalization (relational schema)
- Physical — data types, indexes, storage, partitioning (DBMS-specific)
Why not others:
- (a) Physical data model — belongs to the physical design phase
- (c) Exact data types — determined during logical/physical design, not conceptual
- (d) Security measures — separate concern, not part of structural design
Key rule: Conceptual design = high-level structure (ER model), no DBMS-specific details.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
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.