InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 19:47:28 GMT20http://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxThink about it like this, you don't need three columns, you have three potential pieces of information for a unique relationship between a student and a course. That might help you resolve how you want to put together the model.Tue, 03 Jan 2012 07:47:36 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspx[quote][b]kavyap.kp (12/30/2011)[/b][hr]ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,[/quote]Well... if you have the tables that means that you already have a sound ER Model, isn't it? Would you mind in showing it to us?Mon, 02 Jan 2012 09:36:34 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspx[quote][b]kavyap.kp (12/30/2011)[/b][hr]ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,[/quote]Start with [b]Normalization [/b]Principles...[url]http://en.wikipedia.org/wiki/Database_normalization[/url]Sat, 31 Dec 2011 01:09:22 GMTDevhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxI just can repeat what I stated before:[quote]Please read and follow the advice given in the first link in my signature and post ready to use sample data together with your expected result and what you've tried so far.Based on the vague description there's little we can do....[/quote]Did you even bother to read that article? :ermm:Sat, 31 Dec 2011 01:07:55 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,Fri, 30 Dec 2011 22:52:14 GMTkavyap.kphttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspx[quote][b]kavyap.kp (12/30/2011)[/b][hr]...is there a solution for it?[/quote]Yes, I think so - what do you think?Why don't you start by showing us your ER model?Fri, 30 Dec 2011 12:45:41 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxPlease read and follow the advice given in the first link in my signature and post ready to use sample data together with your expected result and what you've tried so far.Based on the vague description there's little we can do....Fri, 30 Dec 2011 10:57:25 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxWhat have you got so far?Fri, 30 Dec 2011 10:49:13 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1228471-374-1.aspxi am working on e learning and certification i have this prob on maintaining the details of students who have registered for the various courses,courses they have completed,and if they are pursuing, i need 3 columns for every course for every student is there a solution for it?Fri, 30 Dec 2011 09:57:26 GMTkavyap.kp