How to normalize database with tree structure MYSQL

Asked Nov 03 '17 at 23:35

Active Nov 03 '17 at 23:35

Viewed 80 times

I want to organize my Mangas, each Manga will have many Chapters, each Chapter will have many pages, between 20 pages.

Tree : Mangas -> Chapters -> Pages.

I want to add the Manga, instead, add each Chapter with many Pages to the manga created.

How do you do that? How to normalize the database with tree structure?

asked Nov 03 '17 at 23:35

Braian Silva

What do you think is the answer? – Strawberry Nov 04 '17 at 00:02
Normalize? Parent to Child, Child to Child? – Braian Silva Nov 04 '17 at 00:12
Sounds like approximately the right idea – Strawberry Nov 04 '17 at 00:14
How would you solve this? Answer this thread to close it. – Braian Silva Nov 04 '17 at 17:03
If there are exactly 3 levels to this "tree", don't approach it as a tree, simply have 3 tables and 2 1:many relationships. – Rick James Nov 06 '17 at 20:14
It worked, thank you very much. – Braian Silva Nov 06 '17 at 23:35

0 Answers0