New answers tagged

1 vote
Accepted

How to automaticaly create entries in a parent table before filling child table? What is that called in db terminology?

What you describe is called "application logic"; none of the DBMSes I'm familiar with implement this "out of the box", obviously. I say "obviously", because many ...
user avatar
  • 22k
1 vote
Accepted

Database Design - Relationship between two or more junctions tables

Would this model work for you? If I'm understanding correctly, people are not associated with jobs or addresses directly. Rather, people are associated with pre-established pairings of jobs and ...
user avatar
0 votes

Database Design - Relationship between two or more junctions tables

One approach might include having a special HomeAddress instance corresponding to no address in particular. You would then make the Job to HomeAddress relationship mandatory (1..* instead of 0..*) and ...
user avatar
  • 22k

Top 50 recent answers are included