NeilBelgium
IS-IT--Management
Dear all,
I’m trying to build an online questionnaire which gathers scores and then inserts the data into an access db. However, several people have expressed the view, quite rightly, thet my db design isn’t optimal, and I can’t for the life of me work out how to set it up. As such, the db architecture would be a good starting point, and I need help!
So, here's what I'm trying to build:
the final result should be a report for each of 40 managers, telling them how other people rated them on a 40-question questionnaire. The slightly more complex part is that of the ten or so people that are assessing each individual manager, there are different
”relationships” in play. for example, two of these people may be colleagues , two may be bosses, five may be people who report directly to this manager, and
others may be for example external customers, suppliers etc.
so, for each question, I don't need just the average score given, I need to
also produce results for each of these groups.
eg. your colleagues (three persons) rated you a 4.2, your subordinates rated
you a 3.7 and so on........ and overall you scored a 3.9 on this question.
what I'VE done is to create four separate tables - one for the scores given by a person's bosses, one for their colleaugues, one for their subordinates etc.
Plus another four tables to collect the amount of responses there are for
each group. obviously to produce an average score, I need both the total
score and the number of responses so that I can divide one by the other.
I've also got a table with the relationships between the hundred or so
people filling in these questionnaires, and the 40 managers. numerical
values demonstrate whether the relationship between these two people is
boss-subordinate, suborinate-boss, colleague or customer. another table,
same names, with a 1 or 0 value to record whether this person has rated this manager or not. The default value is 0, and once the questionnaire is filled in this value is changed to a 1.
Hope this makes some sense to you, and thanks once again to people on this forum for taking the
time to help- it is greatly appreciated!
neil
I’m trying to build an online questionnaire which gathers scores and then inserts the data into an access db. However, several people have expressed the view, quite rightly, thet my db design isn’t optimal, and I can’t for the life of me work out how to set it up. As such, the db architecture would be a good starting point, and I need help!
So, here's what I'm trying to build:
the final result should be a report for each of 40 managers, telling them how other people rated them on a 40-question questionnaire. The slightly more complex part is that of the ten or so people that are assessing each individual manager, there are different
”relationships” in play. for example, two of these people may be colleagues , two may be bosses, five may be people who report directly to this manager, and
others may be for example external customers, suppliers etc.
so, for each question, I don't need just the average score given, I need to
also produce results for each of these groups.
eg. your colleagues (three persons) rated you a 4.2, your subordinates rated
you a 3.7 and so on........ and overall you scored a 3.9 on this question.
what I'VE done is to create four separate tables - one for the scores given by a person's bosses, one for their colleaugues, one for their subordinates etc.
Plus another four tables to collect the amount of responses there are for
each group. obviously to produce an average score, I need both the total
score and the number of responses so that I can divide one by the other.
I've also got a table with the relationships between the hundred or so
people filling in these questionnaires, and the 40 managers. numerical
values demonstrate whether the relationship between these two people is
boss-subordinate, suborinate-boss, colleague or customer. another table,
same names, with a 1 or 0 value to record whether this person has rated this manager or not. The default value is 0, and once the questionnaire is filled in this value is changed to a 1.
Hope this makes some sense to you, and thanks once again to people on this forum for taking the
time to help- it is greatly appreciated!
neil