we recommend to have a quick entry into the topic iteself:
with these concepts it should be possible to find a good strategy on the datadesign and balancing redundancies and table splits.
Once the datamodelling is done, than you can map it to code. from the technicals /options still we recommend to have a closer look on:
-
data joins
Story line of Join Data Table