November 14, 2008 at 12:45 pm
i ve tried to make an online exam system with these
tables basicly
1-Student(StudentID,...)
2-exam(examID,...)
3-Qestion(questioID)
4-Choise(ChoiseID)
then the relationShips are
1- student take exam(m-n)
2-exam has questions(1-n)
3-question has choises(1-n)
4-student solve question(m-n)
but when i get the schema after modification and tried to draw the diagram on v.s
it give me an error that the number of keys must be the same on each side
so any one can help i would appreciate that .
November 17, 2008 at 5:41 am
The tools on VS (in my opinion) are rubbish and border on useless. The best tool I use ironically is the tool advertised on the banner of this website. The Red Gate SQL documenter & SQL Dependency Tracker is far better at producing a meaningful database diagram/schema and are very easy to use. Although be aware that if you do try the 14 day free trial they will email you at least 3 times to see if you are interested in purchasing.
Let me know if you do try other tools etc and get a good result...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply