Cagdas BasaranerFebruary 3rd, 2012Last Updated: December 29th, 2012 Use 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. Otherwise you will have to use ‘{‘, ‘[
![20 Database Design Best Practices - Java Code Geeks](https://cdn-ak-scissors.b.st-hatena.com/image/square/abd0247adc30810f3558e3b9f441691bb9106ccf/height=288;version=1;width=512/https%3A%2F%2Fwww.javacodegeeks.com%2Fwp-content%2Fuploads%2F2012%2F10%2Fsoftware-development-2-logo.jpg)