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 |
|
raymyster
Starting Member
10 Posts |
 Posted - 2008-11-30 : 13:55:49
|
hello community,so here's the deal:i am creating a generation tool that will select random questions & fills them up to reach a proper exam.i need a way to smartly select this data so i wont end up with a useless selection or an infinite loop.mainly the exam will need to be adjusted according to the exam durationeach question has a a time for example 5 minutes & a buffer for example 3 the buffer will allow us using the algorithm at generation time to adjust each question time to reach an exam that will be equal exactly to the exam time.also the exam should match the preferences that are located on my attached form, all of this data is a .dbf table.i need to fix this, but i really have no idea where to start, any help? [URL=http://img148.imageshack.us/my.php?image=reportgenerationformzh3.jpg] [/URL] |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-11-30 : 13:59:12
|
| removed the broken/possible spam link.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
raymyster
Starting Member
10 Posts |
Posted - 2008-11-30 : 14:05:06
|
| its not spam its ana image of the form i want to show to ppl so they help me |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-11-30 : 14:15:16
|
| What are you asking for? An entire solution, from database structure up to the queries? Or do you have a structure and need help with the queries? Or do you need some advice with the DB schema itself?What's a .dbf file?--Gail ShawSQL Server MVP |
|
|
|
raymyster
Starting Member
10 Posts |
Posted - 2008-11-30 : 15:50:35
|
| a .dbf is data base foxpro free table file. never mind that's not the issue.no i don't any design or anything... not the database, ofcourse not the solution that will be like you doing my project hehe.i just need to work on a smart sql query that will generate the exam & i don't know how to start.. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-11-30 : 16:25:27
|
| This is a SQL Server forum. Most of the people here won't know much if anything about foxpro. While we can suggest SQL (if you give us the data structures), there's no guarantee that it will work in foxpro.--Gail ShawSQL Server MVP |
|
|
|
raymyster
Starting Member
10 Posts |
Posted - 2008-11-30 : 23:43:42
|
| I dont need anything in foxpro its sql server only.You have a database of 6 tables.Category table: (2 fields)ID : to relate to the question table (character)Descrition: here you will have the chapter that the question belongs to in this field for example chapter 3 (character)Question time: (3 fields)ID: to relate to the question table (character)Time: the time needed for the question to be done ex: (5 minutes) (numeric)Burst: a number that will make an advantage for the exam to generate upon (numeric)Difficulty:ID : to relate to the question table (character)Vale: value of the difficulty (numeric)Question_details: (2 fields)ID : to relate to the question table (character)Details: this is where the raw data of the question data such as the text the formatting and the question structure will go. (memo)Answer_details: (2 fields)ID : to relate to the question table (character)Details: this is where the raw data of the answer data such as the text the formatting and the answer structure will go. (memo)Question: (9 fields)ID: the unique ID to be able to diffrenciate questions from each other (character)Questtime_ID: to relate to the question ID (character)Chap_id: to relate to the question ID (character)Cat_ID: to relate to the question ID (character)Diff_id: to relate to the question ID (character)Detail_ID: to relate to the question ID (character)Answer_ID: to relate to the question ID (character)Occurrence: to keep trak if this question has been used or not (Boolean)Imagepat: path of the image (character) |
|
|
|
|
|
|
Exam generation kit