If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Database Design for online student feedback survey system

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
Red face Database Design for online student feedback survey system

Hi,
I need help with the design document for a database for an Online Student Feedback System for a university. The database will probably be MySql (due to low budget).[list=1][*]Any ideas where i can find some sample design document for such a system, or similar one?[*]Any ideas or tips in general?[/list=1]
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Location: Delhi/Bangalore, India
Posts: 74
What is that system supposed to accomplish exactly? (can you briefly describe it?)
__________________
manish
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
Short description of the online student feedback system

Quote:
Originally posted by Manish
What is that system supposed to accomplish exactly? (can you briefly describe it?)
Well, this system is supposed to enable the students to fill-in feedback form on courses and instructors taken at the university.
This system should also enable the educational staff to retrieve statistical analysis of student feedback survey.
I would like to enable the educational staff to compare survey results of one course with those of another course (both conducted by the same staff member).
That's the general idea.

The main issues are:[list=1][*]how to seperate the feedback content from student personal details (so a student can't be tracked down and that his privacy and anonymity will be kept.[*]how to prevent students from filling-in more than one feedback form on a staff member, and by doing so, bend the survey results[/list=1]
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Location: Delhi/Bangalore, India
Posts: 74
Re: Short description of the online student feedback system

Quote:
Originally posted by mikla
The main issues are:[list=1][*]how to seperate the feedback content from student personal details (so a student can't be tracked down and that his privacy and anonymity will be kept.[*]how to prevent students from filling-in more than one feedback form on a staff member, and by doing so, bend the survey results[/list=1]
I would go with a login system, where each student is assigned a username/pass (they should change the default passwords before the first feedback takes place). This will prevent students from filling multiple forms on a staff member.

How about having a tracking method that is easy, but not straightforward enough for anyone to take a look at the database and figure it out? You may hash the student's login name and other details (which will change with every separate feedback form the student fills in), and store this hashed identifier in the database where feedback details are stored. Total anonymity (discarding all data so that the student cannot be tracked later, only the true/false of whether he filled in the form is stored) may have its own disadvantages, specially when the students are aware of it. Tracking the hashed data would be a little nontrivial for anyone else (the sysadmin may hash it with public-key system) not having the required field details/passwords/keys. But the sysadmin, if any such need arises, may track it back to the student login.
__________________
manish
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
Question Re: Short description of the online student feedback system

thanks for the vedy informative answer!

what do u think about the different groups of user and the permissions for each group?
I mean, the set of permissions for each user group should be specified in a database table, or do you see some other way to do it?
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Dec 2001
Location: Delhi/Bangalore, India
Posts: 74
Not sure if I got clearly what you meant by group permissions.

I assume your application overall looks like this:

The front-end can be developed as a web-based form interface (PHP & Perl come into mind). The PHP Script (for example), takes input via html form (including login, password and identifier of the target staff member to be evaluated). It cross-checks the login/password with those stored in the database (the password may be hashed and not stored in plain text in the database). If verified, checks for double entry (whether the student has already filled in for that particular staff member). This double-check information can be stored in the student-information table itself (true/false fields, for example). If everything is clear, it inserts those values in a separate table (e.g. named 'feedback-2003') along with a hashed value (calculated from combination of login-name + staff member id + fields of your choice ). Note that I assume, for simplicity that there is only one separate table for storing feedback values. You may have multiple tables depending upon your requirements and efficient database design.

There would also be an interface for the sysadmin, to create new feedback forms and/or modify existing staff member names, for example. etc.

A report generation script may later pick up values from the feedback table and generate statistics particular to staff-members,etc.
__________________
manish

Last edited by Manish; 01-14-03 at 10:39.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
you got it right. very accurate!

well, here's my database schema. what do you think?
Attached Images
File Type: gif db_sfs.gif (17.3 KB, 1925 views)
Reply With Quote
  #8 (permalink)  
Old
Moderator.
 
Join Date: Sep 2002
Location: UK
Posts: 5,171
Quote:
Originally posted by mikla
you got it right. very accurate!

well, here's my database schema. what do you think?
You could drop the "tbl" prefixes to make the table names easier to read

Also, some of your column naming seems inconsistent - a column called CourseName in tblCourses is a foreign key to a column named ID in tblCourseList, which then has a CourseName column that is something different...?

Of course, there are various standards and preferences concerning table and column names, but consistency is always desirable. I would try where possible to use the SAME name for the same column in different tables, e.g. TermID in both the Courses table and the Terms table.
__________________
Tony Andrews
http://tinyurl.com/tonyandrews

Last edited by andrewst; 01-14-03 at 11:15.
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
Wink

OK. Accepted. changed the table names and change the field name from course name to course code. u c, every course has something like a catalog number, which means, for example, that the course "Principles of Economics" has a cat# 1202. But the same course can be conducted by different instructors and on different terms and each variation gets a unique id.

Now, how do u think i should design the feedback tables \ questions and the relationship between them and between the feedback table and the courses?
Attached Images
File Type: gif db_sfs.gif (6.9 KB, 1762 views)
Reply With Quote
  #10 (permalink)  
Old
Moderator.
 
Join Date: Sep 2002
Location: UK
Posts: 5,171
Quote:
Originally posted by mikla
OK. Accepted. changed the table names and change the field name from course name to course code. u c, every course has something like a catalog number, which means, for example, that the course "Principles of Economics" has a cat# 1202. But the same course can be conducted by different instructors and on different terms and each variation gets a unique id.

Now, how do u think i should design the feedback tables \ questions and the relationship between them and between the feedback table and the courses?
I don't know, it would depend on whether each course has its own set of questions, or every course uses the same questions, or there are some courses that use one set of questions and others that use another set.

However you do it, presumably at some point there must be a table that records something like:
Response( StudentID, CourseID, QuestionID, Answer )
__________________
Tony Andrews
http://tinyurl.com/tonyandrews
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Haifa, Israel
Posts: 7
Hitherto (is that the right word? :-), they used the same feedback form for all the courses. But maybe they would like enable it in the future.
But how do i design the feedback tables and the feedback response?
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 3
Making same project with vb 6.0 and oracle

Hello, I'm making same project with vb 6.0 and Oracle. Can you please help me out to start with the project?
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Apr 2011
Posts: 3
Help with the project

Hey
if u do read this then can you please tell me how u approached the making of this project??
It would do a world of good if you could share your ideas!!!!
I am doing the same project in VB Web developer and would really like to see your code!
Thanks
Reply With Quote
  #14 (permalink)  
Old
Registered User
 
Join Date: Mar 2011
Posts: 3
Hi,
First of all recognize all the tables you need in your project, like a faculty table, class table, student table etc. Desgin the front end consisting of all the questions you want to ask and then connect them with tables. i'm attaching a file including the data dictionary and forms design of my project.
In my project Front End was: VB 6.0 and Back End: Oracle 10g

For further help please tell.
Attached Files
File Type: doc facluty feedback system.doc (1.24 MB, 199 views)
Reply With Quote
  #15 (permalink)  
Old
Registered User
 
Join Date: Apr 2011
Posts: 3
Thanks!!

It is grateful of you to reply to my post. How so ever I wish it would have helped me but my Project was due on on in April and I some how managed to do it.
I was creating a website for my college which would enable the students of the college to be able to evaluate the faculty who have been assigned to them. I am attaching the my project just for reference and sharing of knowledge!
The website was built using ASP and therefore u need to have IIS installed. Open the asp page i1.asp from your browser and let me know how it feels.
You can get the login ID and password from the database!!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On