ALL
20 Database Design Best Practices
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 ‘{‘, ‘[‘, ‘“’ etc. characters to define tables (i.e. for accesing table Student Course you'll write “Student Courseâ€. StudentCourse is much better).Don’t use unnecessary prefixes or suffixes for table nam...
4,063 0 DESIGN PATTERN DATABASE DESIGN 20 TIPS WELL DEFINED NAME