Back to feed
Renewal·서른의 생활코딩

Day 4) Relational Database Composition Examples 20180530 pm

NS
normalstory
cover image


Between entity and entity there exists a relationship entity.


The cardinality between entities can be 1:1, 1:many, or many:many,



When the cardinality between entities A and B is many:many, operations are not possible.

There is no fixed anchor, so the primary key becomes ambiguous and duplicates can arise.

Therefore the relationship entity between the two entities

converts its role into an intersection entity (or action entity).

This changes the structure A(many) -- (in between) relationship entity -- entity(B) many 

from A(many) :  entity, into

entity A(1_parent) : intersection entity(many_child) & intersection entity(many_child) : entity B(1_parent).

That is the new structure.






This English version was translated by Claude.

친절한 찰쓰씨
Written by
친절한 찰쓰씨

Pleasant Charles — UI/UX researcher at AIT. Keeping notes on design, planning, and slow days here since 2010.

More on the author's page

Keep reading

Renewal

Steadily, for the long haul, without burning out

Mar 31, 2026·9 min
Renewal

Tech-life balance

Feb 7, 2026·3 min
Renewal

Humanality, by Park Jeong-ryeol

Feb 7, 2026·11 min