Design two different tables

I have designed the following but I am looking for a simpler way to design it (currently when I am going to retrieve list of subcategories that user is interested I should have different queries for each type of sport) :

User table has users info each user is interested in number of sport categories, each category has different subcategories, user can be interested in category (all subcategories) or just a number of subcategories of a particular category.

User      UserID                                         12

Sport     CategoryID Category                            1 Aquatic,    2 Running 

Aquatic   SubCategoryID SubCategory,CategoryID           1 Swimming 1, 2 Surfing 2 

Running   SubCateogryID SubCategory,CategoryID           1 200m 2,     2 300m 2 

LikeSport UserID CateogryID SubCategoryID                12 1 1,       12 2 nill

It shows user with ID 12 likes Aquatic sport but just Swimming and likes all type of Running Sports.

Answers


Users:                         UserID
Categories:                    CategoryID, CategoryName
Subcategories:                 SubcategoryID, SubcategoryName
CategoriesSubcategories:       CategorySubcategoryID, CategoryID, SubcategoryID
LikeSports:                    UserID, CategorySubcategoryID

user Table: userId,userName

category Table: categoryId, categoryName

subCategory Table: subCategoryId,subCategoryName,categoryId (FK)

like Table: userId(FK),categoryId(FK),subCategoryId(FK)


Need Your Help

Internet Explorer Error : SCRIPT5009: ArrayBuffer is undefined

javascript arrays internet-explorer browser

I am receiving an error in internet explorer 9 and under which does not occur on other browsers. It's:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.