| Author |
Topic |
|
mac_pak
Starting Member
5 Posts |
 Posted - 2008-09-10 : 11:23:21
|
| Hello,I'm rather new with databases. My task is to create a database which will hold information about students, teachers. That database will work with a asp.net website. Teachers give topics. These topics are visible for students. Every student can choose 5 topics and gives each topic a priority. Teacher can see that studentX chose a topic. Teacher can also set priority for a topic: can say that he would like studentX make that project instead of studentY, for example. Students can choose topics only in fixed period of time. Similarly teachers can give topics and set priorities in the same period of time. After that period of time students should be assigned to topics. How students are chosen depends on priorities (both students' and teachers'). Teacher should be able to see who is gonna deal with his topics. Teacher can give only fixed amount of topics. My base question is how to deal with enrollment. Most things should be done on database. The website is to fetch data from database, show data to students/teachers, take data from students/teachers. Maybe any hints how to start?? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 11:31:59
|
www.rentacoder.comWhat I am trying to tell you is that your question is too wode to answer.There are so many questions, since you seems to be new into database business.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mac_pak
Starting Member
5 Posts |
Posted - 2008-09-10 : 11:37:08
|
| Yeah, i am new in databases but i wanna learn it and i don't need to buy any software. If there are so many questions/answers just give me first and I'd be happy.At least how to start. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 11:41:50
|
First you must design how things are.Which "objects" do you use. Students, teachers, topics and so on.You must have somewhere to store them.Then you have to design how these things connect. A teacher can have multiple topics or just one?Design how to store teacher-topic relationship.And so on...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
mac_pak
Starting Member
5 Posts |
Posted - 2008-09-10 : 11:45:35
|
| Yeah, that's no problem for me. I've done it many times. But the main problem is how to set temporary enrollment. Let's assume that we have table with topics. During the period when student can choose topics, one topics can have 5 students assigned but when the time elapsed, the topic should have only one student assigned. That is the main problem for me. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 11:53:24
|
Set rules for how to select the only 1 student when time elapse.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
mac_pak
Starting Member
5 Posts |
Posted - 2008-09-10 : 12:03:55
|
| Yes, I know but the main question (sorry that i didnt say it earlier) is "how to connect temporary students to a topic - and store this 'connection' in a database". Should i make temporary table with 5 students ID and a topic ID ?? And after the time has elapsed drop it and assign chosen student to real topics' table?? I can't figure out anything else. Of course I've prepared a algorithm which use priorities and choose a student. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 12:09:38
|
You have to decide what differs a "temporary" student with a "normal" student.Is it like a STATUS? If so, have a bit column named Temporary and store all students-topic links in same table with 1 or 0 as value.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
mac_pak
Starting Member
5 Posts |
Posted - 2008-09-10 : 12:35:48
|
| Ok, thank You, I'll try it :)) |
|
|
|
|
Enrollment + Database