I am creating a web site that will be used by a group of students. Hopefully, eventually, a very large number of students. Basically, they will be creating notes in this database. Each user will have his own set of subjects, topics, and notes. An amount of 10 to 100 notes in each topic and several topics in each subject. I had first thought after creating the users subject list, each subject would have it's on table of topics, and each topic would have its own table of notes. So, each topic table would have the name "username_subject_topic".
Would I be better off having one table with columns of "subject" and "topic" and just sort them out as they use them? They would only be pulling up one topic at a time. Not sure they all needed to be in the same table. But, I also hate having that many tables.
Not sure if I have given enough into or not. Please advise.
Would I be better off having one table with columns of "subject" and "topic" and just sort them out as they use them? They would only be pulling up one topic at a time. Not sure they all needed to be in the same table. But, I also hate having that many tables.
Not sure if I have given enough into or not. Please advise.