We're not kidding about powerful.
A relational data structure has several advantages:
- It lets you answer important business questions, such as who bought the most (or least) of your product last week. The figure above shows you how this can work.
- What's more, using separate tables can make your data easier to manage, because each table holds just part of your information.
- And finally, a relational structure helps keep your information accurate, because you can prevent users from entering data in the wrong table.