how to find potential primary key?

[Raj786911]

How to identify potential primary key in below table?

Name Title Office State Customer Contract
Jim Smith Associate Regional TX Ford $4
Sara White Vice Pres State NY Raytheon $2
Bill Krupp Assistant Regional CA Google $3

Thanks.

 

[Uncle Gizmo]

Well name's not a good idea because you can have two people with the same name.

I would add an auto number and create the primary key like that.

However seeing as it looks like some sort of exam question then I think what they really want you to say is you would need to use a combination of fields to generate a primary key.

 

[pbaldy]

FYI, moved thread out of the moderated sample databases forum and approved both posts.

 

[Uncle Gizmo]

FYI, moved thread out of the moderated sample databases forum and approved both posts.

I've answered moderated threads before...!

They look like ordinary threads on Tapatalk (mobile)...

I'll try not to get caught out again.!

 

[pbaldy]

Yeah yeah, you've already used that excuse.

 

[Raj786911]

Thanks.. That helps..