Using description as primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is it material description enough as a primary key?, we are not in the stage
of using catalog as a material coding, what would be the constraints if we
use description as a primary key, than we will make an automatic pop up to
show the lowest material price from each supplier.

Thanks in advance,

Frank
 
hi Frank,

Frank said:
Is it material description enough as a primary key?
Click to expand...
In database theory this can be, but your material description must be a
candidate key. Thus means, is it sufficent to identify a single data
row? Does it not depend on any other data?

Despite that, it has some disadvantages, as scuba already pointed out.

Using a surrogat key, e.g. an autoincrement, will save you unnecessary
updates, even if they can be maintained be the referential integrity
settings.

Also some operations will be slower, when using a text key.

mfG
--> stefan <--
 
Back
Top