What type of data model has the analyst just built?

An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types.

What type of data model has the analyst just built?
A . Physical
B . Hierarchical
C . Conceptual
D . Logical

View Answer

Answer: A

Explanation:

A physical data model is the most detailed and specific type of data model, which shows how the data is stored, accessed, and manipulated in the database. It includes the table structures, column names, data types, primary and foreign keys, constraints, indexes, and other physical attributes of the data12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 542: Data Modeling Essentials, Graeme Simsion and Graham Witt, 2005, p. 15.