Is using multiple foreign keys seperated by commas wrong, and if so, why?
I'm building online examination system. I have designed to table,
GeneralExam. The table
GeneralExam contains info about the exam like name, description, duration,... Now I would like to design table
GeneralQuestion, it will contains the id of questions belongs to a
Currently, I have two idea to design
- It will have two column: general_exam_id, question_id.
- It will have two column: general_exam_id, list_question_ids(string/text).
So, I would like to know which designing is better, or Pros and Cons of each designing. I'm using Postgresql database.