This is personal study note
Copyright and original reference:
https://www.youtube.com/watch?v=hbZ96tnbN4M&list=PLuHgQVnccGMDF6rHsY9qMuJMd295Yk4sa
================================================================================
conceptually model above real world project
Following 2 ways are valid to represent above project
But second one is more valid for RDB
================================================================================
To resolve above issue, you can try to create large table
But large single table causes "duplications"
================================================================================
Better modeling for RDB
================================================================================
relationships
Advantages:
- you can group data with respect to topic
- If you would like to query data about "text", you can search only "text table"
- You can use "join" when you query "text" along with "author information"