Hi Shad, I am a 21 year old software developer. My project is really easy if the database is designed is done perfectly. This helped a lot, thank you I think you don't get the appreciation that you deserve. You rock man !!!!!!!!
Have watched many tutorial and still confused, your explanation of order and order_detail table along with what relationship it has is just perfect, thanks
Good to hear. I usually don't understand someone when they use a bunch of terms that don't mean anything to me yet. I need to see an example. Are you working on a school project?
Thank you so much! I'm working on the final project for my database class and I ran into this orderItem problem, your video explained everything, thanks!!
Hi I am just wondering about the totals, if I was after the price per item & gst as well as overall price & gst, would there be variables in both the orders and orderdetails table?
Hi Shad, Wondering if you will tackle eventually the none relational database or noSql like MongoDb ? How can we have the same kind of results with this MongoDB technology ? I think would be very interesting as well for all your followers. Best, Jean
Hi there, great stuff! Thanks for that. If interested, there is an on-line NorthWind application on PA. Which is made with absolutely no effort in about 3 hours. Pls let me know what think of it! Thx
If we have two tables connected to eachother using a foreign key is it always the case that each table should have a column that includes a foreign key of the opposite table? Or is it enough if only one table has a column with a foreign key and the other doesn't need such column? In other words can a parent table be also a child for the second table (when only two tables exist)
@@shadsluiter thanks for your time but your answer doesn't clarify my question. I appreciate that it might be difficult for you to do it via UA-cam so I will try to ask my own teacher about it
So just to make sure that I understand the relationships between tables correctly I will use a real-world example: I am married so I have a one to one relationship with my partner (no one is cheating in this relationship) I am married but my partner has cheated on me so it's one to many relationship for my partner but it's still one to one relationship for me (I don't think that would work in SQL) I live in an open relation so I have many to many relationship (me and my partner have other partners) Did I get the idea right using this trivial analogy?
There are multiple option, but you and your partner would always belong under person table: 1. For the first example you can have a person table that has a field relation_person_id that references other person. This would model would not allow documenting any cheating. It would also not track previous relationships. 2. You can have 2 tables person and being_in_relationship. being_in_relationship table has fields id, person1_id and person2_id. This should be the best option overall. 3. You can have 3 tables person, being_in_relationship and relationship. This would be a many-to-many. This might be good for harems where the number of people in a relationship is not defined. This would allow people to join existing relationships. This has some problems with it being able to have a relationship between no one or with yourself. Also having the man of the relationship die will make the relationship status complicated.
Hi Shad, I am a 21 year old software developer. My project is really easy if the database is designed is done perfectly. This helped a lot, thank you I think you don't get the appreciation that you deserve. You rock man !!!!!!!!
Have watched many tutorial and still confused, your explanation of order and order_detail table along with what relationship it has is just perfect, thanks
Good to hear. I usually don't understand someone when they use a bunch of terms that don't mean anything to me yet. I need to see an example. Are you working on a school project?
@@shadsluiter Can you help me
Thank you so much! I'm working on the final project for my database class and I ran into this orderItem problem, your video explained everything, thanks!!
Wow.. Wow.. Wow... Thanks so much for this. I really learnt a lot.
This video was very helpful. Thank you sir!
Hi I am just wondering about the totals, if I was after the price per item & gst as well as overall price & gst, would there be variables in both the orders and orderdetails table?
Sir you are amazing sir.I love you sir.
This is very helpful. Thank you, sir.
So nice of you
This is awesome!!!!!! thank you so much
Thanks Shad. Good explanation, Its really helpful. Can you also explain Db design for subscription based services.
Hi Shad, Wondering if you will tackle eventually the none relational database or noSql like MongoDb ? How can we have the same kind of results with this MongoDB technology ? I think would be very interesting as well for all your followers. Best, Jean
This was very useful, Thanks a lot 😀
Hi there, great stuff! Thanks for that. If interested, there is an on-line NorthWind application on PA. Which is made with absolutely no effort in about 3 hours. Pls let me know what think of it! Thx
Good video. Thanks for sharing!
Hi Shad, wanna ask what is the meaning of ID In OrderItem table?
If we have two tables connected to eachother using a foreign key is it always the case that each table should have a column that includes a foreign key of the opposite table? Or is it enough if only one table has a column with a foreign key and the other doesn't need such column?
In other words can a parent table be also a child for the second table (when only two tables exist)
There should be a one relation between the tables. One table should have a link to the other table's primary key.
@@shadsluiter thanks for your time but your answer doesn't clarify my question. I appreciate that it might be difficult for you to do it via UA-cam so I will try to ask my own teacher about it
Can you helping afew Assignment database about solving problems
so helpful thank you!!
Thanks...is it possible to make some tutorials on how to make UML as well. if it's not too much to ask
Here is one ua-cam.com/video/NRKPdMyDPts/v-deo.html or here ua-cam.com/video/34It9Owtm8s/v-deo.html
@@shadsluiter How did i miss those videos !!!!...Thank you so much 🙏
So just to make sure that I understand the relationships between tables correctly I will use a real-world example:
I am married so I have a one to one relationship with my partner (no one is cheating in this relationship)
I am married but my partner has cheated on me so it's one to many relationship for my partner but it's still one to one relationship for me (I don't think that would work in SQL)
I live in an open relation so I have many to many relationship (me and my partner have other partners)
Did I get the idea right using this trivial analogy?
There are multiple option, but you and your partner would always belong under person table:
1. For the first example you can have a person table that has a field relation_person_id that references other person. This would model would not allow documenting any cheating. It would also not track previous relationships.
2. You can have 2 tables person and being_in_relationship. being_in_relationship table has fields id, person1_id and person2_id. This should be the best option overall.
3. You can have 3 tables person, being_in_relationship and relationship. This would be a many-to-many. This might be good for harems where the number of people in a relationship is not defined. This would allow people to join existing relationships. This has some problems with it being able to have a relationship between no one or with yourself. Also having the man of the relationship die will make the relationship status complicated.
Great Video, but how can I implement this in code? is there any tutorials that you can reference me to?
you can build it with django models for example
great vid sir
Much appreciated
Awesome :)
not useful. no explanation on cardinality, modality