Are u familiar with the 'e-commerce book'. if u are , i ahev a question about product database.

My question is about RelatedProducts. If product1 is related to product2, does it also mean that product2 is related to product1.

If this is true, should we also include product2 in the RelatedProducts table, like:
ProductId: product2, RelatedProductId:product1, RelationType:3

Or is there any other way to tell teh system that product2 is somehow rlated to product1.

Hope u understand it.

This forum is for the book "ASP.NET Website Programming Prob-Design-Solution".

Eric

You have a good sense of humor. Yes, I know it. But I dont think there is 'E-commerce programming' book forum on p2p. thats why i have posted the question here. I thought if u r familiar with 'ASP.NET Website Programming ' book, u may also be familiar with the e-commerce book.
regards

I thought they had a separate forum for that book. I'm not familiar with it myself, but maybe someone can help you.

Eric