Question regarding name conventions

From: Sönke Petersen <sk.petersen_at_gmx.de>
Date: Tue, 28 Jan 2003 11:31:42 +0100
Message-ID: <b15m30$86v$1@news.mch.sbs.de>

Hi,

indead my question concerns database design philosophy.

I want to create a database for computer systems. The necessary data can be divided into machine data and accounting data. From an objectoriented view I tend to create at least two tables MACHINE_CONFIG and ACCOUNTING_DATA.

Is there a commonly used way to do this? One could easily put all data in one table without loss of information and integrity.

Second question: how to name the colums of the two tables.

Just use name like "hostname" or "no_of_cpus" in the MACHINE_CONFIG table, or is it more convenient to use a prefix such like "sys_hostname", "sys_no_of_cpus". I think the second way gives one advantage: if I want to combine both tables in future no problems with duplicate colume names will arise.

I don't expect the ultimate answer, just want discuss the above questions.

Regards,
Sönke Received on Tue Jan 28 2003 - 04:31:42 CST