When designing a database it's a good idea to follow some sort of naming
convention. This will involve a little thought in the early design stages but
will save significant time when maintaining the finished system.
The benefits of using a naming convention are more to do with human factors
than any system limitations - but this does not make them any less important.
***Table names are plural, field name is singular
Table names should not contain spaces, should be split_up_with_underscores.
Limit the table name to 23 characters.
If the table name contains serveral words, only the last one should be plural:
***Fields should be unique within the database schema.
The convention is to prefix the fieldname with a 2 or 3 character
contraction of the table name e.g.
PATIENT_OPTIONS would have a field called po_patient_option
PATIENT_RELATIVESwould have a field called pr_relative_name
ABSENCES would have a field called ab_start_date
Creative Software Solutions (Pte) Ltd.
No:80, Nawam Mawatha,