From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Follow a naming convention

Follow a naming convention

From the course: Learning Relational Databases

Start my 1-month free trial

Follow a naming convention

- [Instructor] We've now got a good plan in place for how our database needs to function. The next step of the process is to start thinking about how to actually implement the plan in our relational database management system of choice. I've created a Table Design Worksheet that you can print out for each of the tables identified in your data model, to help you keep track of the decisions and changes that we're going to be making. These Table Design Worksheets will help you out when it comes time to implementing the design in the RDBMS, it'll help make up an important component of your database blueprint. The first step of the process is to be explicitly clear in how we're going to name the various tables and attributes that we're about to create. Proper naming of your tables and fields provides a sort of self-documenting feature of your completed system. Such as they can aid someone that comes after you, that needs to maintain your database. Or, even help you remember what it was…

Contents