Q1 Compute draw a Data Cube with Employee attributes as IdN

Q1. Compute & draw a Data Cube with Employee attributes as Id-No, Name & Profession

Q3. Construct the inverted index. For each attribute value in each dimension, list the tuple identifiers (TIDs) of all the tuples that have that value.

The following denotes the world’s best cars:

KCT - Koenigsegg CCXR Trevita

LV - Lamborghini Veneno

LH - W Motors Lykan Hypersport

BV - Limited Edition Bugatti Veyron by Mansory Vivere

FPS - Ferrari Pininfarina Sergio

PH - Pagani Huayra BC

TID                     Items

1                       PH, FPS, BV,KCT

2                       LV, LH, FPS, PH

3                       FPS,KCT

4                       LV,LH, BV,PH

5                       PH, FPS, BV, LH,LV,KCT

6                       FPS 7 LV, LH, BV

8                       KCT , PH, BV, LH,LV, FPS

9                      PH, KCT

10                    KCT

Solution

A database is an organized collection of data.^[1] It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a