Is it need to keep calendar separate if so can you please suggest in which scenario's we need to keep calendar separate and in which scenario there is no need to do so.
It is not mandatory to keep the Calendar as a separate table. Suppose for example if your data is not having transactions for some dates assume that Mar month do not have transactions, but if you want to show the March month in the Month field then you need to go for Master Calendar as a separate table. In Master Calendar you have all the dates from Start to End date even if you have transactions or not.
.png "Luminary Alumni"){kind=icon}
