help on composite keys!
Date: Mon, 19 Feb 2001 20:22:52 GMT
Message-ID: <3a917839.184734010_at_news1.telia.com>
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 - 21:22:52 CET