Is this possible with SQL Server?

[Worf]

Hi.

I want to creat a database with catagories and sub-Catagories and want to know if it is possible to do the following?

I'll try and explain what i want to do the best i can.

In my database i want catagories and sub-catagories.

Lets say the user added a catagory called 'Electrical' and a sub-catagory called 'Fan' another catagory call 'Vegitation' and a sub-catagory called 'Bushes'.

Anything to do with 'Electrical'- 'Fan' goes under this and anything to do with 'Vegitation' 'Bushes' goes under this.

So i would end up with something like this?

Catagory: Sub-Catagory: Information:
Electrical - Fan Fan information
Electrical - Kettle Kettle info

Vegitation - Bushes Bushes info
Vegitation - Trees Tree info

So if i want to store anything Electrical will go under Electrical and any thing to do with Vegitation will go under Vegitation. ect, ect.

I am using VB.Net 2012 and have created my table.

Many thanks for you help.

Regards

Worf