I'm a little fuzzy on a couple of Database tems, maybe I can get some clarification here.
First, primary keys-- can one table have >1 primary keys? Can an attribute be a primary key in two tables?
Second, foreign keys-- does every primary key have to have a foreign key.
Ex.
Lets say you have three tables:
student(name, studentID, address),
activity(activityID and leaderID) ,
school(schoolID, address),
and another table, say,
info, which links them all (studentID, activityID, schoolID, major).
Would all the entries(aside from major) be foreign keys in the info table?
2006-09-22
08:52:37
·
3 answers
·
asked by
Jay B
1