ER Diagram for Orders Details and Customers Tables in eCommerce Web Application

[@ajbotha7232]

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 !!!!!!!!

[@mrsneaky3393]

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

[@shadsluiter]

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?

[@abdulrahmanismailali1064]

@@shadsluiter Can you help me

[@lucasdiconcilio]

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!!

[@infohub3709]

Wow.. Wow.. Wow... Thanks so much for this. I really learnt a lot.

[@kaankosti1279]

Sir you are amazing sir.I love you sir.

[@rajneesh19852]

Thanks Shad. Good explanation, Its really helpful. Can you also explain Db design for subscription based services.

[@michaelg7905]

This video was very helpful. Thank you sir!

[@jeanwill69]

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

[@jasperhawkes1588]

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?

[@moabbas5525]

This is awesome!!!!!! thank you so much

[@takeshikriang]

This is very helpful. Thank you, sir.

[@shadsluiter]

So nice of you

[@jampyapplicationbuilder]

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

[@telur_dadar]

Hi Shad, wanna ask what is the meaning of ID In OrderItem table?

[@FayisaTesfaye-l8r]

Can you helping afew Assignment database about solving problems

[@shobhitmittal77]

This was very useful, Thanks a lot 😀

[@carloscuevas9475]

Good video. Thanks for sharing!

[@Michael-bm1jr]

Thanks...is it possible to make some tutorials on how to make UML as well. if it's not too much to ask

[@shadsluiter]

Here is one kzbin.info/www/bejne/hIOugZeDrqmDqtU or here kzbin.info/www/bejne/aWWspWyFrNmgbtU

[@Michael-bm1jr]

@@shadsluiter How did i miss those videos !!!!...Thank you so much 🙏

[@jn01996]

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]

There should be a one relation between the tables. One table should have a link to the other table's primary key.

[@jn01996]

@@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 KZbin so I will try to ask my own teacher about it

[@jn01996]

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?

[@kakosnaki]

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.

[@arefeghbali3914]

Great Video, but how can I implement this in code? is there any tutorials that you can reference me to?

[@davidrosen2705]

you can build it with django models for example

[@TheMrsjacoblautner]

so helpful thank you!!

[@stannisbarracuda5693]

great vid sir

[@shadsluiter]

Much appreciated

[@hanasschoolwork4564]

Awesome :)

[@parisforyou75]

not useful. no explanation on cardinality, modality