Let's draw a data map ERD, MySQL workbench

Drawing an ERD with Workbench
Closer to practice! 🐬

Lecture Topics 📖

The data field should be approached from the perspective of 'sets' and 'relationships'. It is often said that 'the data field is something that people become interested in only after experiencing several failures through projects such as building external systems'. This also means that the data analysis/design stage related to the initial work is important.

In this analysis/design stage, one of the tools that allows you to view data from the perspective of sets and relationships is ERD, and I would like to introduce Workbench, an ER modeling tool provided by MySQL. In this lecture, I will provide you with the general knowledge and information required for the process of drawing an ERD based on MySQL and creating a physical table .

Expand your horizons to other fields by applying data sets, relationships, etc. through lectures. You will be able to communicate with colleagues or customers through ERDs with sufficient design time. Also, you will be able to predict and prepare countermeasures in advance even if data occurs in exceptional situations or there are errors in field data.

Join MySQL Workbench!

• The process of drawing an ERD with a workbench emphasizes the importance of ‘data sets’ and ‘relationships’ rather than data.
• Let's draw ERD more easily by following basic examples and systematic procedures.
• We provide an environment that allows easy transition to practical use by selecting a MySQL database with a large user base.
• Explore the relationships between different data sets through one practical service ERD and six case-by-case examples .

📢 Please make sure to check!

• All videos of the course are available for free on YouTube ("SQL Bank"). (After April 24th)

• If you watch on Inflearn, you will receive an ad-free environment + lecture files with available sources + practice scripts, etc. Please keep this in mind when purchasing a course.

I recommend this to these people 🙋

Anyone who needs to draw and implement ERD using MySQL Workbench

Students who want to learn ERD concepts and databases together

Those who dream of a new challenge using IT and data as a stepping stone

Lecture Features ✨

What you'll learn 📚

It consists of a total of six lectures and explains in detail the ER modeling functions provided by MySQL Workbench as shown in the figure.

The simplest is to create two entities, emp employee: dept department, and draw a relationship line between them.

At this time, define the relationship in detail by defining 1) Referencing and Referenced, 2) Cardinality, and 3) Identifying Relationship through the relationship line details window. Draw it step by step according to the systematic order provided in the figure below.

We will look at the screen design of the 'Pet Diary' app system (written with Daum Kakao UI/UX tool OVEN Oven) and the ERD written with MySQL Workbench.

We will also take a closer look at the models divided into six other cases.

Expected Questions Q&A 💬