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.

Solution: EER diagram editor

Solution: EER diagram editor - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: EER diagram editor

“

- [Instructor] All right, this is the solution video for your assignment on building EER diagrams. As a reminder, we'll be trying to build an EER diagram for the onlinelearningschool schema. Let's jump into Workbench and walk through the solution. Okay. So the first thing that we'll do is go back up to the home screen and then create a new model, and I'll say Add Diagram. And when this new EER diagram opens up, we'll have our templates where we can create our new diagrams from. So first, before I actually start creating, I want to take a look again at the onlinelearningschool schema. So let's just do, let's get these tables open. We have course_ratings, courses and course_ratings_summaries. So let's start with courses. And I got an error because I have no database selected. I just opened up my Workbench instance. So I need to specify a database and we'll say, USE onlinelearningschool to set that default schema. And now I can get the data here. So we've got course_id, which looks like…

Contents