Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
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:
 
Vertabelo Team 18th Oct 2017

Using a mobile app to hire builders, landscapers, and other skilled professionals makes taking care of property less of a hassle. In this article, we look at a data model to support such an app.

 
Emil Drkušić 11th Oct 2017

Pet care is a huge industry. Is there a data model that can help pet owners and professionals manage their activities? There is now!

 
Emil Drkušić 4th Oct 2017

In order to optimize the value of any website, information about the number of site visitors and their user behaviors is needed. There are a few tools which, with just a few minor changes to your site, will actually do this work for you, the most popular such tool is Google Analytics. While this article will not help you install and use Google Analytics, its goal is to help you understand the data model that may lie behind it --So, let’s get going!

 
Vertabelo Team 27th Sep 2017

Most of us are familiar with the apartment rental process. But what does it take to run a leasing office? In this article, we look at a data model designed to do just that.

 
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.