Technical

Create an Online Data Model in 4 Steps

by Shamal Jayawardhana
20 Sep 2022 Learn how to use four simple steps and a data modeling tool to create a database diagram online. Creating database diagrams (aka data modeling) is an essential part of modern database development projects. A good data model is to a database what a strong foundation is to a skyscraper. Due to the availability of modern data modeling tools, this has become a straightforward process. What Is Data Modeling? Data modeling is the process of identifying and graphically representing the data elements and entities along with their attributes, relationships, operations, etc.
Read more
Technical

Export SQL DDL From MySQL Workbench for Importing Into Vertabelo

by Dominika Florczykowska
6 Sep 2022 Do you have an existing database model you would like to work with in Vertabelo? If so, you've come to the right place! In this article, you learn how to export a DDL file from MySQL Workbench and import it into our modeling tool. We also take a look at other ways to import an existing database schema into Vertabelo and organize existing tables. How to Export a DDL File From MySQL Workbench First, let's see how to export an existing database.
Read more
Technical

The Ten Best Database Diagram Tools for SQL Server

by Jorge Sandoval
30 Aug 2022 Understand the best SQL Server modeling tools for your needs based on differences in features and the value for the money. In this article, we discuss ten database diagram tools for SQL Server. Creating robust database models is critical in ensuring the database meets the needs. Microsoft SQL Server, or SQL Server, is one of the most used proprietary relational databases. It supports various applications, business intelligence, and analytics in corporate IT environments.
Read more
Technical

A Database Design for User Profiles

by Radu Gheorghiu
23 Aug 2022 Almost all applications allow users to log in and create a customized profile. So when you build an application, you should spend some time thinking about where to store the data and how to design the user profile database. In this article, we’ll design an efficient database model for user profiles. In this article, we’ll take you step-by-step through a database model for storing user profile data. We’ll start with the thought process and lead you from formalizing the idea to the final data model.
Read more
Technical

How to Export an SQL DDL File From SQL Server Management Studio for Reverse Engineering

by Martyna Sławińska
16 Aug 2022 Keep your database secure and up to date by deconstructing your database to extract and update its design. In this article, we show you how to export an SQL DDL file from SQL Server Management Studio, that is, export your SQL Server database in the form of an SQL script, and import it into Vertabelo. Also, you'll learn about the Vertabelo Reverse Engineering tool to export your entire database into an XML file and import it into Vertabelo for further processing.
Read more
Technical

Database Design for a Learning Management System

by Gustavo du Mortier
13 Aug 2022 In this guide, you’ll find all the necessary steps to create the perfect database design for a learning management system. A database design for a learning management system must be able to gather and relate information about courses, course categories, students, course enrollments, teachers, classes, attendance, exams, and scores. Once you have this information in a database, you can use it to query relevant data and obtain all kinds of analytics, such as attendance rates per course and per teacher, pass rates, and score averages.
Read more
Technical

Best Database Modeling Tools for Redshift

by Shamal Jayawardhana
9 Aug 2022 Amazon Redshift has become one of the most popular Cloud databases. Which database diagram tools are the best for Redshift? Let's find out! Redshift is Amazon's Cloud-based database system. First announced in 2012, Redshift is a data warehouse product designed for analytical systems. It can handle huge volumes of data – up to 1 petabyte (1024 TB). It is considered a DaaS (Database as a Service) solution and is part of the Amazon Web Services (AWS) Cloud ecosystem.
Read more
Technical

How to Draw a Database Schema from Scratch

by Gustavo du Mortier
2 Aug 2022 “The discipline of writing something down is the first step toward making it happen”, said Lee Iacocca, the famous automobile executive. So if you want a thorough database schema, you should start by writing it down. Database designers can suffer from blank page syndrome – the problem writers have when they don’t know how to start a novel. But luckily, we designers can go down a more methodical path. Unlike writers, we don’t need to wait for a sudden inspiration to propel us forward.
Read more
Technical

Database Design for Online Survey Systems

by Lisandro Fernigrini
26 Jul 2022 In this article, we review the steps for creating a database design for an online survey system using Vertabelo Data Modeler. Learn how to create a logical database model, add all the entities and relationships required, and then transform it into a physical database model by generating the SQL scripts to implement it on your database of choice. This article explains the tasks to create a database model for an online survey system, step by step.
Read more
Technical

What Is the Best Online Database Diagram Tool?

by Gustavo du Mortier
19 Jul 2022 To choose the best data modeling tool, you must evaluate many features and programs. In this article, we‘ll compare the key offerings of several popular database modelers. Data modeling is all about documenting the information design underlying a software system. Data is modeled using a diagram with text and symbols that represent how the data should flow. (This is usually an entity-relationship diagram, or ERD.) The diagram can be used as a starting point for building a new database or for re-engineering an existing database.
Read more