When it comes to taking the right approach for your data structure, it’s a hard question to answer when you ask “Is this the right way?”. This is because the answer to that question is typically, “Well, it depends.” There are bad ways of structuring data and there are good ways. But the good vs. bad doesn’t really come into play until you’ve decided how you want to apply a general structure. You see, it all comes down to how the data is going to be used. It’s possible to keep all data within one table and have a “flat” structure and it’s also possible to “normalize” the data to such a degree that it’s a nightmare to manage. In this lesson, we’ll look at how to approach your data structure by asking the right questions about what you want to do with it.
Link to the file if you’d like to follow along.