in sql for course storage data of mangment

Q.creat tables then fill , relationships also do its Index and Cube

// pls screenshot output

A Retail Dimensional Model Ret Calendar PK ti me period id day number Mall shot Campaign hour number PK mailshot id day date product category code malahot name malahot 8tart dates maishot end date mailshat target ulation Retail Dimensional Model maishot objectives other malahot detalla PK fact Udl invoice status code Products in Warehouses FK product id FK promotioLid PF product Id FK payment method code FAX warehouse id FR slam id parent product. d er FAT store id product name product price totals product calo averages, counts, balas product size her figures product description other product datala Ref Invoice Status Codes Product Promotion PK invoice status code PK Promotio invoice Btatue deecnpton promotion start date promotion end date promotion name promotion description other promotion details Data Base Answers Ltd. 2013 Statt PK staff id FK job id FK reporta to atar FAT store id staff name staff address other staff details Stores PK store id store name store adress other stone details. Ref Payment Methods Ph payment method code payment method description