I Searched lot of videos Related to Many to Many in Data base much helpful for me after Searching I found This channel Unique Concepts, Unique Understanding and Confidently answer
The lucidity of this content is refreshing. A book with related subjects expanded my mental horizons. "The Art of Meaningful Relationships in the 21st Century" by Leo Flint
@@SaghirSchool I'm pretty sure it was a bot promoting whatever stupid book it was promoting by searching up videos that contain the word "relationship(s)" in the title and copypasting this message lmao. that, or it was an actual human, doing work for pennies.
Please correct me if I am wrong the representation which you have used is not for Relational Model right. So to which model such representation belongs? Kindly tell me.
Sir, how can i show Record in the Report of a Student From two or more tables like Student Table Subject Tables and marks table (marks table has lot of test marks. mean that a student record of last month Daily test system for show him or for show his parents when they visit his school after a month.
In many to many relationship we created a new linking table.Now both author table and book table contain any of of the information of the other table.So how can we connect both table without the any of the information???
The one to many example does not make sense to me. What if one customer purchased several items in one order and also made several orders in the past year? Wouldn't then a many to many relationship be true?
It's one to many because say you check out at Amazon even if you buy multiple items, at checkout that order with multiple items will still be labelled order XBHYTAJ. After that, you could still make another order with other items and at checkout it'll be labelled maybe BHTFWH..Now that orderID can only have one customer but the same customer can have another order again with a different OrderID and the cycle goes on ...Hope it's more clear
Correct and proper Explanation Thanks Buddy u saved the day🙌
I Searched lot of videos Related to Many to Many in Data base much helpful for me after Searching I found This channel
Unique Concepts, Unique Understanding and Confidently answer
well appreciated younus , kindly share this channel to your class fellows that wil be abig help
Thank you Saghir, you help me a lot. Honest review from me
clear and concise. Thank you!
Very useful. Thank you!
Well explained. Very helpful
sound absolutely ecstatic mate
Awesome job, man!
Well explained. This is how I study for acess theory test
Really great content
The lucidity of this content is refreshing. A book with related subjects expanded my mental horizons. "The Art of Meaningful Relationships in the 21st Century" by Leo Flint
plz share , will be a great help to the channel
@@SaghirSchool I'm pretty sure it was a bot promoting whatever stupid book it was promoting by searching up videos that contain the word "relationship(s)" in the title and copypasting this message lmao. that, or it was an actual human, doing work for pennies.
thank you so much, this was really helpful!!
well done. thank you sir 👍👍👍👍👍
best video so far
Thanks for the video and what can mostly use one to one relationship right or not please tell me
It's really helpful. Thanks
Thank you for your explanation sir! I hope I can ace my test tomorrow
thank u so much , plewase share it woth the class as well tt llll be a favour to me
Bro, you really great today i have great mindset and great tutor, thanks so much ❤️✌🏻
this was really helpful
thank you
what is the sql query to display the new table with writerID and bookID (in many to many)
Amazing video
thank you so much very helpful❤❤❤❤
Could you please post SQL examples of one to one relationshp? or implemented in PgAdmin or MySQL Admin?
Thank you so much😇
Excellent sir.
🥺kitne acchese samjhaya yaar🥺udemy k courses fail h is video k aage😊
plz share with ur class
Thanks, please upload more.
sure whct topics u want me to make videos on
Very well explained with reference to Normalization.
thank you!
Good information
Please correct me if I am wrong the representation which you have used is not for Relational Model right.
So to which model such representation belongs?
Kindly tell me.
Short and sweet
A big thanks thanks to u sir
Very nicely explained 🙂🙂
well appreciated Ayush , kindly share this channel to your class fellows that wil be abig help
thanks very useful
Sir,
how can i show Record in the Report of a Student From two or more tables like Student Table Subject Tables and marks table (marks table has lot of test marks. mean that a student record of last month Daily test system for show him or for show his parents when they visit his school after a month.
Thanks I understood well.
Glad it helped!plz share this around , will b a great help
In many to many relationship we created a new linking table.Now both author table and book table contain any of of the information of the other table.So how can we connect both table without the any of the information???
Superb class
Thank you
mujik narmanli chiqibdi
nice
Write a query on each table
thank you
Many to Many
WriterId & BookId are foreign keys in the linking table because they are primary keys in the writer and Book table?
no
Sir are you from Karachi Pakistan.
The one to many example does not make sense to me. What if one customer purchased several items in one order and also made several orders in the past year? Wouldn't then a many to many relationship be true?
it's one customer, so it'd still be one to many :)
It's one to many because say you check out at Amazon even if you buy multiple items, at checkout that order with multiple items will still be labelled order XBHYTAJ. After that, you could still make another order with other items and at checkout it'll be labelled maybe BHTFWH..Now that orderID can only have one customer but the same customer can have another order again with a different OrderID and the cycle goes on ...Hope it's more clear
Nicely explained sir
well appreciated Rudra , kindly share this channel to your class fellows that wil be abig help
thank you bhai
Would this be a one to many relationship, a bursary can be awarded to many students?
depends if bursary is awarded multiple times
How is writer to books many to many. Are you assuming a book can have multile authors?
Tons of books do have multiple authors, what’s your point?🤨
I feel it's one to many
Books can have multiple artists
1 book can have many authors
Yes, one book can have many authors.
But sir, 1 product can be ordered by many customers so shouldn't we use many to many in the scenario?
Yes, but this is a unique scenario.
its a unique order, not product
instagram.com/_saghir/ follow me there plz
Sir
I think in last eg.why is it 1:1 relationship
Bcz one person have many accounts so maybe it is 1:m relationship
👏
Software?
for database starters i would recommend dbbrowser
Bro, linking table is also maping table???
yes brother it is
Boss
So many BIG no-no's
😂😂😂😂😭😭😭
Good job but can you talk just a wee bit slower.
I deserve million of subscribers
Bhai Hindi mein bol na
ruclips.net/video/Ag3bcBaSsHA/видео.html
IM HINDI FOR U DEAR,PLZ SHARE