COURSE: DATABSE ENGINEERING

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