By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,376 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,376 IT Pros & Developers. It's quick & easy.

Should I use a one-to-one relationship

Seth Schrock
Expert 2.5K+
P: 2,951
I'm in the middle of planning a database that will track both students, prospective students and alumni. Obviously there is a lot of fields that would be the same between them, but more information would be gathered for students than for prospective students and then a few more fields for alumni. I know that I would have them all in the same table, but my question is how to handle the extra fields for for each type of contact. Do I have a basic contacts table with the fields that are duplicate and then have another table for the fields that only students would have and create a one-to-one relationship between the tables, or should have all the fields in one table and just hide the fields that don't apply?
Mar 9 '15 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,768
Either can work Seth, but unless the numbers of fields are really unwieldy I'd stick with the simpler approach of including all the fields in a single table and simply using only the ones that are relevant.

For most situations though, both can work perfectly well.
Mar 10 '15 #2

Seth Schrock
Expert 2.5K+
P: 2,951
Well, at the moment I'm not sure how many fields there will be because I'm having to normalize the database. Currently they have Child1 through Child7 names and birthdays so that will eliminate several of the fields just because there won't be related records in other tables. Right now I would guess between 10 and 20 extra fields, but I could be wrong.
Mar 10 '15 #3

NeoPa
Expert Mod 15k+
P: 31,768
So, they'll fit in a single table and you can choose to, or not to, use them depending on the circumstances. Unused fields take up very little space in a record.
Mar 10 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.