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.
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Illustrates the types of Data Independence?
Describe the three types of data sources which are used with ODBC?
Briefly describe snow flake system design in database?
Explain briefly the term an outer join?
Explain what needs to happen to convert a relation to third normal form?
Explain, what are Dimensional table?
Explain Data Page Locking in Sybase.
Specify the designer tools used for creating the tranformations?
Describe the difference between differential backups and SQL Server 2000 complete?
18,76,764
1939724 Asked
3,689
Active Tutors
1418904
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!