December 30, 2011 at 9:57 am
i 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?
December 30, 2011 at 10:49 am
What have you got so far?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 30, 2011 at 10:57 am
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....
December 30, 2011 at 12:45 pm
kavyap.kp (12/30/2011)
...is there a solution for it?
Yes, I think so - what do you think?
Why don't you start by showing us your ER model?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 10:52 pm
ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,
December 31, 2011 at 1:07 am
I just can repeat what I stated before:
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....
Did you even bother to read that article? :ermm:
December 31, 2011 at 1:09 am
kavyap.kp (12/30/2011)
ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,
Start with Normalization Principles...
January 2, 2012 at 9:36 am
kavyap.kp (12/30/2011)
ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,
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?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 3, 2012 at 7:47 am
Think 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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply