Differentiation between Dimensional Modeling and ER Modeling
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Expert
Dimensional modeling is extremely flexible for the user viewpoint. Dimensional data model is mapped for making schemas. Whereas, ER Model is not mapped for making schemas and doesn’t employ in conversion of normalization of data into demoralized forms.
ER Model is employed for OLTP databases which utilizes any of the first or second or third normal forms, where as dimensional data model is used for data warehousing and uses third normal form.
ER model holds normalized data whereas Dimensional model holds denormalized data.
Explain the connected and unconnected transformation?
Briefly describe EDW?
Write down the snapshot with reference to data warehouse?
What are the causes of Monopoly? Explain in brief.
Describe briefly the term recursive relationship? Comprise an appropriate example?
Explain and compare a procedure and a trigger?
What is Monopoly explain in brief?
Write down a short note on the difference between two and three-tier architectures?
What is the simplest sorting method to utilize in data structures?
Name the Applications of tree data-structure?
18,76,764
1925995 Asked
3,689
Active Tutors
1438609
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!