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 |
|
tarana
Starting Member
12 Posts |
 Posted - 2011-04-27 : 19:34:50
|
| I am new to SQL. This is my 1st database design. It is for a quiz database for students.Can someone look at my design & let me know if any changes are required. Not sure whether the relationships are set correctly.Attached is my Database Diagram[url]http://img62.imageshack.us/img62/4327/quizdbdiagram.jpg[/url] |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-28 : 03:16:14
|
| Probably get more response if you ask specific questions about items and in text rather than with a link.For relationships just pick an example and say what you are trying to model and how you have attempted it - there are very few participation conditions and cardinalities to consider.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-28 : 03:42:18
|
| Homework?--Gail ShawSQL Server MVP |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-04-28 : 11:16:33
|
| It's tough to offer much without knowing what your requirements it's next to impoosible to offer much:1. Consistanty - Some tables are pural some are sigular.2. There seem to be a lot of mystery IDs (I.E. QuestionBank.LessionID)3. QuestionBank should, probably, be normalized.4. It also looks like you can colapse tables, but hard to say without knowing the keys.5. Why is there an Answer in QuestionBank? Is that at all related to the UserAnswer in StudentAnswers? And why is UserAnswer an INT?6. Nullability - Why are certain column nullable? like QuestionBank.QuestionI could go on, but pointless without knowing the requirements. |
|
|
|
tarana
Starting Member
12 Posts |
Posted - 2011-04-28 : 15:59:16
|
| Sorry! I thought I had a brief description of my project. I really don't have much of a requirements document. I know what to do with the data but have a hard time designing the underlying database. Like I said before I am a newbie.Teacher creates logins for each student & allocates a starting level for each student for each subject (English, Math). Teacher can view student scores, number of attempts.Student logs in, reviews Lesson Intros and takes a quiz. Each Quiz will have 10 questions. Each question is a multiple choice question (4 choices). All student answers will be stored for future review.Only on successful completion of the quiz, the student will proceed to the next lesson.QuestionBank:Each question will have a unique - QuestionID. Multiple Choices - Opt1, Opt2, Opt3, Opt4Correct answer - AnswerSome 10 questions will be allocated to a LessonIDStudentAnswers:Hold the answer selected by student - UserAnswerWhether chosen answer is correct/wrong - ResultAttempt this quiz is at - AttemptThe Lesson the question is allocated to - LessonIDAs far as some fileds beig NULL, fields that will be filled by my program latter, I made them NULL.Here's my updated design.[url]http://img810.imageshack.us/img810/6395/quizdbdiagramrev1.jpg[/url] |
|
|
|
|
|
|
|
|
Quiz Database design - Need Urgent help