COURSE: DATABASE ENGINEERING

i) State the fact and dimension tables.

ii) Explain the suitable ROLAP model to represent the multidimensional data warehouse model for Blue Pink Centre.

iii) Draw the ROLAP model that you have suggested in (ii).

b) Study the following data warehouse schema for Blue Pink Centre. \begin{tabular}{l|l|} \hline RETAILER & (RETAILERID, RETAILERNAME, RETAIERPHONE, RETAILERCITY) \\ \hline CLIENT & (CLIENTID, CLIENTNAME, CLIENTPHONE, CLIENTADDRESS) \\ \hline SALES & (SALESID, QUANTITY, CLIENTID, STAFFID, PRODID) \\ \hdashline STAFF & (STAFFID, STAFFNAME, STAFFPHONE, STAFFADDRESS) \\ \hdashline PRODUCT & (PRODID, PRODNAME, PRODPRICE, RETAILERID) \end{tabular} Answer the following questions. b) Study the following data warehouse schema for Blue Pink Centre. \begin{tabular}{l|l|} \hline RETAILER & (RETAILERID, RETAILERNAME, RETAIERPHONE, RETAILERCITY) \\ \hline CLIENT & (CLIENTID, CLIENTNAME, CLIENTPHONE, CLIENTADDRESS) \\ \hline SALES & (SALESID, QUANTITY, CLIENTID, STAFFID, PRODID) \\ \hdashline STAFF & (STAFFID, STAFFNAME, STAFFPHONE, STAFFADDRESS) \\ \hdashline PRODUCT & (PRODID, PRODNAME, PRODPRICE, RETAILERID) \end{tabular} Answer the following questions