I am trying to create a a asp.net(c#) dropdown menu that gets its results from a sqlsrrver Table. Basiclly its three dropdown menus, the user selects their reigion in the first one, this then searches the SQL table and finds the reigons, after the user has selected their reigon the second drop down box displays the Gardens/Shows based upon the first results, the third then shows the dates of that event based upon what Garden/Shows the user picks.

The problem is that I am not able to design the database for this problem.can someone guide me on how to design it?????