Recent content by Mr. Nice Guy

I have a Test request table, a Customer table, a Platform table (which is like a research program), and a Part Table (as well as a few others which were left out for simplicity's sake). here is how the relationships should work: One Customer can have many test requests, however each test...

In my diagram I didn't make a relationship with the durabilities because I didn't know which field to relate or how to make a unique key. As for the whole "relationships" window, I can see where you're coming from. As the database gets more complicated, it seems better to just join all the...

Thanks a lot for all the help, I'm starting to get the hang of it i think, and the joins are making sense now... I've attached a picture of my design if you would like to see it. My main focus is in the top right corner with the Tests and subtests. The Tests will work very nicely for my...

So I should Relate the Parent Request table to 3 child Test tables? I didn't know if I should join more than one child to a parent. I also am a little confused about all the different join types, and when to use them. Just to clarify, I should not join the tables in the "Relationships"...

Hi everybody, I've new to databases, so I'm having a little trouble determining how i should set up my design, and would really appreciate the perspective of someone who is experienced (since it would probably be quite easy for them). first some background, my database is basically built to...