Organizing an event is a lot of work! In this article, we examine the data model behind an event organization app.
Other than location, what’s it take to run a successful real estate business? We examine a data model to help real estate agencies stay organized.
What is MySQL partitioning? What kind of partition types are there? How do you know if this is something your database engine supports? In this article, we tell you what you need to know about partitioning in MySQL.
Being healthy and fit is a lifestyle, not a fad. People who realize the value of health make it a priority, keeping records of all their fitness-related facts. In this article, we’ll examine the design of the database behind a health and fitness application.
The first two articles in this series highlighted SQL Server’s ability to organize data into user-defined windows and its aggregate functions. Part 3 will focus on other methods of aggregating and organizing data using built-in SQL Server features – specifically, its grouping functions.
What kind of data model can handle all the planning and activities used in process management? In this article, we discuss one design for a process management database.
In this era of tough competition, job portals are not just platforms for publishing and finding jobs. They are leveraging advanced services and features to keep their customers engaged. Let’s dive into some advanced features and build a data model that can handle them.
Bus and train travel hubs are full of activity: the crowd, the rush, the lines, the race to the platform r a terminal. Clearly, such places require a lot of organization! In this article, we’ll describe a database model that could keep a transport hub organized.
What kind of database model does it take to run a gallery or museum? How can it be optimized to manage events, partnerships, and other activities?
In this article, I’ll walk you through some fundamental considerations for working with date- and time-related data in MySQL. We’ll also look at how to handle multiple time zones and daylight saving time changes.