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

Why You Should Use .html Instead of .md Seeing Is Believing

Jul 25, 2026·1 min
Renewal

The Most Important Thing About AX

Jul 17, 2026·2 min
Renewal

디지털 기술과 혁신에 대한 논고(지탱하는 힘)

Jul 17, 2026·5 min