Re: Three tables or one?
I'd beg to differ.
Having one table with a type id linked to a look up table is better.
IF you have another type of device, e.g. satellite phone you would have to add a new table, alter views etc.
Wth the single table and a look up table you add another row to the look up table and you can then add that type without altering the structure of the database.
table devices
~~~~~~~~~~~~~
deviceid
typeid
...
table devicetypes
~~~~~~~~~~~~~~~~~
typeid
typename
...
Subject
Written By
Posted
Re: Three tables or one?
March 14, 2007 09:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.