Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Four queries and some in-app iteration on collections (joins). At my current job, we have a monolith of similar size/complexity that sits on top of a relational database. The DAOs are somewhat 1:1 ...

Introduce the concepts about relational models. Train students on how to convert a conceptual entity relationship model to a relational model. Introduce students with the reasons and process of ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...

Just as it is wise to design a house before building one, it's also prudent to plan your business database before putting it on your website. Databases can appear deceptively simple and cause you to ...

At its heart, data modeling is about understanding how data flows through a system. Just as a map can help us understand a city’s layout, data modeling can help us understand the complexities of a ...