In this video, we discuss the process of correctly designing the RDBMS database for a software project. Download the session ppts here: docs.google.com/presentation/...
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🔥
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
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.
Yeah, I felt the same way while watching the video. However, he has handled this use case well. Looking at the tables, you can see a 1 to many relationship between question => answer tables. That is, one question can have multiple choices (if it is an objective question). So when fetching the question from the database, you can also fetch all the options referred to by question_id in the Answer table.
What if I want to use Agile where there is no such thing called "functional requirements". Instead it has "User Stories". Then how can I design my database from user stories?
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.
If one product won't have multiple surveys at the same time then you don't need product_survey table, only product table would be enough with a extra column survey_id.
@@BBarters Thank you for responding. Quick question tho if you got the time. I have a hard time understanding the responder object. How does it relate to the other components?
I was in impression that this application also makes sure that a particular product is first purchased by an user before participating in the survey..that doesnot seem to be taken care here.
"The sooner you start coding, the later you finish" haha
This video is the best dw video for de interview that I saw on youtube so far, thanks
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🔥
Glad to be of help !
Same in my case
Dude... I'm mind blown by what you illustrated. Just wow
Glad you found it useful.
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
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.
Glad it was helpful!
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.
ur questions is related to front end and this is all back end stuff....
Yeah, I felt the same way while watching the video. However, he has handled this use case well.
Looking at the tables, you can see a 1 to many relationship between question => answer tables. That is, one question can have multiple choices (if it is an objective question). So when fetching the question from the database, you can also fetch all the options referred to by question_id in the Answer table.
Thank you sir ! I was afraiding to step forward to create db but... Now I am starting.... 😌
Dude you nailed it!
This is pure gold! Chapeau 🎩
Thanks so much for this beautifully explained Video!
take care of your baby
Very good explanation ,Bro.
Waiting for your next video on ER Diagram?
Crisp clear and very helpful... thanks
Glad it was helpful!
Smooth explanation
Great explanation
What if I want to use Agile where there is no such thing called "functional requirements". Instead it has "User Stories". Then how can I design my database from user stories?
Thank you so much bro , love this video :)
Glad you found it useful
Very well explained. Can you pleàse also how to model the data into dimensions and facts please?
Got to learn some new things.. thanks!
Happy to help!
excellent explaination
This video is helpful. Well Explained!
Glad it was helpful!
Great video. Thank you so much.
Glad it was helpful!
I love it. Waiting for the next lesson
Thank you for your kind words. I will surely put the next one soon.
@@BBarters sir can you provide me sprint security pdf file . can you also recommend good website and video for creating web app in grails.
Fenomenal lecture, ty very much! What's the link to the next video to this one? I cant find it in your channel
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.
Thanks! Sir
Thanks Alot.
good video
hope you keep update :)
Thank you, I will
This is very useful! Where is the following video?
Well explained.. 👍
Glad you liked it
Thank you
Thank you, its informative and helpful. Can you please tell me the schema of this database design is in which data model created?
Can I get link to more videos like this.
If one product won't have multiple surveys at the same time then you don't need product_survey table, only product table would be enough with a extra column survey_id.
Really useful video
Thanks a lot, I am happy that it was useful for you.
good video!
Glad you liked it!
is it reasonable to put product_id on the survey table, and then use productSurvey to capture the current survey for a product?
where is 2nd part of the video?
counldnt find it!
Good video. Hope I will also get similar traction on my videos
THANK YOU! Where can i find the next video for ERD?
Will upload that one soon.
@@BBarters Is it uploaded now?
Thanks
in 17:26 the entity survey_id in question would get affected and we can no longer make a join between question and surverys
Hi, where is the next video you talk about ?
Is there a second part to this video? I could not find it. @BBarters. Thank you.
Great video btw.
So far only one, I plan to make a couple more soon. Thank you for your kind words.
@@BBarters Thank you for responding. Quick question tho if you got the time. I have a hard time understanding the responder object. How does it relate to the other components?
In case im not clear, does it stand by it's own or do we need to map it with components with whom it shares PK?
how do i access the next vedeos
have tried to understand
please can any one clarify how to list out all entities???
00:42 The Sooner you start coding, the later you finish it !
Write the steps to design a database ? Please replay
Response table is wasting data storage by having response text left vacant for objective questions !
I was in impression that this application also makes sure that a particular product is first purchased by an user before participating in the survey..that doesnot seem to be taken care here.
is the second video uploaded yet??
Sadly no. Will work on that.
7:00