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 a short note on the Volatile Temporary tables (VTT).
Write down a short note on the difference between two and three-tier architectures?
Illustrate the term multimedia data mining in short.
Explain the Aggregator Transformation?
Specify the types of connections we use while connecting with the database?
What is meant by the term merge?
When is a functional dependency F considers as to be minimal?
What is meant by the Cardinality?What is meant by the Cardinality?
Is it possible that Table Partitioning Require User-Defined Segments in the Sybase?
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
18,76,764
1932240 Asked
3,689
Active Tutors
1445300
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!