Videos like this are way more useful than the other bog standard stuff that litters the web - rather than over-explaining 'how to query a, b, c, d and e', your videos cover the more important fundamentals like how to design relational databases properly. The querying can just be googled as you develop, but leaning how to design a database cannot be googled so easily. Thank you
I like your video. I have been studying databases for some time, and I've come across tutorial project videos on RU-vid. This is one of the best videos on designing databases on RU-vid!!!
your video was absolutely helpful compared to class lectures about database management, do you have anything on how to design (even with pen and paper) other kind of relationship between tables? Thanks a lot!
Thanks! I've got a couple of videos on my channel about many to many relationships, and one to many relationships. I've also got quite a few examples of designing a database, such as AirBNB or Instagram or school management.
Hi there, thanks for this! I was wondering how we can do with multiple patients at the same time, perhaps create a separate table of patients and how will we identify other patients from that table list?
Glad it helped! Yes, you would have a separate table in between patients and appointments to store the patients for each appointment, as it is now a "many to many" relationship.
@@DatabaseStar You're welcome...Words can't express how happy I felt when j went through some of your database videos...They were so helpful. Good job sir🙌
I am trying to learn something. Lets say someone gives me some requirements how can i make a DB based on that. Or if have a DB how can i change it if somethng happnes therre must be some rules or theory. Like Pivot tables that connect 2 tables etc
This video shows you how to create a database design from an idea or from requirements. I've got a few other examples on how to do this on my channel as well. If you have a database and you need to change something, you would follow the same process. But it may be more complicated as you need to understand what is happening at the moment.
@@DatabaseStar I think i need to Learn about 1-1, 1-N, N-1, N-N and when to use join table "pivot table". I think when 1-1 use foreign keys for everything else pivot table but i don't know how exactly. And i need learn normalization.
