Database Design

Can anyone tell me how can i design database architecture for the Table Category & Product...so that i can make N-level entity relation...

I have database in SQL SERVER 2000.

CategoryId
CategoryName
ParentId

Here ParentId is CategoryId. for root category it is null

productId
ProductName
CategoryId

|||

Visit below thread.

http://forums.asp.net/t/1162732.aspx