Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    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]

  2. #2
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74
    What is that system supposed to accomplish exactly? (can you briefly describe it?)

  3. #3
    Join Date
    Jan 2003
    Location
    Haifa, Israel
    Posts
    7

    Short description of the online student feedback system

    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]

  4. #4
    Join Date
    Dec 2001
    Location
    Delhi/Bangalore, India
    Posts
    74

    Re: Short description of the online student feedback system

    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.

  5. #5
    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?

  6. #6
    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.
    Last edited by Manish; 01-14-03 at 10:39.

  7. #7
    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 Thumbnails Attached Thumbnails db_sfs.gif  

  8. #8
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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.
    Last edited by andrewst; 01-14-03 at 11:15.

  9. #9
    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 Thumbnails Attached Thumbnails db_sfs.gif  

  10. #10
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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 )

  11. #11
    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?

  12. #12
    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?

  13. #13
    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

  14. #14
    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 Attached Files

  15. #15
    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!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •