We have a SQL-server database. It contains (among others) the tables
students, certificates and a joining table between these two, called
student/cert. It looks like this: studentID, certID, date, passed.
Since a student can fail and make many attempts (so we can have no
unique identifier) itīs advocated in our group that we shall have no
pkey in the joining table, just student ID and certID as fkeys . Since
all the gurus around in this group says there shall always be a pkey
in a table I try to make my voice heard and tell we must have one and
if it doesīnt work itīs something wrong with the design. But thatīs as
far as my arguments goes. So I call for help to sort this out for me
(and the others guys int the group). What drawbacks will there be if
we have this joining table without any pkey? Maybe this is a case for
Mr Hidders?
Received on Mon Feb 19 2001 - 14:22:52 CST
