Atomic Primary Key or Composite ? Which approach is better ?
ZAFeb 24 2003 — edited Feb 24 2003
Hi all,
I have a table that has its composite primary key (infact foriegn keys of other tables make pk in this table).
But due to large project complexity, i just want to have an atomic primary key, so that i could use a sequence for it, instead of using N foreign keys from other tables. And furthermore, a single column primary key can be easily accessed as foreign key as compared to N columns primary key.
Is it a good approach in general ?
My personal view has certain reservations regarding the atomic primary key in such case. It could lead to a weak database design.
Any suggestion ?
Thanx
Zaaf.