lwhite
03 Jun 2011, 08:56 AM
I am constructing a task management application and need some advice on how to structure my databases & tables. I have a few different options in mind, but am looking for the most proper, efficient solution:
1. The application allows each user to store a personal (private) to-do list. Should everyone’s tasks be stored in one table, or should each user have their own table with their own task items?
2. Similar to the above question: If users in an online store had the ability to create a list of personal “favorites”... I understand it would be a simple relational database, but should all the relationships for all the users & products reside in one table? Or should each user, once again, have their own table for their own favorites?
Any advice on this matter would be greatly appreciated!
Thanks,
Logan
1. The application allows each user to store a personal (private) to-do list. Should everyone’s tasks be stored in one table, or should each user have their own table with their own task items?
2. Similar to the above question: If users in an online store had the ability to create a list of personal “favorites”... I understand it would be a simple relational database, but should all the relationships for all the users & products reside in one table? Or should each user, once again, have their own table for their own favorites?
Any advice on this matter would be greatly appreciated!
Thanks,
Logan