Features
Pricing
Academy
Learn SQL
Log in
Sign up
MENU
CLOSE
Home
Features
Pricing
Academy
Learn SQL
Log in
Sign up
All Articles
Design Fundamentals
Design Patterns
Example Models
Database Internals
SQL
Others
example_models
A Marathon Training App Data Model
by Vertabelo Team
29 Aug 2018
Do you dream of running a marathon? Let’s look at the data model for an app that could take you from lazy couch potato to marathoner.What do you need to run a marathon? You’ll need enthusiasm and determination. A good pair of running shoes. And lots of physical training! Let’s say you have an app that helps you go from novice runner to marathon finisher. What would the data model look like?
Read more
example_models
The Secrets of Dominoes, or A Domino Game Data Model
by Vertabelo Team
2 Aug 2018
Board games like dominoes are still very popular. Let’s take a look at dominoes from a data modeling point of view.The game of dominoes has been around for hundreds of years, and it’s played all over the world. As you might expect, this means a lot of variations in play! In this article, we’re going to examine a data model that could support the most common variants – draw and block. The basics of these two variants are almost the same; there’s just slight differences in rules. Dominoes can be played by two or more players, so our data model will support multiple players.
Read more
example_models
Earn Money with Unused Stuff: A Sharing Economy Data Model
by Emil Drkušić
13 Jun 2018
There isn’t much chance you’ve missed the whole idea of the sharing economy – whether you like it or not. Popularized by companies like Airbnb, Uber, Lyft, and many others, it lets people earn some cash by renting out their unused stuff. Let’s see the data model behind such an application.Got a spare room? Sign up with Airbnb and make some extra money renting it out. Got a car and some free time? Become an Uber driver. And so it goes – the idea behind these companies and many more like them is almost the same. It’s all about sharing a resource with (mostly) strangers, with a perk for both parties. The owner gets money for their unused property, while the customer usually gets a good deal; this should be a win-win situation.
Read more
example_models
A Grocery Delivery Data Model
by Emil Drkušić
21 May 2018
If there’s a way to order groceries online, why not use it? This article examines the data model behind a grocery store’s delivery system.We still get a special feeling from picking something from the garden and then preparing it right away – but it’s not something we can do often. Today’s fast pace doesn’t allow it. In fact, sometimes it doesn’t even allow us to go to the store to “pick” our groceries. So it makes sense to save ourselves some time and use an app to order what we need. Our order will just show up at our home. Maybe we won’t get that special fresh-picked feeling, but there will be food on our table.
Read more
example_models
A Data Model for Map- and Turn-Based Games
by Emil Drkušić
18 Apr 2018
Turn-based games and their map-based counterparts have been popular for a long time. Suppose we were to take such games into the 21st century by making them digital. What data model is up to the job?If you think about it, many popular games have been map-based, turn-based, or both. On the one hand, we have simple low-tech board games likeDon’t Get AngryandMonopoly; the other end of the spectrum includes the computer-based
Read more
example_models
Tap and Park: A Parking App Data Model
by Vertabelo Team
5 Apr 2018
Various apps promise to make your search for parking painless. Let’s examine this type of app using our data modeling glasses. What does the underlying model look like?In an earlier article , we explained how a parking lot is structured and how a data model can be designed to manage one. In this article, we are examining the data model for a parking app. You know these apps: they list nearby parking options, tell you the prices, and let you book or reserve a space or buy a parking pass.
Read more
example_models
A Children’s Party Data Model
by Emil Drkušić
29 Mar 2018
Organizing children’s parties is not an easy job: everything has to be perfectly planned and delivered. Otherwise, chaos happens. It’s up to the adults – more specifically, the party planners – to take care of everything and do it properly.Is there a better way to do this than to organize everything in a database? We don’t think so!Children’s parties vary a lot. Some are simple, like birthday parties that include just invitations, food (snacks, beverages, and a cake) and maybe a clown or a magician to entertain the kids. Other parties are much more complex. They may require a trip out of town, sleeping accommodations, and many other activities. The more complicated the party, the less room for mistakes. While a clown that’s 10 minutes late isn’t a big deal, no one wants to wait with a group of bored kids for a bus that’s two hours late!
Read more
example_models
A Restaurant Delivery Data Model
by Emil Drkušić
1 Mar 2018
Hungry but you don’t want to cook? Call up a restaurant, order your favorite meal, and read about a data model that can organize the whole process.Despite an abundance of “time-saving” technology, we seem to have less time to fulfill basic needs – such as eating. If we want to eat something but we don’t have the time (or the skills) to cook it ourselves, we can order food from a restaurant (i.e. a takeaway or takeout), which will bring our meals right to our doors. Of course, we have to pay for this convenience, so we expect the food to be good and hot!
Read more
example_models
A Dating App Data Model
by Emil Drkušić
14 Feb 2018
It’s Valentine’s Day and you’re single. Again. Not cool. Not cool at all. We’ll do something about that with today’s dating app data model. Ok, reading this article won’t automatically get you a date. Or maybe it will. Let’s see.How many dating apps can you name? I can think of at least a dozen. As data modelers, though, we’re more interested in the data model underneath the app than the app itself. So let’s examine what it takes to run a data app, starting with what we need it to do.
Read more
example_models
A Data Model for a Weather App
by Vertabelo Team
31 Jan 2018
Lots of people use mobile weather apps to plan their day – or at least decide if they need to carry an umbrella! What sort of data model lies underneath these popular programs?We all want to know how nasty the weather is before we step outside. Windows, iOS, and Android apps give us accurate and reliable information about current weather conditions. This article explains a detailed data model that could be used for such apps.
Read more
««
«
1
2
3
…
11
»
»»