After de-normalization, your Time table will look like this:
Field Name | Type |
Dim_Id | INTEGER (4) |
Month | SMALL INTEGER (2) |
Month_Name | VARCHAR (3) |
Quarter | SMALL INTEGER (4) |
Quarter_Name | VARCHAR (2) |
Year | SMALL INTEGER (2) |
The actual data in your Time Table may will look like this:
TM _Dim_Id | TM _Month | TM _Month_Name | TM _Quarter | TM _Quarter_Name | TM_Year |
1001 | 1 | Jan | 1 | Q1 | 2003 |
1002 | 2 | Feb | 1 | Q1 | 2003 |
1003 | 3 | Mar | 1 | Q1 | 2003 |
1004 | 4 | Apr | 2 | Q2 | 2003 |
1005 | 5 | May | 2 | Q2 | 2003 |