swaybright
Technical User
I wanted to get people's perspective on the issue of when to use a one-to-one relationship between two tables and when to make a single table.
For example, I am in the middle of designing a db; I have a table (tblResults) that stores experimental results on a particular material. One set of experiments are done all the time and so the resulting data is in the table.
Another set of experiments are done rarely. Should I put these results in tblResults or create a new table?
If anyone has some practical guidelines on the basic issue, Please post.
Thanks,
Shane
For example, I am in the middle of designing a db; I have a table (tblResults) that stores experimental results on a particular material. One set of experiments are done all the time and so the resulting data is in the table.
Another set of experiments are done rarely. Should I put these results in tblResults or create a new table?
If anyone has some practical guidelines on the basic issue, Please post.
Thanks,
Shane