View Single Post
  #6 (permalink)  
Old May 13th, 2014, 04:10 PM
Rod Stephens's Avatar
Rod Stephens Rod Stephens is offline
Wrox Author
Points: 3,166, Level: 23
Points: 3,166, Level: 23 Points: 3,166, Level: 23 Points: 3,166, Level: 23
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jan 2006
Location: , , .
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default

Of course for this application, you can't allow duplicate values for StudentId. You can allow duplicates of the auto-numbered field as long as it's part of a larger primary key, such as year + auto_number.

But it would probably be very confusing to give two students the same ID.
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)