Sawaal
  • Home/
  • Searching for Modeling

 Searching for "Modeling"

Q:

Difference between ER Modeling and Dimensional Modeling.

Answer

Dimensional modelling is very flexible for the user perspective. Dimensional data model is mapped for creating schemas. Where as ER Model is not mapped for creating shemas and does not use in conversion of normalization of data into denormalized form.


ER Model is utilized for OLTP databases that uses any of the 1st or 2nd or 3rd normal forms, where as dimensional data model is used for data warehousing and uses 3rd normal form.


ER model contains normalized data where as Dimensional model contains denormalized data.

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing

Q:

What is Dimensional Modeling?

Answer

Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing

Q:

The benefits of object-oriented modeling are which of the following?

A) The ability to tackle more challenging problems B) Reusability of analysis, design, and programming results
C) Improved communication between users, analysts, etc. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 In enterprise data modeling, which is incorrect?

A) You review current systems. B) You implement the new database.
C) You describe the data needed at a very high level of abstraction. D) You plan one or more database development projects.
 
Answer & Explanation Answer: B) You implement the new database.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database