ER Modeling and Dimensional Modeling
Specify the difference between the ER Modeling and Dimensional Modeling?
Expert
a) ER Modeling is used in order to normalize the OLTP database design.
b) Dimesional modeling is used in order to de-normalize the ROLAP / MOLAP design.
Write down the steps for transforming an entity into a table?
Explain the power center repository?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Explain the stage variables?
Give a brief introduction of the term critical column?
Briefly describe the foreign key columns in dimension table and fact table?
Write down the purpose of Fact-less Fact Table?
List out the various detected patterns.
What is meant by the term Context?
States the term second normal form?
18,76,764
1956006 Asked
3,689
Active Tutors
1457470
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!