I need to make some database... and lets say there is a student table, and the student table has many columns, a lot of columns.... they are all unique to the primary key, so dont worry about the normal forms...
what I am in a doubt is: there is some data, that could be put in another table, but it should be a one-to-one relationship!
because, one student can have only one dossier (for instance: sign_up_date, student_status, etc)
so, my question is:
- should all the data be put into one table called students?
- or should I separate the data into two tables students and student_dossier? In this case, student_dossier *table should have one primary key named student_id, just like in *students table
I am a bit confused, so I hope you could help me to understand it... Thank you very much in advance