Feedback System PHP/MySQL

[Pritesh23]

I need to develop Feedback module in PHP/MySQL. I would like to know the database design and flow to manage this system.

There are questions for 2 tools which i need to store in my databse and need to create report like %of Positive Response, % of Negative Response, No. of Users for Tool1/2 etc.

I would like to how one can create for Question 2? I mean it based on first response, IF NO, then and then it should ask for WHY.

It would be great if i have any similar example/code/link etc.

Thanks in advanced for your input.

Tool 1

Code: Select all

1.Are you satisfied with the performance of the tool ? Yes/No
2.Are you satisfied with the support provided? Yes/No
         IF NO, Why ?
3.If you need to improve, they are the three major changes you propose Yes/No 
         IF Yes, -----****----
4.What are the general points (up to 3) that you would like to improve on the project Yes/No 
         IF Yes, -----****----

Tool 2

Code: Select all

1.Are you satisfied with the performance of the tool ? Yes/No
2.Are you satisfied with the support provided? Yes/No
         IF NO, Why ?
3.If you need to improve, they are the three major changes you propose Yes/No 
         IF Yes, -----****----
4.What are the general points (up to 3) that you would like to improve on the project Yes/No 
         IF Yes, -----****----

[johnj]

Just go ahead and design the application.

[Pritesh23]

Just go ahead and design the application.

For DB:
One possible solution can be like this:

Tool[tool_id(PK),tool_name,description(if required)]
User[user_id(PK),user_name,email_id,display_name(if registered user)]
Question[question_id(PK),question]
feedback[feedback_id,user_id,tool_id,question_id,comment,satisfaction(0 for No/1 for Yes)].

I am not sure it is best solution or not.

I don't know for the report chart and Question 2.

[johnj]

do a database design - draw an entity relationship diagram, then do 1 nornal form, 2 NF and 3NF and then reduce this to relevant tables.

[johnj]

I cannot do the database design for you unless you are willing to pay me.

[johnj]

Here is an example:
http://www.datanamic.com/support/lt-dez ... eling.html

[Pritesh23]

I cannot do the database design for you unless you are willing to pay me.

Thanks for your input but i am not asking for total design DB / module.

I just would like to get ruff idea and best possible options before starting my work.

[johnj]

http://www.datanamic.com/support/lt-dez ... eling.html

[Pritesh23]

It seems good but i believe the databse design is almost based on the link that you gave.

Any example would be great for Question 2.