Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
I have 2 db2 tables. 1st having Roll no. and Name and 2nd having Roll no., marks.
Can the Roll No. in the 2nd table be used as a primary key and a foreign key with it's parent key being Roll no. on the 1st table?
If yes, will it have any implications while we're inserting, deleting or updating any of the tables?