database diagram

Create ER Diagram for SQL Server Database Using SSMS and SQL Designer

Entity Relationship Diagrams are widely used for analyzing database structure and troubleshooting issues with logic or deployment. In this article, we provide a detailed walkthrough of what an ER Diagram is and how to create and manage database diagrams.

(more…)

Relationships in SQL – Complete Guide With Examples

In this article, we are about to take a close look at the SQL Server relations, including one-to-one, many-to-many, and many-to-one relations, and get into details of creating those with the help of dbForge Studio for SQL Server.

(more…)

SQL Database Design Basics with Examples

It is a common practice that a DB architect has to design a relational database tailored to a particular solution.

(more…)

How to Create a Many-to-Many Relationship

Establishing a many-to-many relationship between the tables in a database is usually done for ensuring efficient data processing and data integrity, as well as for database normalization and data analysis tasks.

(more…)

Adapting Diagram File to Another Database

Some of our users have faced the situation when they need to change the connection details of the existing Database Diagram file.

Let’s assume the situation when you have several databases with identical schemas which are only located on different MySQL servers and you have created a database model that was saved in a Database Diagram file. Now, you want to avoid redesigning the database model from scratch and only reassign the existing database model to another MySQL server. (more…)

How To: Create a MySQL Database Diagram Using a Sketch Image

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

(more…)

Quick start in database development with Sakila database project

The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.

(more…)

How to: Create MySQL Database in One Shot

This article gives step-by-step instruction for visual database creation.
There is a lot of instruments that allow database developers to avoid monotonous and error-prone manual writing of scripts for tables creation. But to have a complete picture while creating a database it’s necessary not only to speed up the process of database objects creation but also to visualize relations between them. dbForge Studio for MySQL offers a perfect tool for such purpose – Database Designer.

(more…)

How to Save MySQL Database Diagrams as an Image

dbForge Studio for MySQL has the Database Designer functionality that allows you to build and view the structure of your database using the diagrams. You can read more about it in the Getting Started with Database Designer article.

(more…)

Getting Started with MySQL Database Designer

Contents

  • What Is Database Designer?
  • How to Create a Database Diagram
  • Navigating the Diagram
  • How to Quickly Print Diagram
  • Saving and Restoring the Diagram (more…)

Your subscription could not be saved. Please try again.
Confirm your email by clicking the link in your inbox!

Subscribe to our blog

to get the latest posts delivered to your inbox