Is there any recommended Naming Convention for Setting up DB Tables and Fields?

I have been having problems with our Sys. Admin. about naming our ORACLE Table names, fields, etc..

Is there any recommended naming convention that would be useful in naming:

• Table Spaces
• Instances
• Log Files
• Tables
• Fields/Columns

He hates to use underscores because he says you have to press 2 keys to enter the character.

He usually names programs as:

	qual1
	qual2
	qual3
	..... for our Quality Control System

Users have a hard time distinguishing between these, but he likes them because he knows they are all associated with the Quality Control System.

He wants to name all our tables as 2 or 3 characters. Ex. Customer = C or Cs or Cust

    Equipment = eq
    Media = med
    Phone_Log = fonelg
    Employee = emp

He has 2 major concern:

1. Too many keystrokes when typing in SQL queries.
2. System Administration tasks would be more complicated if we have long names that he will have to type on a daily basis.

	Note:  He has never worked with Oracle to know ALL the Sys. Admin tasks 
	       that may be needed on a day to day basis.

My argument is that they should be descriptive names that everyone can understand. I think that we won't be typing in 'So Many' SQL queries that we will lose considerable amount of work time. Also, we can use aliases if needed.

Any suggestions will be appreciated!

What kind of names are people out there using?

Mir. Received on Sat May 04 1996 - 00:00:00 CEST