I am designing the database to store the feedback given by the users. I am using mariaDB. I am just wondering if my database design is efficient. Also, Can I improve it?
We can have the following tables to store the feedback data:-
-
Feedback – Table to store feature id and option no with feedback ID
as Primary key. -
Features – Feature corresponding to feature ID.
-
Options – Options corresponding to option no.
-
User details- Browser details corresponding to the feedback and user
ID. -
Users- User info corresponding to User ID.
I have taken reference from this question.
Advertisement
Answer
Why use a table for store browser details, you can store it in the feedback table ?
I think it’s more relevant