Read the rest of the article at the following URL:
-
20 Database Design Best Practices (5 messages)
- Posted by: Fabrizio Chami
- Posted on: February 09 2012 18:07 EST
- 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 names (i.e. use School instead of TblSchool, SchoolTable etc.).
- Keep passwords as encrypted for security. Decrypt them in application when required.
Threaded Messages (5)
- Tosh by Anthony Mizon on February 10 2012 14:25 EST
- Tosh by Neil Stockton on February 11 2012 05:00 EST
- Here's a Best Practice. by Richard Burton on February 17 2012 12:03 EST
- 20 Database Design Best Practices by Pavel Grushetzky on February 10 2012 15:39 EST
- Page title says "404: Page not found" by Michael Chang on February 10 2012 17:30 EST
-
Tosh[ Go to top ]
- Posted by: Anthony Mizon
- Posted on: February 10 2012 14:25 EST
- in response to Fabrizio Chami
Can we ban any articles from http://www.javacodegeeks.com its all obvious tosh. The site only exists to generate advertising revenue. I wince everytime i'm redirected to this god aweful site.
-
Tosh[ Go to top ]
- Posted by: Neil Stockton
- Posted on: February 11 2012 05:00 EST
- in response to Anthony Mizon
Can we ban any articles from http://www.javacodegeeks.com its all obvious tosh.
+1
Dog slow, crap content, and why TSS allows crossposting of their articles to a "rival" site, drawing away readers, is beyond comprehension. Maybe symptomatic of the level that TSS has fallen to also
-
Here's a Best Practice.[ Go to top ]
- Posted by: Richard Burton
- Posted on: February 17 2012 12:03 EST
- in response to Anthony Mizon
Stop using "Best Practice" since you build a community of thoughtless morons that will walk around the office chanting "It's a best partice to do ..."
-
20 Database Design Best Practices[ Go to top ]
- Posted by: Pavel Grushetzky
- Posted on: February 10 2012 15:39 EST
- in response to Fabrizio Chami
Keep passwords as encrypted for security. Decrypt them in application when required.
As a user, I would like my password one-way hashed, instead of encrypted in a decryptable fashion.
-
Page title says "404: Page not found"[ Go to top ]
- Posted by: Michael Chang
- Posted on: February 10 2012 17:30 EST
- in response to Fabrizio Chami
Title says it all. TheServerSide.com sucks. I'm reading the page, but it says "404". Oops. Guess you guys made a big boo-boo. Try again.