From the course: AWS Certified Database – Specialty (DBS-C01) Cert Prep: 2 Design and Deployment

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Using an ERD tool

Using an ERD tool

- One of the most dangerous things you can do when it comes to database design is just jump into the database and think, "Well, we've planned out all of our entities, and I'm ready to start creating tables." And so you create this table and that table and you start building it. The reason is that if you go through another process, you might think of things you missed. Let me throw four phrases at you to get your thinking the right way. Database model, database modeling, entity relationship diagram, entity relationship model. All four of these phrases, whether we're talking about database models or database modeling, or ERD or ERM, we're talking about the same basic thing, building a logical model that represents what our database is going to be physically, in other words, what we're really going to implement. The model says this is the database logically. The physical design says this is the database in the DBMS. Now…

Contents