List of top Data Science and Artificial Intelligence Questions on Data Management

In a data warehouse, a 3D cube initially has dimensions: Product type, Month, and Country. After visualization, the dimension Country is refined into State. Which OLAP operation is performed?

Node size = 4096 B
Node pointer = 10 B
Search key = 11 B
Record pointer = 12 B
Find the maximum number of node pointers.

Consider the ER model:
E1 (A11, A12, A13)
E2 (A21, A22, A23)
Where:
- A21 is the key of E2
- A22 is a multivalued attribute
- R12 is a many-to-many relationship between E1 and E2
Find the minimum number of relations required to convert this ER model into tables.

Consider the relation \( R(A, B, C, D, E) \)
Functional Dependencies:
\[ A \rightarrow BC \] \[ CD \rightarrow E \] \[ E \rightarrow A \] Find the number of candidate keys.