Database :Creating An Appropriate Primary Key in A table. (1 Viewer)

F

fsagwe

Registered User.

Local time

Yesterday, 17:06

Joined

Jun 22, 2014

Messages

14

• Aug 13, 2018

• #1

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,

 

Attachments

• 
  IMG-20180813-WA0001[1].jpg

  83.6 KB · Views: 93

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 17:06

Joined

Aug 30, 2003

Messages

36,124

• Aug 13, 2018

• #2

"E - None of the above".

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 01:06

Joined

Jul 9, 2003

Messages

16,273

• Aug 13, 2018

• #3

fsagwe said:

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!

Click to expand...

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...

 

P

plog

Banishment Pending

Local time

Yesterday, 19:06

Joined

May 11, 2011

Messages

11,638

• Aug 13, 2018

• #4

Autonumber

 

F

fsagwe

Registered User.

Local time

Yesterday, 17:06

Joined

Jun 22, 2014

Messages

14

• Aug 13, 2018

• #5

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

Best Regards,

 

F

fsagwe

Registered User.

Local time

Yesterday, 17:06

Joined

Jun 22, 2014

Messages

14

• Aug 13, 2018

• #6

Thank you for the reply!