DBMS 1 to many,many to many,1 to 1 relationships

DBMS 1 to many,many to many,1 to 1 relationships

[@arunagiriak959]

Correct and proper Explanation Thanks Buddy u saved the day🙌

[@younus.athlete]

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

[@SaghirSchool]

well appreciated younus , kindly share this channel to your class fellows that wil be abig help

[@garudabowo]

Thank you Saghir, you help me a lot. Honest review from me

[@INSANEARTsain38]

what is the sql query to display the new table with writerID and bookID (in many to many)

[@shubhamkale5003]

Well explained. Very helpful

[@JoeM370]

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]

plz share , will be a great help to the channel

[@thisrandomdude_]

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

[@jasonxdmli4403]

sound absolutely ecstatic mate

[@xiongbenjamin]

clear and concise. Thank you!

[@dartherus]

Could you please post SQL examples of one to one relationshp? or implemented in PgAdmin or MySQL Admin?

[@solomonautuvai2479]

Well explained. This is how I study for acess theory test

[@clinkzoi5529]

well done. thank you sir 👍👍👍👍👍

[@Juan-Hdez]

Very useful. Thank you!

[@teamit5538]

Thank you for your explanation sir! I hope I can ace my test tomorrow

[@SaghirSchool]

thank u so much , plewase share it woth the class as well tt llll be a favour to me

[@rakeshthakur9403]

Thanks for the video and what can mostly use one to one relationship right or not please tell me

[@holyage3128]

Awesome job, man!

[@vividhalade0992]

🥺kitne acchese samjhaya yaar🥺udemy k courses fail h is video k aage😊

[@SaghirSchool]

plz share with ur class

[@alimihakeem841]

It's really helpful. Thanks

[@thisrandomdude_]

thank you so much, this was really helpful!!

[@Sparshchokra]

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.

[@SabirAli-ho5rx]

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.

[@pranishn9683]

Bro, you really great today i have great mindset and great tutor, thanks so much ❤️✌🏻

[@n_ati]

this was really helpful

[@n_ati]

thank you

[@anandjoseph1732]

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

[@DevOmar-id2ns]

thank you so much very helpful❤❤❤❤

[@ibrahimjamil3155]

best video so far

[@ahmedali3017]

Excellent sir.

[@cristinocanga]

Really great content

[@alamihanae8794]

A big thanks thanks to u sir

[@mrrelentless8339]

Amazing video

[@krishnareddy3621]

Good information

[@growtogether8014]

Very well explained with reference to Normalization.

[@hassanrj3406]

Sir are you from Karachi Pakistan.

[@ajitathare]

Thank you so much😇

[@kvelez]

Thanks, please upload more.

[@SaghirSchool]

sure whct topics u want me to make videos on

[@GoodDeedsLeadTo]

Many to Many
WriterId & BookId are foreign keys in the linking table because they are primary keys in the writer and Book table?

[@umeshshelke725]

no

[@PersonOfBook]

How is writer to books many to many. Are you assuming a book can have multile authors?

[@vicyet6002]

Tons of books do have multiple authors, what’s your point?🤨

[@nischitapatil7230]

I feel it's one to many

[@osxs333__7]

Books can have multiple artists

[@kryptons-galaxy]

1 book can have many authors

[@nareskanthmohan449]

Yes, one book can have many authors.

[@suyunovjasurbek]

mujik narmanli chiqibdi

[@biswaranjansahoo1713]

Superb class

[@ayushanish9636]

Very nicely explained 🙂🙂

[@SaghirSchool]

well appreciated Ayush , kindly share this channel to your class fellows that wil be abig help

[@princemurali5509]

Short and sweet

[@Adriane_Deathscythe]

thanks very useful

[@vivianeb90]

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?

[@mvs69]

it's one customer, so it'd still be one to many :)

[@emalibella1228]

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

[@darklord11269]

thank you!

[@vinaydadi1297]

Write a query on each table

[@xayrullayevzafar]

Thank you

[@HussainAl-ahmdi]

Thanks I understood well.

[@SaghirSchool]

Glad it helped!plz share this around , will b a great help

[@luyandamtshali9386]

Would this be a one to many relationship, a bursary can be awarded to many students?

[@SaghirSchool]

depends if bursary is awarded multiple times

[@shubhamkothekar4694]

Software?

[@SaghirSchool]

for database starters i would recommend dbbrowser

[@awaismadni623]

thank you bhai

[@motivideosevd]

But sir, 1 product can be ordered by many customers so shouldn't we use many to many in the scenario?

[@maureenoguche5064]

Yes, but this is a unique scenario.

[@KonstantinosPappasGreekSkater]

its a unique order, not product

[@rizwanshah8784]

thank you

[@rudravishalupadhyay680]

Nicely explained sir

[@SaghirSchool]

well appreciated Rudra , kindly share this channel to your class fellows that wil be abig help

[@vyshnavkpi]

Bro, linking table is also maping table???

[@SaghirSchool]

yes brother it is

[@kamalkumarchaudhary2107]

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

[@anuragsrivastava5651]

nice

[@tenebrae1191]

👏

[@randomfellowhumanhere]

Boss

[@SaghirSchool]

instagram.com/_saghir/ follow me there plz

[@SisHattie]

Good job but can you talk just a wee bit slower.

[@BimoliRam]

I deserve million of subscribers

[@usmansafk]

So many BIG no-no's

[@umaiszia2291]

😂😂😂😂😭😭😭

[@bharatguy]

Bhai Hindi mein bol na

[@SaghirSchool]

th-cam.com/video/Ag3bcBaSsHA/w-d-xo.html

[@SaghirSchool]

IM HINDI FOR U DEAR,PLZ SHARE