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.
Illustrates the two tasks to be assigned to similar partition in Sybase?
Explain the master/detail reports?
Describe the meaning of each of the transaction stages supported by SQL Server?
What do you understand by the term Relationships in DBMS?
Illustrates the System R and its major subsystems?
Explain difference types of the stages?
List out the various detected patterns.
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
What is the main dissimilarity between horizontal and vertical partitioning?
State the difference between OLTP and OLAP?
18,76,764
1951756 Asked
3,689
Active Tutors
1419092
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!