Data model for different grains of data

[Anonymous]

Hi All,

How to create data model for the below scenario

Table1: this has data month wise

cc	xlname	gcode	month	value	year
aa	dd	gf	jan	33	2016
aa	dd	gf	feb	44	2016
aa	dd	gf	apr	55	2016

  Table2: this contain data semester wise

cc	xlname	gcode	semester	value1
aa	dd	gf	1	100

  Master calendar:

month	sem	year
jan	1	2016
feb	1	2016
mar	1	2016
apr	1	2016
may	1	2016
jun	1	2016

  if i select month = jan , then this should be the output

output
cc	xlname	gcode	month	value	value1
aa	dd	gf	jan	33	100

[Anonymous]

any suggestions??