How to design database for a project

[@abhishekvishwakarma9045]

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🔥

[@BBarters]

Glad to be of help !

[@OkayBrotherSister]

Same in my case

[@fishlabsonline]

Dude... I'm mind blown by what you illustrated. Just wow

[@BBarters]

Glad you found it useful.

[@hrushikeshkhonde8597]

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

[@danielmadison4451]

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.

[@Lucky-jm5if]

ur questions is related to front end and this is all back end stuff....

[@saunved]

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.

[@lingxu9697]

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

[@sase1017]

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

[@OmPrakash-ot3nr]

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.

[@BBarters]

Glad it was helpful!

[@rakeshnarang8545]

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

[@SirMika9]

Hi, where is the next video you talk about ?

[@TechMedia-it]

Thanks so much for this beautifully explained Video!

[@NishantSharma-sz5xh]

take care of your baby

[@sushantkumar8903]

Crisp clear and very helpful... thanks

[@BBarters]

Glad it was helpful!

[@briancalma5674]

Dude you nailed it!

[@Ahmad-ww4ue]

This is pure gold! Chapeau 🎩

[@backendninja8333]

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?

[@sandeepraul7261]

Got to learn some new things.. thanks!

[@BBarters]

Happy to help!

[@manavdeepsinghgrable]

Can I get link to more videos like this.

[@vrushangdesai2813]

Thank you so much bro , love this video :)

[@BBarters]

Glad you found it useful

[@ayushmankumar7]

This video is helpful. Well Explained!

[@BBarters]

Glad it was helpful!

[@sumanmodak1846]

excellent explaination

[@namratanagvekar6857]

Smooth explanation

[@skullcode8856]

Great explanation

[@saurebhkadaam20]

where is 2nd part of the video? counldnt find it!

[@Noritoshi-r8m]

Fenomenal lecture, ty very much! What's the link to the next video to this one? I cant find it in your channel

[@engsiyad]

I love it. Waiting for the next lesson

[@BBarters]

Thank you for your kind words. I will surely put the next one soon.

[@gkarki3]

@@BBarters sir can you provide me sprint security pdf file . can you also recommend good website and video for creating web app in grails.

[@ng4logic]

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.

[@meetcharola3624]

Thanks Alot.

[@ramchinthakayala2092]

Really useful video

[@BBarters]

Thanks a lot, I am happy that it was useful for you.

[@zaccomusic]

good video hope you keep update :)

[@BBarters]

Thank you, I will

[@tanvirhasanmonir1627]

Great video. Thank you so much.

[@BBarters]

Glad it was helpful!

[@solehahrafi8514]

THANK YOU! Where can i find the next video for ERD?

[@BBarters]

Will upload that one soon.

[@skullcode8856]

@@BBarters Is it uploaded now?

[@SPR1326]

This is very useful! Where is the following video?

[@poojanagaramunnolli]

Thank you, its informative and helpful. Can you please tell me the schema of this database design is in which data model created?

[@codewithabdulrafay]

Well explained.. 👍

[@BBarters]

Glad you liked it

[@ZakirHussain-ig4yv]

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.

[@sharaths3464]

Very good explanation ,Bro. Waiting for your next video on ER Diagram?

[@kellylewis5907]

good video!

[@BBarters]

Glad you liked it!

[@ramesh5643]

Very well explained. Can you pleàse also how to model the data into dimensions and facts please?

[@wadeshobbies]

is it reasonable to put product_id on the survey table, and then use productSurvey to capture the current survey for a product?

[@mugaigabenjaminj1736]

how do i access the next vedeos have tried to understand

[@skullcode8856]

in 17:26 the entity survey_id in question would get affected and we can no longer make a join between question and surverys

[@papachoudhary5482]

Thanks! Sir

[@sudiptamukherjee8216]

please can any one clarify how to list out all entities???

[@kasdal]

Is there a second part to this video? I could not find it. @BBarters. Thank you. Great video btw.

[@BBarters]

So far only one, I plan to make a couple more soon. Thank you for your kind words.

[@kasdal]

@@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?

[@kasdal]

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?

[@carrot5040]

Thanks

[@DesignStrong]

Good video. Hope I will also get similar traction on my videos

[@Sh1r449]

Thank you

[@realme-pl3po]

is the second video uploaded yet??

[@BBarters]

Sadly no. Will work on that.

[@AR-ok2qt]

00:42 The Sooner you start coding, the later you finish it !

[@viks599]

Response table is wasting data storage by having response text left vacant for objective questions !

[@godgst210]

Write the steps to design a database ? Please replay

[@SudhirKumar-rl4wt]

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.

[@Amrrkevin]

7:00