The Database is a Fruit Bowl

The term “database” often sounds complex. In reality, while databases can be complex, the overall principle is simple: It’s a structured way to save data online.

Imagine you have several fruit bowls on a table, each bowl dedicated to a singular variety of fruit. In this analogy, the database is the collection of bowls. The bowls themselves are like tables – similar to an Excel spreadsheet. The fruits within each bowl is the data being saved.

You’re feeling hungry and want to eat apples. Let’s go through this step-by step. Find the bowl that has apples in it, unfortunately, it’s at the bottom amongst lemons, oranges and bananas, so you remove or push aside the other fruit before grabbing it.

The database is the fruit bowl. Now, how to identify good structure in a database. If you had 20 bowls with a mixture of fruit, finding the apple you want would be random. You’d have to look through each bowl in the hopes of finding the apple. What if each bowls was reserved for a single variety of fruit, for example a bowl just for apples. Consider there are different types of apples, such as Granny Smiths, Pink Ladies, Gala.

Should we separate them into different bowls even though they fell into the same variety of fruit? Also, consider each fruit's features:

• Used by date
• Size/shape
• Ripeness

In a supermarket, these details are on labels on the fruit or shelves. With a database, we call these attributes.

Database Structure and design are all about identifying what the end user is trying to find and making it as quick and simple as possible. Correctly separating your fruits and adding the right labels is key. This kind of behind-the-scenes structure is a core part of website development because it affects how well users can search, filter, and interact with a website.

If this is correctly done, we can provide dropdowns and searches to load only the relevant fruits. In our experience, what our clients don't grasp is that searches and filtering tools only work if their fruit (or products) are correctly labelled and in their dedicated bowls.

As websites grow, that structure also needs ongoing care. Products, pages, filters, and data can become harder to manage over time if they are not maintained properly, which is why website maintenance matters for keeping the website organised, usable, and scalable.