Database Design 33 - Cardinality

No video

Database Design 33 - Cardinality

Рет қаралды 110,704

10 жыл бұрын

Start your software dev career - calcur.tech/dev-fundamentals 💯 FREE Courses (100+ hours) - calcur.tech/all-in-ones
🐍 Python Course - calcur.tech/python-courses
✅ Data Structures & Algorithms - calcur.tech/dsa-youtube
~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~
✉️ Newsletter - calcur.tech/newsletter
📸 Instagram - / calebcurry
🐦 Twitter - / calebcurry
🔗 LinkedIn - / calebcurry
▶️ Subscribe - calcur.tech/subscribe
👨🏻‍🎓 Courses - www.codebreakthrough.com
~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~
↪ My Amazon Store - www.amazon.com/shop/calebcurry
🅿 Patreon - calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - github.com/sponsors/CalebCurry
Ⓟ Paypal - paypal.me/calcur
🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853
📈 Buy Bitcoin - calcur.tech/crypto
Reserve the Ruby Steel crypto rewards card and get a $25 bonus (use affiliate code "Caleb") - calcur.tech/crypto

Пікірлер: 62

@vmaloy9030 3 жыл бұрын

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.

@arnold9448 8 жыл бұрын

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

@heyitsvolga 3 жыл бұрын

better than my professor explaining for an entire week lol

@minaakhlaghipour3325 6 ай бұрын

same

@jackfrost884 7 күн бұрын

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

@devikamujgule6888 2 ай бұрын

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

@gwenfuri4584 2 жыл бұрын

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

@rajibtammydasgupta2068 8 жыл бұрын

Perfect descriptions - really helped with my database homework

@gijshazerswoude9101 9 жыл бұрын

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

@mr.almezeini647 3 жыл бұрын

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

@bigmax1839 8 жыл бұрын

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

@emberafterglow4916 4 жыл бұрын

New Shirt, I love it! Live Free!!

@ashleykirsch5147 8 жыл бұрын

This helped so much!! Thank you!

@soldadopreciso 5 жыл бұрын

Thanks Caleb ,greetings from Galapagos, Ecuador

@bassam9115 8 жыл бұрын

Helped quite a bit, thanks

@oliverchris5404 3 жыл бұрын

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

@TradingArmyBD 2 күн бұрын

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

@popwar6294 8 жыл бұрын

Thanks for the help friend, AIS is killing me

@jasemabdullah8429 3 жыл бұрын

Thanks for clear and nice explanation

@harryb1210 2 жыл бұрын

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.

@vio4jesus 2 жыл бұрын

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.

@stonermountain9147 3 жыл бұрын

Thanks for sharing mate

@77ownage 3 жыл бұрын

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

@8Bitz 3 жыл бұрын

Sweet new AMERICA shirt!

@huytranxuan5976 6 жыл бұрын

Thank you so much

@richardbolas 2 жыл бұрын

this man is a god at teaching

@garimavohra1482 8 жыл бұрын

Are there any java video lectures done by you?

@dboijahskush1251 8 жыл бұрын

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

@BEKBLAXX 8 жыл бұрын

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

@Menelyagor12 7 жыл бұрын

yehhh and?

@demon0192 4 жыл бұрын

Thank you!

@alexcurran6460 7 жыл бұрын

cheers pal. way more help than my lecturer tbh

@RM-tj7lv 7 жыл бұрын

haha unfortunately I know exactly what you mean

@darthbleen984 7 жыл бұрын

yoo catch you there man!!!

@justingrove5190 4 жыл бұрын

Man, I wish you were my professor

@gexanxavian Жыл бұрын

thanks bro

@PerscillaBrowne 9 жыл бұрын

great video

@mh5854 3 жыл бұрын

Thnx

@MrDovanele 4 жыл бұрын

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

@cybergenius4692 5 жыл бұрын

what about zero to many?

@nmkone2207 5 жыл бұрын

You were great even in 2019.

@Itacho333 4 жыл бұрын

2014*

@maliraza3696 3 жыл бұрын

2021 still his videos are relevant.

@thomastafese9470 Жыл бұрын

Watching this in 2022. U were so young then.

@alsimmons5566 9 жыл бұрын

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 8 жыл бұрын

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

@voodoochili12 7 жыл бұрын

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 6 жыл бұрын

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

@AhmedHadiPADI_scuba_instructor 6 жыл бұрын

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

@Drewbernetes 6 жыл бұрын

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.