The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

csell (6) [Avatar] Offline
#1
Hello,

just started to read the fist chapters, and stumbled across example SQL DDL code in chapter 1.2 that mentions a table named USERS. Now, I dont remember the exact reference - but I do think it was an authoritative one (might have been ol' Date himself) - that says that table names should be in singular and not in plural, just like the entities they implement, or class names.

Waddya think?
regards,
chris/bergstr

P.S.: Just did a google search, and it turns out this is a rather controversial issue, with the majority leaning towards singular, however. OTOH, there is one well-renowned source ( "SQL Programming Style" by Joe Celko) that favors plural and cites ISO/IEC 11179 as a reference. So this may be a moot discussion
Christian Bauer (56) [Avatar] Offline
#2
Re: Table names
USER is a reserved keyword in most DBMS. USERS was chosen to illustrate that point, in chapter 4.

Celko is a quack.