Online analytical processing (OLAP) is an information system that enables the user, while at a PC, to query the system, conduct an analysis, and so on.

Based on your expertise, perform the following OLAP operations on the given Toyota Corolla dataset in Table 1.

1. Slice
2. Dice
3. Pivot

ID	Model	Price	Mfg_ Date	KM	Type	KK/ HP	Color	CC
1	TOYOTA Corolla 2.0 D4D HATCHB TERRA	13500	10-02	46986	Diesel	90	Blue	2.0
2	TOYOTA Corolla 2.0 D4D 90 3DR TERRA	18600	03-02	75889	Diesel	90	Grey	2.0
3	TOYOTA Corolla 1800 T SPORT VVT I	21500	06-02	19700	Petrol	192	Red	1.8
4	TOYOTA Corolla 1.9 D HATCHB TERRA	12950	10-02	71138	Diesel	69	Blue	1.9
5	TOYOTA Corolla 1.8 VVTL-i T-Sport 3-Drs	20950	08-02	31461	Petrol	192	Silver	1.8
6	TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT	19950	11-02	43610	Petrol	192	Red	1.8
7	TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT	19600	08-02	32189	Petrol	192	Red	1.8
8	TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT	21500	02-02	23000	Petrol	192	Black	1.8
9	TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT	22500	01-02	34131	Petrol	192	Grey	1.8
10	TOYOTA Corolla 1.8 16V VVTLI 3DR T SPORT	22000	05-02	18739	Petrol	192	Grey	1.8

Answer rating: 100% (QA)

Toyota Corolla Dataset Slice Here are some examples of slice operations that can be performed on the Toyota Corolla dataset Slice by Model This will s... View the full answer