Vertabelo Database Modeler

technical

Common ER Diagram Mistakes

by Tihomir Babic

29 Jan 2020 Get to know the ER (Entity Relationship) diagram, its parts, and what often goes wrong when creating it. Have you ever created a relational database model? Or maybe you're trying to create your first one? You know (or you'll soon find out) that translating real-world problems to database logic can sometimes be quite difficult. One of the tools that might help you is the ER diagram. Common database design wisdom holds that the better your ER diagram, the easier it will be to build the database model.

technical

Integrated Transport Data Model

by Emil Drkušić

15 Jan 2020 Integrated transport is something we often hear about on the internet or in the news. While it’s not something new, it’s definitely an ongoing process, with constant changes being implemented. Today, we’ll take a look at a data model that could handle zone, passenger, and ticket info. Let’s dig right into our integrated transport data model, starting with the idea behind it all. Idea Integrating transportation is necessary to maximize its efficiency and, for customers, its easy use.

technical

Payroll Data Model

by Tihomir Babic

23 Dec 2019 A payroll data model allows you to easily calculate your employees’ salary. How does this model work? No matter whether you’re running a small or large company, you need some kind of payroll solution. That’s where a payroll application comes in handy. Plus, the bigger the company, the harder it gets to handle the employees' salary calculations; here, a payroll application becomes a necessity. To help you understand all the data required for such an application, we’ll walk you through a related data model.

technical

911/112: An Emergency Call Service Data Model

by Emil Drkušić

16 Dec 2019 Calling an emergency number like 911 or 112 is not something we’re looking forward to, but we’re glad to have it when we need it! On the other end of the line, it’s a stressful job, and there’s little room for mistakes. Everything needs to work perfectly. Today, we’ll take a look at the data model an emergency service could use to process and respond to incoming calls.

technical

A Public Opinion Agency Data Model

by Emil Drkušić

21 Nov 2019 How does all that public opinion data get stored? We check out an opinion poll data model. Everyone wants to know what the public thinks, from politicians and companies to individuals who want to know what others think on a certain topic. This kind of job is usually performed by agencies that specialize in that type of research. Today, we’ll take a look at a data model such an agency could use to store all relevant poll data, from questions and predefined answers to the actual feedback.

technical

Track Signals with a Signal Processing Data Model

by Emil Drkušić

6 Nov 2019 Cameras, revolving doors, elevators, temperature sensors, alarms – all of these devices produce a large number of interconnected signals that are related to events happening around us. Now imagine you’re the person who needs to track statuses, produce real-time reports, and make predictions based on all this signal data. To do this, you’d first need to store that data. A data model that supports such signal processing is the topic of today’s article.

technical

A Library Data Model

by Tihomir Babic

17 Sep 2019 What data model would allow you to comfortably search for books and borrow them in your local library? Have you ever gone to a library and borrowed a book? Maybe that seems old-fashioned in today's world of instant internet knowledge and e-books. But I'm sure there's still this analog part of you that still likes to smell, touch, and read books. Or maybe you were forced to use a library when you couldn't find something on the internet!

technical

A Database Model for a Hotel Reservation Booking App and Channel Manager

by Emil Drkušić

4 Sep 2019 Everybody books into a hotel at some point. In this article, we’ll look at a data model that could power a hotel reservations system and channel manager. Faster, cheaper transportation options allow us to travel across the world in a matter of hours. And people have more disposable income than ever before. Is it any surprise that tourism is growing rapidly? In addition to traditional hotel booking channels, we also have newer options – like Airbnb and Booking.

technical

A Data Model for Online Concert Ticket Sales

by Tihomir Babic

10 Jul 2019 What kind of data model makes online concert ticketing work? Have you ever been to a concert? I'm sure you have. And I bet you purchased your ticket online. Online shops let us buy tickets to concerts by our favorite artists without leaving our comfortable homes. We can find a venue or a location (even one that’s not near us), choose a seat, and get our tickets delivered instantly through email – or maybe we’ll wait several days and get the tickets delivered.