121 reputation
4
bio website
location Vietnam
age 25
visits member for 1 year, 11 months
seen Mar 19 at 15:35

I'm an Information Technology student at Hoa Sen University, in Viet Nam.


Nov
17
comment Which design better when use foreign key instead of a string to store a list of id
@EmmadKareem Maybe I should explain more about my project. In my project, General Exam have a collect random questions got form question table. Then, I will create exams for students, every exam will get same number of questions (which user defined when create general exam) from list questions of general exam, but they are randomize.
Nov
17
comment Which design better when use foreign key instead of a string to store a list of id
@EmmadKareem Thanks for pointing, I designed follow #1 solution, but then #2 solution came in my mind. Actually, I thought the #1 solution is good and followed it, but I just wonder how it different with #2 solution.
Nov
16
comment Which design better when use foreign key instead of a string to store a list of id
@DocBrown I'm just example for easy understand. I just think when it grow up, and compare between 1 row and 100 rows, it's x100 times. Anyway, I'm still a student and have not much experience yet, I just collect experiences for doing better :)
Nov
16
awarded  Editor
Nov
16
revised Which design better when use foreign key instead of a string to store a list of id
change title for better
Nov
16
comment Which design better when use foreign key instead of a string to store a list of id
@Oded sorry sir, i just want to have a quick answer :(
Nov
16
comment Which design better when use foreign key instead of a string to store a list of id
@DocBrown sorry, i just think, with 1 general exam with 100 questions, first solution need 100 rows, second solution need only one row, so i just thought second solution can get id of question faster, so i thought that performance, i will edit my title.
Nov
16
comment Which design better when use foreign key instead of a string to store a list of id
thanks for exlain, i think i should be do first solution but i don't know why i should, now i'm know :)
Nov
16
comment Which design better when use foreign key instead of a string to store a list of id
thanks for explain :)
Nov
16
awarded  Student
Nov
16
asked Which design better when use foreign key instead of a string to store a list of id
Nov
10
awarded  Autobiographer
Nov
8
awarded  Supporter