Database Design 33 - Cardinality

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

[@vmaloy9030]

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.

[@heyitsvolga]

better than my professor explaining for an entire week lol

[@minaakhlaghipour3325]

same

[@arnold9448]

I didn't even noticed you stuttered! ;) Thanks for your clear explanation

[@emberafterglow4916]

New Shirt, I love it! Live Free!!

[@devikamujgule6888]

king this was brilliant. This was so helpful!!! you didnt even stutter btw

[@jackfrost884]

THANK YOU. I was having such a hard time grasping this concept and you made it clear

[@alsimmons5566]

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.

[@clarianken4223]

sir this is what I want to know. can you tell me more? please.

[@voodoochili12]

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!

[@duvipearson6251]

Good thing i read the comments section.... smh

[@AhmedHadiPADI_scuba_instructor]

@Al Simmon, is your comment a valid feedback or just "boring philosophy" ??? you can at least answer people you confused.

[@Drewbernetes]

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.

[@TanjinaAkter-cy7rd]

Thanks for clearing this concept

[@vio4jesus]

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.

[@TradingArmyBD]

the casio clock alarm (sound) was a golden time. at 3:56

[@richardbolas]

this man is a god at teaching

[@gijshazerswoude9101]

Love the chalkboard! Thanks for the video, very helpfull.

[@mr.almezeini647]

dude is so nerdy he uses old technology.
that... THAT is one savage nerd right dey :D

[@MoniqueManners]

this was so helpful thanks!

[@bigmax1839]

good video dude keep it up its not half as bad as you think

[@gwenfuri4584]

Thank YOU! You definitely explained it in a way I can understand!

[@alexcurran6460]

cheers pal. way more help than my lecturer tbh

[@RM-tj7lv]

haha unfortunately I know exactly what you mean

[@dboijahskush1251]

hey you should do a software engineering .. your great at explaining these things compared to some of my professors...

[@BEKBLAXX]

This is a part of software engineering. Software engineering is a huge topic...

[@Menelyagor12]

yehhh and?

[@MrDovanele]

it's like watching matrix movie that had CRT embedded monitors as "advanced" technology... tech changed so much

[@oliverchris5404]

Bro you tremendously helped me❤️❤️❤️❤️❤️🙏🏽🙏🏽🙏🏽🙏🏽🙏🏽, God bless you

[@soldadopreciso]

Thanks Caleb ,greetings from Galapagos, Ecuador

[@8Bitz]

Sweet new AMERICA shirt!

[@justingrove5190]

Man, I wish you were my professor

[@stonermountain9147]

Thanks for sharing mate

[@popwar6294]

Thanks for the help friend, AIS is killing me

[@bassam9115]

Helped quite a bit, thanks

[@77ownage]

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

[@rajibtammydasgupta2068]

Perfect descriptions - really helped with my database homework

[@nmkone2207]

You were great even in 2019.

[@Itacho333]

2014*

[@maliraza3696]

2021 still his videos are relevant.

[@thomastafese9470]

Watching this in 2022. U were so young then.

[@ashleykirsch5147]

This helped so much!! Thank you!

[@jasemabdullah8429]

Thanks for clear and nice explanation

[@darthbleen984]

yoo catch you there man!!!

[@cybergenius4692]

what about zero to many?

[@garimavohra13]

Are there any java video lectures done by you?

[@ShravanDwarka]

The sound of chalk on blackboard

[@demon0192]

Thank you!

[@ChoosingDana11]

Omg this is 9 years ago!
I was going to ask if we could be friends you are really cute

[@Kinkonomics]

Thank you so much

[@jordydemeyere5029]

Why does he sound like Greg from succession, LOL. Thanks for the video tho.

[@PerscillaBrowne]

great video

[@mh5854]

Thnx

[@saadrana234]

thanks bro

[@adamland9219]

Shaggy is that you?

[@robloxvempor]

God😎

[@gerryattrik4410]

I have a big crush on you.

[@syedhaq12]

Thanks for your efforts and time. But thats not the right explaination.

[@docnoob8978]

high on weed

[@dj_sal.z]

yooo

[@gexanxavian]

thanks bro