Question

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

Answer 1

Answer:

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

c. normalization

Explanation:

• 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.