technical
Common ER Diagram Mistakes
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
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
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
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
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
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
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
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
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.
others
Using Python and MySQL in the ETL Process: Using Python and SQLAlchemy
26 Jun 2019
In the previous two articles of this series, we discussed how to use Python and SQLAlchemy to perform the ETL process. Today we’ll do the same, but this time using Python and SQL Alchemy without SQL commands in textual format. This will enable us to use SQLAlchemy regardless of the database engine we’re connected to. So, let’s start. Today we’ll discuss how to perform the ETL process using Python and SQLAlchemy.
