I am working on a sport site, where i have to create a Calender Likething where i have to show which sport is avaible in which month,we can have any numbers of sports as the club grow it can add 100s ofdifferent sport to itself, so i was not able to understand how to makea database for this kind of thing, can anyone please help
Games - Jan Feb Mar Apr May Jun Jul …..Dec
Cricket Yes Yes Yes No No No No ....
Hockey No Yes Yes No No Yes Yes ....
Horse R Yes No No No Yes Yes Yes ....
Thanks in Advance
Regards
Viking
you can try this structure...
Tbl_Sport
Sports_ID(Unique Key , Auto Incremented)
MonthsChar(10)
SportsVarChar(30)
AvailbilityBinary
No comments:
Post a Comment