Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NayNaySIXX
Starting Member
2 Posts |
 Posted - 2012-08-08 : 10:31:29
|
| Hello,I have been asked to create a front end multiple choice exam which uses SQL database to store the student names, the different exams (4 in total), the questions and the possible answers (a, b, c, d, e).Im fine with designing the actual front end of the product using Visual Basic, but i am very inexperienced in SQL.Would anybody be able to help with tutorials or examples?Thanks in advance.--------------"Do you think exposing children to sex and drugs is a wise thing to do?""Of course."- NayNaySIXX-------------- |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-08 : 11:10:13
|
| one of ways of designinging db would beStudents(StudentID,StudentName,...) Exams(ExamID,ExamDesc,...)Questions(QuestionID,QuestionDesc,...)Answers(AnswerID,AnswerDesc,...)ExamQuestions(ExamID,QuestionID,AnswerID) - contains one record each for each choice of question and answerfor an examStudentExams(StudentID,ExamID)- contains details of exams taken by student------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
NayNaySIXX
Starting Member
2 Posts |
Posted - 2012-08-08 : 11:16:12
|
| Ok thanks, i'll see what i can do :)--------------"Do you think exposing children to sex and drugs is a wise thing to do?""Of course."- NayNaySIXX-------------- |
|
|
|
|
|
|
|
|
Multiple Choice Exam