Posts by
Redgate Data Modeler
Get to know the ER (Entity Relationship) diagram, its parts, and what often goes wrong when creating it. Read more
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. Read more
A payroll data model allows you to easily calculate your employees’ salary. How does this model work? Read more
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. Read more
How does all that public opinion data get stored? We check out an opinion poll data model. Read more
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... Read more
What data model would allow you to comfortably search for books and borrow them in your local library? Read more
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. Read more
What kind of data model makes online concert ticketing work? Read more
Do you want to learn how to design a database system and map a business process to a data model? Then this post is for you. Read more