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.
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
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!
"The sooner you start coding, the later you finish" haha
Dude... I'm mind blown by what you illustrated. Just wow
Glad you found it useful.
Thank you sir ! I was afraiding to step forward to create db but... Now I am starting.... 😌
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
This is pure gold! Chapeau 🎩
Dude you nailed it!
Thanks so much for this beautifully explained Video!
take care of your baby
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.
Crisp clear and very helpful... thanks
Glad it was helpful!
Thank you so much bro , love this video :)
Glad you found it useful
Got to learn some new things.. thanks!
Happy to help!
Great video. Thank you so much.
Glad it was helpful!
This video is helpful. Well Explained!
Glad it was helpful!
Great explanation
Smooth explanation
Very good explanation ,Bro.
Waiting for your next video on ER Diagram?
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 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.
excellent explaination
Thanks Alot.
Very well explained. Can you pleàse also how to model the data into dimensions and facts please?
Thanks! Sir
Well explained.. 👍
Glad you liked it
Thank you
good video
hope you keep update :)
Thank you, I will
Really useful video
Thanks a lot, I am happy that it was useful for you.
good video!
Glad you liked it!
Fenomenal lecture, ty very much! What's the link to the next video to this one? I cant find it in your channel
This is very useful! Where is the following video?
Thanks
Thank you, its informative and helpful. Can you please tell me the schema of this database design is in which data model created?
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.
Good video. Hope I will also get similar traction on my videos
Can I get link to more videos like this.
is it reasonable to put product_id on the survey table, and then use productSurvey to capture the current survey for a product?
THANK YOU! Where can i find the next video for ERD?
Will upload that one soon.
@@BBarters Is it uploaded now?
in 17:26 the entity survey_id in question would get affected and we can no longer make a join between question and surverys
where is 2nd part of the video?
counldnt find it!
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.
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?
please can any one clarify how to list out all entities???
Hi, where is the next video you talk about ?
how do i access the next vedeos
have tried to understand
00:42 The Sooner you start coding, the later you finish it !
Response table is wasting data storage by having response text left vacant for objective questions !
is the second video uploaded yet??
Sadly no. Will work on that.
Write the steps to design a database ? Please replay
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.
7:00