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

www$.$dumpsplanet.com

Exam Dumps $2/104$

B$.$ Hierarchical

C$.$ Conceptual

D$.$ Logical

Explanation:

Answer:

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 data$12.$ Reference: $1$: Guide to Business Data Analytics, IIBA, $2020,$ p$.542$: Data Modeling

Essentials, Graeme Simsion and Graham Witt, $2005,$ p$.15.$