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.
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
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...
@@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
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
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
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
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.
Thank u so much
Thanks
Thank you so much
thanks bro !
thanks man
Not all the Teachers in English explain difficult concepts of the same way. You´re a talent. Thanks !
Thanks once again, your lecture have made my course enjoyable, following from Kirinyaga University in Kenya🙏
💪💪💪From the same country, but at Kabarak University(NAKURU)
This is a really -really good explanation.
Thank you for taking the time to make this video.
Madam your lectures are really appropriateable I salute you from Gilgit-Baltistan
You are absolutely the best teacher for this on youtube. I really appreciate your help. Thank you!
Super
but her english is bad
Gg simp
Best Explanation.Thanking Jesus Christ for giving talents through grace
@Aditi Giri Yep It's True
Praise the lord
Jay Shree Ram 🙏🏻❤️
Thanks for constantly repeating the words. It sticks more in my head.
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
Are you confirm that you right ???
Yes..
Thanks 😊
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...
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.....
I am really satisfied for your lecturing methods
Thanks i have very less doubts now
Tomorrow I have exams of IT
Optimal speed - 1.5x
Thank me later.
Bro I always do that 😂😂
Thanks dude...really worked out!
Dude💕
Me watching the video in 2x speed - "I am speed"
It worked perfectly with 1.25
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.
Bakwaas admi ho tm
no, it's number of rows in table
she's right
@@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
@@educatedabhishek your username should change to “educate abhishek”
@@bibinmathew6978 😂😂😂😂
Nice content mam it is very easy to understand
All understand . Awesome teaching 🙏🙏🙏🙏
i am looking for only this video. thank you so much for giving a wonderful class
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
This is a really good explanation. Thanks a lot.
Really giving your best, excellent explanation....
Thank u nice explain
Best explanation ma'am.... Very helpful video 👍🙏
Video was really helpful n easy to understand
Nice explanation mam
I am very happy because your class superb and could you explain spring and spring boot concepts
Great Idea!
Really, it is awesome video, 👍, I will watch continuosly
Thank you mam from bottom of the heart for uploading this video
This video was awesome thank you to make this video .i understand very well manner .
Good explanation
thank you so much ma'am..very helpful
Thanks, Ma'am for the clear explanation
Wow what an explanation it was... Thankyou ma'am
Hello Sir, Pls tell me some projects Which can be built only using SQL??
Thankyou. You make it very easy.
Thanks a lot , explanation is fantastic
Good lesson, thanks
i am from bangladesh. now i am clear on it. thank you so much.
wow thanks for all infomation
nicely explained now it seems easy for me
I am a Big Fan og You Madam. Your explanation was awesome. I am Waiting for Your Reply Mam
Very nice video maim ,very easy way to teach us
Thanks Alot mam for this video 😀😊😇🤓
Am very happy with your lectures
Get me your email please
Which answer please
I understand only English please
Man can u suggest a Good book for DBMS pls...
Really vry gud explanation is ur's
Kamal kr dia mam bohat ala samjaha
really helpful Thank u so much
Tq u mam ur way of teaching z very simple and easy..!
very helpfull thanks
Thanks a lot... Continue man
Thank you ma'am
You are so good at teaching..
Best explanation
Best explanation 👏👏
good
Nice.... Carry on
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
We understand it well.. Thank you
Very hlpfull
Is this content helpfull for our public exams
Ty soooooo much.u said very well👌👌👍👍👏
nice content, keep it up.
Good 😊 mam
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?
DEnormalization
it is easy to understand thankq mam
Thank you ma'am from Afghanistan
It is easy to understand
😁😁😁
Very easy
Super madam
If there is no primary key then point 4 is possible
Very nice mam❤️🙏
Nice video
Nice
Good teacher
специально, искусственно усложнять себе работу и считать это работой
Tq❤️ madam for your teaching
Tnx mam...🙂
For the video..
Mam this us a use of my sql
Nice lactute☺
Thanks for video
Thank you ☺️
Thank you mam❤
Mam rows la salary same na same data thane varum
Thank u so much mam..
Greatt
Thank you :)
5star explanation
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
can we get these notes that you are writing in the video?
Thanks soo much ✍️👏
I can't understand in order of attributes no significance.
And
Order of tuple has no significance.
Plz explain mam.
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
Thank you
Nice mam
mam plzz do your lecture in marathi or hindi
your teaching is good but you might have opted a good red pen
agr hmare paas 2 ya 3 tables hain tou hm degree aur cardinality kese findout krien ge
Thanks a lottt maam🙂
Pls upload relational data model in language topic
Thank you mam
Asalamu walikum warahamatulahe wabarkathahu naziya ji
What is range ?
CA module is saying different ....records , key, cardinality are not explained by you
Thanks ma'am
TQ sooooooo much