Vertabelo Blog

Learn how to design and use database models
New SQL Course! Learn how to process trees and graphs in SQL, and how to effectively organize long SQL queries. View course Discover our other courses:
Emil Drkušić 20th Sep 2017

No matter what you collect, you need to be able to organize (and trade, and swap) it! We look at a data model for collectors.

Marian Dziubiak 13th Sep 2017

Team sports are very popular, especially among kids and teens. In this article, we look at a data model that can help run a sports school.

Emil Drkušić 6th Sep 2017

No plot spoilers – just a data model based on the Game of Thrones TV series.

Vertabelo Team 30th Aug 2017

Bidding sites are a popular way to buy and sell many products. In this post, we look at these online auctions from a buyer’s perspective. What does our data model need to handle the bidding process?

Emil Drkušić 23rd Aug 2017

What goes into marketing a business? And what data model could a marketing agency use to run their organization? Read this article to find out!

Emil Drkušić 9th Aug 2017

In the first two parts of this series we have installed SuiteCRM locally, imported its model into the Vertabelo database, and created relationships based on assumptions. In Part 3 we took a closer look at the most important parts of the CRM, how to use them, and how the data is stored in the database. This article will continue where Part 3 ended and will close the series. We’ll take a closer look to other modules of SuiteCRM including campaigns, opportunities, projects, documents and users, and roles administration.

Emil Drkušić 4th Aug 2017

Visiting a hospital or a clinic is never a pleasant situation. But it would be even worse if nothing was automated. Not so long time ago almost all documents were in a paper form. That not only polluted the environment but slowed down a process a lot. In some cases, patients should take care of their medical record as well wait in the hall that somebody calls for their name. Fortunately for us, the development of the technology also had a significant impact in this area. Today we’ll take a look at the data model we could use to run one such system.

Emil Drkušić 27th Jul 2017

City-building and management games have been very popular for decades. If you were to build your own city management game, what kind of data model would you need to run it? Let’s find out.

Dorota Wdzięczna 19th Jul 2017

Knowing a foreign language is an important skill, especially in a global economy. In this article, we look at a data model that can help run a language school.

Emil Drkušić 28th Jun 2017

Shopping centers are fun to visit and complicated to run. In this article, we look at a data model capable of helping us manage a shopping center.