The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.a. star schema b. multidimensional schema c. normalization d. denormalization

The OLAP systems are those type of software that are used to analyse the data stored in a database. OLAP stands for online analytical processing. This software allows the user to analyse different data like demographic data etc.
The reliance on normalization as the design methodology for relational databases is seen as stumbling block to its use in OLAP systems because in operations like creating, retrieving, updating or deleting of data, the de-normalization structure is preferred instead of normalization as we can avoid the data duplication as well as to increase the speed of processing.

jayilych4real jayilych4real · Answer 2 · 2021-11-25T12:55:43+01:00

The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems

C. normalization

According to the given question, we are asked to show the thing which a reliance of in the design methodology for relational databases which is seen as a stumbling block to its use in OLAP systems

As a result of this, we can see that the thing which would be regarded as a stumbling block to its use in OLAP systems for relational databases would be normalization because when there is a reliance on this can cause data duplication during processes of creating, retrieving and updating the database.

The correct answer is option C