Database Modelling concept

Data Modeling
Enthusiast

Database Modelling concept

Hello TD Gurus/Enthusiasts,

Can you share some insight on this and why?

 

“Which two statements are true? (choose two)
A. Dimensional models are process oriented
B. Relational models are process oriented
C. Dimensional models are enterprise oriented
D. Relational models are enterprise oriented
E. Fact tables contain only detail data
F. 3NF tables contain aggregated data”

 

-Regards

Siddarth

 

1 REPLY
Teradata Employee

Re: Database Modelling concept

A & D are TRUE Statements

Dimensional models are process oriented --> Dimension models help in measuring fact in different dimesions which are process oriented.

Relational models are enterprise oriented --> Relational model has characteristics of adoptability, extensibility and flexbility and hence close to Enterprise

 

--Meher