From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

The EER diagram editor

The EER diagram editor - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

The EER diagram editor

“

- [Instructor] Alright, the next concept we want to talk about within database design is building enhanced entity relationship models, or EER models. So as we're designing our databases, it can be really useful to create these EER diagrams so that we can visually model the relationship between tables and the constraints within those tables. We can use EER diagrams to help map out things like which tables we have in the database, which columns exist in each table, the data types of those various columns, primary and foreign keys within the table, relationship cardinality between tables, so whether it's a one-to-many relationship or a one-to-one relationship and in which direction, and then any constraints in the column. Often we're going to be using the non-NULL constraint, but there's others that we can place as well. So here on the right is an example from the Maven Movies Database, which is the database we used for our MySQL for Data Analysis, SQL for Beginners course. We've got…

Contents