Database :Creating An Appropriate Primary Key in A table.

[fsagwe]

Dear Everyone,

Please assit on which will be the most appropriate primay key for the Book Table in the above extract?The image is attached!

Thank you

Best Regards,

 

[pbaldy]

"E - None of the above".

 

[Uncle Gizmo]

Dear Everyone,

Please assist on which will be the most appropriate primary key for the Book Table in the above extract?The image is attached!

Well I think you've been very astute to see, and understand that the book ID mentioned in that image isn't fit for the purpose.

My guess is the tutor either wants you to create a compound ID (out of two Fields) or add your own ID, an autonumber field.

I would guess that the latter, an "Autonumber field", but I have no idea what is in your tutors mind, you need to get that from reviewing your recent lessons and other information provided by the tutor...

 

[plog]

Autonumber

 

[fsagwe]

Thank you so much for the inside!!Need to review the lesson.

Best Regards,

 

[fsagwe]

Thank you for the reply!