normalization

Hi,

I'm a newbie Oracle administrator. A new Oracle system is going to be installed soon, and now I have to define specifications about how the programmers will have to handle their programs accessing the database. I would be very grateful if someone could help me with the following questions and similar issues:
- how can SQL statements be made the most efficient?

• how about the access rights: what should the programmers be allowed to do by themselves, what operations shall be reserved for the DBA?
• which naming scheme should be used for tables, indexes etc?
• which data types should be avoided?

What else should I pay attention to when dealing with programmers?

Thank you very much for any help,

Anne-Marie Ternes

anne-marie.ternes_at_cie.etat.lu Received on Fri Feb 20 1998 - 00:00:00 CST