How to design database for a project

Показать описание

Рекомендации по теме

Комментарии

I failed in an interview of design (my first one which is unexpected😅) because I directly jump into making tables and relationships and I am confused about what did I do wrong in that now I got it how to approach these problems. thanks a lot sir🔥

abhishekvishwakarma

Thank you so much. You actually showed the concept of a foreign key. One thing I don't think you addressed and glosses over was how to handle multiple answers (Check Boxes). This is a major database question I don't know how to solve. Thanks again for an excellent video.

danielmadison

Thank you so much for making this video. This is by far the most useful video I have found on the internet to approach these type of problems.

OmPrakash-otnr

Thank you sir ! I was afraiding to step forward to create db but... Now I am starting.... 😌

hrushikeshkhonde

"The sooner you start coding, the later you finish" haha

sase

This video is the best dw video for de interview that I saw on youtube so far, thanks

lingxu

Thanks so much for this beautifully explained Video!

TechMedia-it

thank you brother for this video
very helpful in understanding how to break down problem statement in functional entities and then creating tables and relations among them
thanks a lot

rakeshnarang

Hi, where is the next video you talk about ?

SirMika

I think you have bad design in tables question and survey because your design implies that each survey has its own questions because you have survey_id in question table, problem is if you have same survey, same question for every survey. I think in that case you should remove survey_id from question table and add new table something like SurveyQuestions which would be connection between question and survey (obviously) and it will have survey_id and question_id and answer_id with composite primary key, so basically classical many-to-many relationship. In that case you could have hardcoded question in db and just insert into SurveyQuestion which survey which question and which answer.

nglogic