relational model in dbms | DBMS | Lec-15 | Bhanu Priya

[@chandragupta6573]

Revision Notes: Relation: A Relation is a table with rows and columns It is based on mathematical concept of relation which is represented physically as table. It is used for data storage and processing. Table = Relation Column Header/Fields = Attributes Column Values = Domains Row = Tuple Table definition =Schema of relation Degree of relation = No. of attributes present = No. of columns Cardinality of relation = No. of tuples present = No. of rows Properties: 1. Table has unique name. 2. Each cell/domain should contain only value. 3. Each attribute/column should have unique name. 4. Each tuple should be distinct(completely) 5. Order of attributes has no significance. 6. Order of tuples has no significance. Thank You.

[@twinkles2991]

Thank u so much

[@movieshub4775]

Thanks

[@ahsaasdhuria9552]

Thank you so much

[@litttjacob4312]

thanks bro !

[@techemission6069]

thanks man

[@DESTINIA-cf7iu]

Not all the Teachers in English explain difficult concepts of the same way. You´re a talent. Thanks !

[@gideonkipyegon]

Thanks once again, your lecture have made my course enjoyable, following from Kirinyaga University in Kenya🙏

[@kodarkma7444]

💪💪💪From the same country, but at Kabarak University(NAKURU)

[@sunnylk6991]

You are absolutely the best teacher for this on youtube. I really appreciate your help. Thank you!

[@myfirstcreation2612]

Super

[@chethanb6406]

but her english is bad

[@dynamite-ka-payment-dede-plz]

Gg simp

[@vikramsarabhai1]

This is a really -really good explanation. Thank you for taking the time to make this video.

[@nasirabbas936]

Madam your lectures are really appropriateable I salute you from Gilgit-Baltistan

[@wigglesworth8296]

Best Explanation.Thanking Jesus Christ for giving talents through grace

[@wigglesworth8296]

@Aditi Giri Yep It's True

[@Shanigupta111]

Praise the lord

[@CrittiZops]

Jay Shree Ram 🙏🏻❤️

[@janv7905]

Thanks for constantly repeating the words. It sticks more in my head.

[@RRTrader_512]

All understand . Awesome teaching 🙏🙏🙏🙏

[@yrohit600]

cardinality refers to the uniqueness of data values contained in a column. High cardinality means that the column contains a large percentage of totally unique values. Low cardinality means that the column contains a lot of “repeats” in its data range

[@Subhasini_Sethi]

Are you confirm that you right ???

[@yrohit600]

Yes..

[@Subhasini_Sethi]

Thanks 😊

[@pandeyvisuar]

Heyy bruhh ...cardinality means ..the arrangements of one sets entity with its relationship model...it may be one to one ..many to one...or more...it sometime it represent a uniqueness..but not...alwayss...

[@suganyadevi1574]

Really, it is awesome video, 👍, I will watch continuosly

[@asifck439]

i am looking for only this video. thank you so much for giving a wonderful class

[@rohithkumar2658]

Really giving your best, excellent explanation....

[@ChernetTeklu]

I am really satisfied for your lecturing methods

[@glazykingswag7349]

This video was awesome thank you to make this video .i understand very well manner .

[@anjaliingle4302]

Nice content mam it is very easy to understand

[@RitikaSingh-ok3wf]

Best explanation ma'am.... Very helpful video 👍🙏

[@deepjyotkaurbindra]

This is a really good explanation. Thanks a lot.

[@chhavipatel3764]

Video was really helpful n easy to understand

[@hesaruwannigama2409]

Wow what an explanation it was... Thankyou ma'am

[@bryanchavez4886]

spent like a month watching lectures and didnt understand a thing. Watched this 15 min video and I get it. IF PROFESSORS TAUGHT THE WAY YOU DO.....

[@sridhardurairaj2317]

Thank you mam from bottom of the heart for uploading this video

[@keshabdeb2242]

Thanks i have very less doubts now Tomorrow I have exams of IT

[@osujipaul2244]

Thanks, Ma'am for the clear explanation

[@techfair3617]

i am from bangladesh. now i am clear on it. thank you so much.

[@chandugupta6006]

Very nice video maim ,very easy way to teach us

[@manianeja7107]

Thankyou. You make it very easy.

[@dandusaikishore9184]

Thanks a lot , explanation is fantastic

[@javatime2763]

wow thanks for all infomation

[@balramkoirala4601]

thank you so much ma'am..very helpful

[@aryanraghu5344]

Tq u mam ur way of teaching z very simple and easy..!

[@anjalisahu1909]

Thanks Alot mam for this video 😀😊😇🤓

[@vishnudhonthu9912]

Nice explanation mam

[@mantashakhan9609]

Really vry gud explanation is ur's

[@gamingknowledgecombo8775]

nicely explained now it seems easy for me

[@bibinmathew6978]

Well explained! I would like to point out one mistake. Cardinality is not the no of rows in a table, it is the no of distinct values in a column.

[@educatedabhishek]

Bakwaas admi ho tm

[@anashashmi5724]

no, it's number of rows in table she's right

[@bibinmathew6978]

@@anashashmi5724 please check the explanation. For example, if column gender has male and female as values. Then it’s cardinality is 2 though it may have 100+ rows

[@bibinmathew6978]

@@educatedabhishek your username should change to “educate abhishek”

[@jasmineiqubal8296]

​@@bibinmathew6978 😂😂😂😂

[@abdullahiahmed7077]

Am very happy with your lectures

[@abdullahiahmed7077]

Get me your email please

[@abdullahiahmed7077]

Which answer please

[@abdullahiahmed7077]

I understand only English please

[@gudejeevan]

Mam explain about various data models exists for database? What is structured and semi structured datebase? What is data modeling and explain different types of data modeling? Plz explain above 3 questions

[@shivakumardoddamani1700]

Optimal speed - 1.5x Thank me later.

[@harshidatanku795]

Bro I always do that 😂😂

[@akshayajayagandhan2219]

Thanks dude...really worked out!

[@ahmadqureshi1071]

Dude💕

[@soptorshibhattacharjee2824]

Me watching the video in 2x speed - "I am speed"

[@arrapavankumar9667]

It worked perfectly with 1.25

[@pavanpavan5266]

I am a Big Fan og You Madam. Your explanation was awesome. I am Waiting for Your Reply Mam

[@ismailsk2348]

I am very happy because your class superb and could you explain spring and spring boot concepts

[@miguelmarcelino2449]

Great Idea!

[@rambabudasari958]

Thank u nice explain

[@thejusv.s672]

We understand it well.. Thank you

[@vaibhavlodha5717]

Thank you ma'am You are so good at teaching.. Best explanation

[@najiaibrahim4926]

Ty soooooo much.u said very well👌👌👍👍👏

[@payalgupta9622]

Hello Sir, Pls tell me some projects Which can be built only using SQL??

[@zhgaaaaaan]

hi thx for your effort , in number 2 12:18 what if store json in the colume this note on value i can contain many value

[@joeljames1796]

Best explanation 👏👏

[@vamsikrishnaattina5059]

Tq❤️ madam for your teaching

[@pelegred6123]

Good lesson, thanks

[@mohamadezat5713]

really helpful Thank u so much

[@varshashibu1583]

Good explanation

[@HaHA-tn3bf]

Kamal kr dia mam bohat ala samjaha

[@greshmalankalapalli4930]

It is easy to understand 😁😁😁

[@henrykaweche3372]

Very easy

[@ALOK_MALAKAR]

Thanks a lot... Continue man

[@vinodbheem3722]

Is this content helpfull for our public exams

[@warisafghan4211]

Thank you ma'am from Afghanistan

[@sujitsatpute3741]

Very nice mam❤️🙏

[@peralagouthami1564]

it is easy to understand thankq mam

[@AIHauntedHorizons-e3g]

very helpfull thanks

[@JatinMathuria-w7r]

didi aapki english itni acchi hai na🥹🤌✨(sarcastic)

[@pradnyabavdekar8674]

Nice.... Carry on

[@SyedDanishTech]

nice content, keep it up.

[@VivekSharma-rf8kf]

Mam this us a use of my sql

[@brijeshgurung8300]

what do we do when we have similar data but need to create a relation ? since the properties say there shouldn't be any duplicate tuple?

[@jackieroberts4868]

DEnormalization

[@shrutitutorial2005]

Tnx mam...🙂 For the video..

[@ofosuhenebelinda8163]

Thanks soo much ✍️👏

[@AbdulWahid-ct4ji]

Good 😊 mam

[@manisharathore6509]

Very hlpfull

[@sabylsaybl3002]

Good teacher

[@m22d52]

специально, искусственно усложнять себе работу и считать это работой

[@fattahjamil2452]

Nice lactute☺

[@zainabansari573]

Thanks a lottt maam🙂

[@kachrabatli174]

Thanks for video

[@RRNJSS]

good

[@yashkutty4422]

Super madam

[@TanayBhandare]

mam plzz do your lecture in marathi or hindi

[@mr.technical6581]

Nice video

[@charlesdaniel9459]

If there is no primary key then point 4 is possible

[@venip9106]

Pls upload relational data model in language topic

[@aswin6261]

Thank you ☺️

[@rudrapranay1441]

your teaching is good but you might have opted a good red pen

[@yogish053]

Thank you mam❤

[@abhi4463]

is there any way to get into touch with you madam? i have a query regarding a competitive exam of IT in my state. need some guidance from you.. reply fast asap... thank you

[@akashbhagat3125]

Man can u suggest a Good book for DBMS pls...

[@gajam7511]

I can't understand in order of attributes no significance. And Order of tuple has no significance. Plz explain mam.

[@gideonkalema5708]

using the basic language or informal terms, the order of rows and columns has no significance or doesn't matter its all up to you creating the table AKA relation

[@SyedDanishTech]

agr hmare paas 2 ya 3 tables hain tou hm degree aur cardinality kese findout krien ge

[@aqdasarooj5070]

Use some hindi/urdu words.... Baki ollll good...

[@KSDFIRE]

Mam rows la salary same na same data thane varum

[@mdshahmiran912]

Nice mam

[@pushpanjalidabade7507]

Nice

[@SaadKhan-ht1uy]

Thank you :)

[@sumit7284]

nice

[@CinephileO7]

can we get these notes that you are writing in the video?

[@aravindkr6078]

5star explanation

[@naziyashaikh9747]

Thank you mam

[@ismailsk2348]

Asalamu walikum warahamatulahe wabarkathahu naziya ji

[@srinithi7757]

Thank u mam 😊

[@komal-cz5wp]

What is range ?

[@RajeshKumar-yz9gt]

Thanks ma'am

[@GRIMRAJ]

CA module is saying different ....records , key, cardinality are not explained by you