Author: Vertabelo Team

A Data Model for a Weather App

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.

Constructing a Data Model for a Parking Lot Management System

Research shows that cars remain parked for 95% of their lifetime, suggesting that parking lot management systems should be smart, efficient, and robust. In this article, we’ll construct a data model for such a system. Introduction Before we begin constructing our data model, we should first understand how parking lots are structured and how they operate. Let’s take a brief look at these two key areas. How are parking lots structured?

Modeling an Open Marketplace for Education

Keeping up with the latest changes in technology is necessary if you want to get ahead in today’s competitive job market. In this article, we’ll build a data model for online portals that offer a more engaging platform for learning new skills, using Native Monks as our guide. Introduction In one of our recent articles, we built a working data model for an e-learning portal, and we explained how courses can be split into recorded/transcript lessons and made available to students.

Data Model Design: A Mobile App Marketplace for Local Services

Using a mobile app to hire builders, landscapers, and other skilled professionals makes taking care of property less of a hassle. In this article, we look at a data model to support such an app. Is it easy for you to hire a plumber, handyman, or electrician? Most people would say no! That’s why there are several apps and services that match service professionals with buyers. These apps are based on a simple, one-platform concept.

A Data Model for a Leasing Office

Most of us are familiar with the apartment rental process. But what does it take to run a leasing office? In this article, we look at a data model designed to do just that. Earlier, we explained a data model for a website that lists residential rental units like apartments. In many countries, apartments are managed by a leasing company. This company handles the entire rental experience, from processing the initial renter application to performing maintenance work on the property.

An Online Auction Data Model

Bidding sites are a popular way to buy and sell many products. In this post, we look at these online auctions from a buyer’s perspective. What does our data model need to handle the bidding process? There are many online auction sites (eBay, eBid, Webstore, Bonanza, etc.) where one can buy jewelry, clothing, electronics, and a lot more. How these sites work is simple: an item is listed, people bid on it, and the highest bidder wins the item, often at quite a discount.

Hot: Vertabelo Now Features Migration Script Generation

The long-awaited generation of SQL migration scripts is now a part of Vertabelo! You can use these scripts to easily move from one database model version to another. Read this article to learn more. What are SQL Migration Scripts? An SQL migration script is a script that alters an existing database structure: it can add or drop a table, rename columns, or change column types. A migration script can change a given database from one schema version to another – hence its name.

Generate Your Model Documentation with Vertabelo

Vertabelo has a great new feature: a model documentation auto-generator. You can now create and export documentation for your current model with just a few clicks. Vertabelo has a great new feature: a model documentation auto-generator. You can now create and export documentation for your current model with just a few clicks. Think of how a complex model looks: multiple tables and tens or hundreds of columns where you can easily get lost.

Tip #24 – How to name a version of the model

Vertabelo offers you a feature to assign tags to particular versions of your model. It may be used, for example, to match the versions of your database model with the versions of your application. To assign a tag to the current version of the model, click Set tag in the options menu: Enter a tag name and click Set tag. Now, this version is tagged.

Tip #23 – How to create a reference to an alternate key

Sometimes, you want the reference between two tables to reference an alternate key and not the primary key. Here's how you can do it in Vertabelo. In this example, we want to model cars and their owners using owner and car tables. The car table has an alternate key consisting of the vin column: We want the owner table to refer to the car table, but using the car table’s alternate key.