Author: Lisandro Fernigrini
Lisandro is a Database Architect from Rosario, Argentina. With almost 20 years of experience in Oracle and SQL Server, among other database engines, he currently works as Sr. Data Engineer on OZ Digital Consulting. He is also a member of both the Oracle ACE program and the Argentina Oracle User Group. In his free time, he enjoys watching his soccer team (Rosario Central) with his two sons.
Database Design for Security: Best Practices to Keep Sensitive Information Safe
Keeping data safe and secure is a top priority for database designers and administrators. Learn how to design a database for security in this article.
When designing a database, security should be one of the top aspects to be considered. Databases store sensitive and valuable information, making them an attractive target for malicious actors. Protecting the data and ensuring its integrity and confidentiality are some of the most critical aspects when designing and implementing a database.
The Top 6 Database Design Tools for 2024
Do your plans for 2024 include data modeling or database design? Then check out our list of the top database design tools for 2024!
When choosing a database design tool, there are plenty of options available, from online tools offered as an “application as a service” to standalone programs that can be installed on your computer.
In this article, we are going to analyze the main features to consider when choosing the best data modeling software – whether it’s online or on your local machine.
Creating a Database Model for an Inventory Management System
In this article, we’ll use the Vertabelo online data modeler to design a data model for an inventory management system.
Do you need to create and implement a database for an inventory management system? In this article, we’ll walk you through a generic inventory management system database model. No two organizations are the same; they all have their unique requirements and needs. So, this database design may require adjustments or modifications based on your own organization requirements, preferred inventory counting method, and your local legal or industry regulations.
Creating a Database Design for a Banking System
This article will guide you through the necessary steps to create a database model for a banking system. We’ll use the Vertabelo online data modeler to define all the required entities and the relationships between them.
Bank legislation varies from country to country, and not all banks offer the same products and services. In this article, we’re going to create a generic ER diagram for a banking system. This database design may require adjustments or modifications based on your own requirements and your local legal and industry regulations.
ER Diagram for a University Database
In this article, we’re going to demonstrate how to create an entity-relationship diagram (ERD or ER diagram) for a university database. We’ll design it from scratch using the Vertabelo web-based data modeler.
To make our university database ER diagram simpler to understand, we have divided the data model into three main areas:
Career Planning, where we define each career with its required courses and the professors that teach those courses.
Top 6 Online Database Schema Design Tools
Why do you need a database model? And what tools are available to help you in the database design process? We review the best online database schema design tools in this article.
One of the key tasks in the software development cycle is data modeling. Creating a good data model allows us to save costs and speed up development, as explained in the article Why Do You Need Data Modeling?
How to Generate a Snowflake Database Model DDL
In this article, we will see how to use Vertabelo to create a Snowflake DDL script. We’ll start from a data model created online and walk you through the process of generating the SQL script that will create the physical database.
Vertabelo is a powerful yet easy-to-use data modeling tool that can help you create database models for many database engines, including Snowflake.
What Is Snowflake? Snowflake is a Cloud-based Database-as-a-Service designed by former Oracle engineers.
Designing an Amazon Redshift Data Model Using Vertabelo
See how Vertabelo can help you design a database diagram for Redshift.
This article will show you how to use Vertabelo as a database modeling tool for Redshift. It allows you to design and implement a database model in a simple way. (Vertabelo also supports other database management systems, but in this article we’ll focus on the Amazon Redshift DBMS).
What Is Amazon Redshift? Amazon Redshift is a Cloud-based, data warehouse oriented implementation of PostgreSQL database engine designed and offered by Amazon.
Database Design for Online Survey Systems
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.
Where to Find Database Diagram Examples
This article discusses various sources of database model examples you can use as a starting point for your data models.
Having a variety of database diagram examples on hand is very useful. This is true whether you are starting your career in database design or consider yourself a seasoned database professional.
It is a good idea to use existing database model examples as a starting point, rather than to try to reinvent the wheel.
