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.
Write down a short note on the Volatile Temporary tables (VTT).
Illustrates the term data structure?
Describe the differences between an extranet and an intranet.
Describe why stored procedures decreased network traffic.
Consider a MOVIEdatabase in which data is recorded about the movie industry. The data requirement an u will given me this solution
Illustrates the Pointer a variable in data structure or not?
Specify the various types of Aggregation?
Explain the term Account and Directory options?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Explain the term Chasm trap?
18,76,764
1926762 Asked
3,689
Active Tutors
1448061
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!