20 Database Design Practices

When designing database, you have choices to make. To work in the right direction and preventing regretting design decisions, I am using these best practices : Use consistent names. Well defined and consistent names for tables and columns (e.g. School, StudentCourse, CourseID ...). Use singular for table names (i.e. use StudentCourse instead of StudentCourses). Table represents a collection of entities, there is no need for plural names. Don’t use spaces for table names. Otherwis... [More]