| Author |
Topic |
|
rbharatha
Starting Member
29 Posts |
 Posted - 2002-05-12 : 21:44:15
|
| Hi SqlTeam,I got to design the Database for this one, which iam facing lit bit problem.,I got the information for Applicant's who will be evaluated by number of Panel Members in the Interview., ex; Each applicant will be asked questions and will be given some scores by each or some of the Panel Board Members. So my questions is how can i design the structure to store the scores given by each or some of the panel board members for each applicant in one table or different tables with warm regardsRamesh |
|
|
olily
Starting Member
37 Posts |
Posted - 2002-05-13 : 00:35:32
|
| If I understand you correctly, this should work. You need to have 3 tables. 1. Applicants - store applicants information. You might need to normalize this table but it depends on the fields that you have.2. Panels - store panel board members information.3. Scores - store the scores given by panels.You need to link the 3 tables. From Applicants, you have AppID.From Panels, you have PanelID.So combination of AppID and PanelID will be the foreign key in Scores. |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-05-13 : 00:50:33
|
| What about the "Questions" Oily?DavidM"SQL-3 is an abomination.." |
|
|
|
rbharatha
Starting Member
29 Posts |
Posted - 2002-05-13 : 02:56:29
|
| Hi Sqlteam, i got some structure which looks some what like this.,Applicants Table with applicants information (Key field as ApplID)Panel Table - Panel Board Members master table (key field as PanelID)Question Table with (key field as Qno, questions and reference ApplID & PanelID)now my problem isthe questions each year posed to applicants by the panel board members may be changed or added to the database.and each applicant is examined by different panel members and gives him the score. 1. I have to maintain who has examined the applicant and how much he has given the score to that applicant.2. if next year the panel board members changed, and the questions from the question table also changed. how would i refer to them i.e, the panel members sitting in the panel board.thanks in advanceRamesh |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-05-13 : 03:28:35
|
| Ramesh,You need another table!!Applicants(APPID)Panels(PanelID)Questions(QuestionID)Results(APPID,PanelID,QuestionID)HTHDavidM"SQL-3 is an abomination.." |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-05-13 : 04:05:28
|
quote:
1. I have to maintain who has examined the applicant and how much he has given the score to that applicant. 2. if next year the panel board members changed, and the questions from the question table also changed.
in u Panels ,Questions table add a status field and update it to history or something .... so this will allow u have diffrent question and diffrent panel... i suggest dont change the data update the status when change....======================================Ask to your self before u ask someone |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-05-13 : 06:39:34
|
| I appreciate the will to help co-SQL2000 users who are stuck with a problem. But isn't it to obvious to ask the members of this forum to build a database which a company will use for it's own benefit!?No hard feelings Ramesh, but such a simple thing you should figure out for yourself.Some people should get paid for doing things like that. |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-05-13 : 06:44:47
|
if people are paid doing this.. where are several gurus how will earn a lot... not to mention that now what there are doing is above all and nothing can replace it.....keep the show going gr8 work guys...======================================Ask to your self before u ask someone |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-05-13 : 07:06:04
|
| Some people just don't understand... |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-05-13 : 23:11:43
|
quote:
Some people just don't understand...
the extent of understanding varies from person to person can't be same .... we cant say that every body has to know every thing..they may know it might have done before but just to confirm it can and will approach SQL gurus... does'nt mean they dont know it ... no hard feeling... we are sharing info and getting the best what most follow and do... i may not be right all the time.. so i hvae to check with others...======================================Ask to your self before u ask someone |
|
|
|
rbharatha
Starting Member
29 Posts |
Posted - 2002-05-14 : 05:43:51
|
| Hi rihardh,Some people should get paid for doing things like that. Don't feel bad, but the site is for developers Forum where they can share and endeavour to make things perfect and make them seleves sure what they are doing.,Any way thanks for your concern., |
|
|
|
olily
Starting Member
37 Posts |
Posted - 2002-05-15 : 00:56:18
|
| Hey guys....we are trying to help each other. Sharing knowledge isn't bad, right? |
|
|
|
|
Database Design