Designing database architecture

<p>Sometimes people ask me to help them with database modeling. We go through what kind of data they need to store and how the tables should relate to each other.</p><p>If it's a Rails application, we usually switch to pair programming and create all necessary models with relationships and validations. To make sure everything works as expected, we&nbsp;fire up rails console and test it on dummy data.</p>