New answers tagged relations
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 ...
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 ...
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 ...
Top 50 recent answers are included
Related Tags
relations × 117database-design × 65
mysql × 24
relational-theory × 13
foreign-key × 12
postgresql × 11
sql-server × 10
join × 8
schema × 8
normalization × 8
primary-key × 5
many-to-many × 5
erd × 4
database-diagrams × 4
relational-algebra × 4
performance × 3
table × 3
best-practices × 3
dependencies × 3
mariadb × 2
ms-access × 2
json × 2
architecture × 2
terminology × 2
entity-framework × 2