Database Design 33 - Cardinality
HTML-код
- Опубликовано: 6 сен 2024
- Start your software dev career - calcur.tech/de... 💯 FREE Courses (100+ hours) - calcur.tech/al...
🐍 Python Course - calcur.tech/py...
✅ Data Structures & Algorithms - calcur.tech/ds...
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/ne...
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/sub...
👨🏻🎓 Courses - www.codebreakt...
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com...
🅿 Patreon - calcur.tech/pat...
🅖 GitHub Sponsors - github.com/spo...
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/cr...
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/cr...
This is not Cardinality you have explained Relationships. Cardinality is the next step where you document the min and max number of entity occurrences associated with one occurrence of the related entity. Ex. (1,4) would be placed under your connectivity diagram on the many side an (0,1) on the one side.
sir this is what I want to know. can you tell me more? please.
Al Simmons, can you please elaborate on the difference between Relationships and Cardinality? Everything I have read suggests that Cardinality and table 'Relationships' are interchangeable and your comment makes them sound only tangentially different. Can you explain what you mean by 'Cardinality is the next step'? What is the first step - defining the relationship? Isn't the relationship implied by the Cardinality? Thanks!
Good thing i read the comments section.... smh
@Al Simmon, is your comment a valid feedback or just "boring philosophy" ??? you can at least answer people you confused.
It would be useful if people did elaborate on their comments.
My understanding of cardinality is new but is as follows - hopefully it'll help some people (though I'm still progressing my learning for DBA):
Things can have a high and low cardinality. Something like a boolean has a low cardinality as it has, not including null, 2 available options - true & false.
Something with a high cardinality has a large range of options and is, by rule of thumb, more unique. ID being a perfect example as it increments and has a unique value.
So a way you can use this to improve performance is by configuring an index to use the high cardinality value first and then use the low cardinality on the where clause.
Imagine a DB that contains video parts that are to be processed into one single video and the ones that have been processed. You have a script that every minute checks the DB and processes the videos that require it.
To improve the read of the data you could do:
CREATE INDEX ON tbl (id) WHERE media_processed = FALSE
This would allow the database to pull all of the unprocessed videos quicker than if for example you just did a select by the media_processed value as with that scenario every record would have to be checked for the true or false value.
better than my professor explaining for an entire week lol
same
thank you so much for this Caleb. Remote Learning with this courses has been a struggle and this video (and im sure more) saved me.
I didn't even noticed you stuttered! ;) Thanks for your clear explanation
king this was brilliant. This was so helpful!!! you didnt even stutter btw
the casio clock alarm (sound) was a golden time. at 3:56
THANK YOU. I was having such a hard time grasping this concept and you made it clear
New Shirt, I love it! Live Free!!
In fact Mr. Caleb, when you get a credit card you get an account for that card. Modern accounting originated with the Knight Templar, and the purpose of the account is to allow multiple family members transact on or against the held money /goods.
hey you should do a software engineering .. your great at explaining these things compared to some of my professors...
This is a part of software engineering. Software engineering is a huge topic...
yehhh and?
Love the chalkboard! Thanks for the video, very helpfull.
dude is so nerdy he uses old technology.
that... THAT is one savage nerd right dey :D
Sweet new AMERICA shirt!
So, in the logical schema, you don't include intermediary relations? And if that is the case, does that mean in the 'card_holder' to 'card' relationship we can also express a 'many-to-many'?
this man is a god at teaching
good video dude keep it up its not half as bad as you think
Just wanted to add for those of you who are reading database systems: sixth edition Pearson as part of either a business analytics class or for data science. The book definition is speaking about the mathematical concept.
If you need understand the difference between the two and are still struggling head over to stack overflow and type in the book definition. Someone answered it already. It helped me.
Thank YOU! You definitely explained it in a way I can understand!
cheers pal. way more help than my lecturer tbh
haha unfortunately I know exactly what you mean
Bro you tremendously helped me❤️❤️❤️❤️❤️🙏🏽🙏🏽🙏🏽🙏🏽🙏🏽, God bless you
Thanks Caleb ,greetings from Galapagos, Ecuador
Thanks for the help friend, AIS is killing me
Watching this in 2022. U were so young then.
it's like watching matrix movie that had CRT embedded monitors as "advanced" technology... tech changed so much
Perfect descriptions - really helped with my database homework
Man, I wish you were my professor
Helped quite a bit, thanks
what about zero to many?
You were great even in 2019.
2014*
2021 still his videos are relevant.
thanks bro
Thanks for clear and nice explanation
Are there any java video lectures done by you?
This helped so much!! Thank you!
Thanks for sharing mate
Thank you!
Thank you so much
Thnx
yoo catch you there man!!!
Why does he sound like Greg from succession, LOL. Thanks for the video tho.
great video
The sound of chalk on blackboard
Omg this is 9 years ago!
I was going to ask if we could be friends you are really cute
God😎
Shaggy is that you?
I have a big crush on you.
yooo
high on weed
Thanks for your efforts and time. But thats not the right explaination.
thanks bro