KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
suppose i have a entity called USER and a relationship FRIENDSHIP exist between two USERs SO for that i have a table 'USER' and a relationship table 'FRIENDSHIP' USER id firstName LastName 1 taher chhabrawala 2 john Dsouza 3 rahul singh 4 deepak patel Friendship id id 1 2 1 3 1 4 4 1 4 3 In the above table i am storing the same information twice i.e "taher is a friend of deepak and deepak is a friend of taher" Is there any way to reduce this redundancy ?
Tags (comma-separated)
Save Edits
Cancel