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"