Author: Martyna Sławińska
Martyna is a software developer with a passion for programming, automation, and innovation. Currently working for the global corporate IT consulting sector, she is a new-generation techie who hails from Warsaw University of Technology, Poland. She has certifications in both database administration and Java development. Her interests include creating small automation devices using embedded systems and various electronic components. In her free time, she practices yoga, which helps her to center her thoughts and come up with new ideas.
ER Diagram for a Hospital Management System
Read this article to find out how to create an ER diagram for hospital management systems.
Commonly, we start the database creation process by designing a logical database diagram. This diagram is a visual representation of the entities in a system and the relationships between them. Later in the process, the logical diagram is transformed into a physical database diagram that incorporates database-specific details.
In this article, we’ll walk you through building an entity-relationship diagram (ER diagram or ERD) for a hospital management system.
How to Export an SQL Server Database Schema Into a Diagram
If you have a database in SQL Server, you can generate its database diagram to visualize your data. Better yet, you can export your database as an SQL DDL script and use it to create a data model in Vertabelo where you can process it further. Read on to find out more.
In this article, we review how to export SQL Server database schema into a diagram. First, we walk through how to create a database diagram in SQL Server, either for the entire database or for specific schemas of the database.
ER Diagram Cheat Sheet
An ER diagram is a database blueprint. It facilitates data visualization and database development processes. Read on to find out what ER diagrams are and how to create them in Vertabelo.
In this article, we’ll explain what an ER diagram is and what elements it contains. We’ll discuss ER diagram abstraction levels, such as conceptual, logical, and physical diagrams. You’ll learn how to build ER diagrams using various notations, such as Crow’s Foot notation, Barker’s notation, and more.
Top 8 Database Schema Design Tools
Database modeling is the first and most crucial step in creating a database. Read on to find out about our favorite database diagramming tools.
In this article, we’ll talk about database modeling and why you need data modeling in the first place. Then we’ll introduce several database modeling tools that facilitate database schema design, including:
Online database modeling tools: Vertabelo SqlDBM DbDio SqlDBD Standalone applications for database modeling: Navicat ERBuilder SQL Developer Data Modeler MySQL Workbench The database design process is more than just creating an entity-relationship diagram, or ERD.
How to Export an SQL DDL File From SQL Server Management Studio for Reverse Engineering
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.
How to Create a Database Diagram from a DDL
A database diagram, aka ER diagram, is a certain type of flowchart used in database design. It describes the entities and how they relate to one another. Vertabelo lets you create an ER diagram for your database by importing a DDL file. Read on to find out more.
This article introduces what a DDL file is and why ER diagrams are an essential tool in the database development process. In the end, I’ll show you how to import a DDL file into Vertabelo to get an ER diagram of your database.
How to Put Tables in a Vertabelo Data Model Into a Particular Schema
There is more to a database structure than just tables. Tables are logically divided into groups and stored in database schemas. Read along to find out how to include schemas in your ER diagram using Vertabelo.
A database consists of one or more database schemas, and a database schema consists of one or more tables. A good data modeling tool helps you set them all up. In this article, you’ll see how to create database schemas in Vertabelo and assign tables to them.
Data Model Types: An Explanation with Examples
Data modeling is an essential part of designing a database. If you want to achieve the best outcome, make sure to utilize the available data models. Read on to find out more.
Every relational database has clearly defined objects and relationships among these objects. Together, they comprise the data model.
This article presents the concept of data modeling. First, we’ll go over data modeling and the steps of its process.
What Logical Models Data Types Are Available in Vertabelo?
Logical models define the initial blueprint of your database. Read along to learn how to create them and what attribute data types are available in Vertabelo.
In this article, we’ll introduce the logical model. It essentially illustrates the structure of entities, attributes, and relationships in your database. Also, you’ll see the difference between logical and physical models. In the end, we’ll create a logical model in Vertabelo, which will include creating entities with attributes of specific data types.
How to Define a UNIQUE Key in Vertabelo
Among the many database constraints available to us, the UNIQUE key constraint ensures the uniqueness of data in a column or a set of columns. Read on to find out more about the UNIQUE key constraint and how to define it in Vertabelo.
In this article, we’ll focus on the UNIQUE key constraint. We’ll start with its basic definition and usage and gradually build up to more advanced options. Also, we’ll jump into Vertabelo and create an ER diagram that uses the UNIQUE key constraint.
