Designing an ER Diagram | SQL

Designing an ER Diagram | SQL | Tutorial 22

Рет қаралды 97,068

Giraffe Academy

6 жыл бұрын

🦒❤️ www.giraffeacademy.com/databa...

Пікірлер: 56

@neilwalker3204 5 жыл бұрын

I am currently studying databases and find your lectures easy to follow and excellent supplementary material.

@Noah-zp2fn 3 жыл бұрын

yeah agreed the way he speaks is so clear and concise

@karel_pk 2 жыл бұрын

I am currently studying database fundamentals, I find your videos very useful and helpful, keep up the good work.

@alexandrospanag 3 жыл бұрын

that's the 5th time you helped me learn by explaining awesomely! thank you mike!

@chinchill4n Жыл бұрын

Awesome video! Detailed and to the point. 10/10

@aaryansarnaik3758 3 жыл бұрын

Great lecture, concise and to the point with very clear explanation of how to identify the cardinalities and relations

@noahrubin375 3 жыл бұрын

The best video I have seen on this topic! Well done

@laurafigueroa9922 4 жыл бұрын

Thank you so much. I was so lost until I found this video!!!

@mscoco1431 5 жыл бұрын

this is the best explination i ever see ..................thank you so much

@sonwabiledyam382 2 жыл бұрын

You taught me more in 13min than my lecturer did in 6 months.

@thanghoang1944 3 жыл бұрын

I love your lesson, better than my professor at uni haha

@utkarshsrivastava4106 4 жыл бұрын

How aren't you more popular ! Thanks for this video ☺️

@babakazizi3147 Жыл бұрын

Fabulous! God bless you!

@absurd7292 4 жыл бұрын

you are a great teacher

@KaliKali-cr4nf 3 жыл бұрын

once am done with my class and get a job i am definitely contributing to Giraffe Thank you for making my nightmare to enjoyable experience Namest

@doaaahmed9730 3 жыл бұрын

Thank you so much, amazing explanation 💛💛💛

@jamrasalih2412 Жыл бұрын

I failed at DBMS at uni, and i just watched your tutorials, i passed with good gpa, thanks Mike.

@sadiqali3593 3 жыл бұрын

Awesome mike, you are brilliant dear :)

@ashrafulfuad2967 4 жыл бұрын

good explanation i have ever seen thank you so much ...

@eduardchante 2 жыл бұрын

God has given you a gift. The gift to break down everything in a simple way.

@asimaltinisik 2 жыл бұрын

The best !

@patriciocastillo2772 3 жыл бұрын

Good job man

@savageboii1 4 жыл бұрын

Very well explained

@ashishrobertsamuelahne2188 10 ай бұрын

thanks for this very helpful

@josephinemcmahon7286 3 жыл бұрын

Hi, thanks for your very helpful videos on creating Databases and SQL language. Could you do one on creating a stored procedure in MYSQL, especially a procedure for inserting a new row into a table? Thanks

@garrygraves6441 4 жыл бұрын

Great content (just subscribed). Is there any chance you have something showing the ERD examples in Crow's Foot notation instead of Chen notation?

@pound9799 2 жыл бұрын

I swear you're the only one I understand from

@dand5695 3 жыл бұрын

Love your video it was really helpful. I have one small comment, I think you forgot to add the attribute "salary" to the relation "works for ". Good work and DO keep it up, much appreciated!!!!!

@victoribikunle5300 2 жыл бұрын

thank you

@socenprolif7757 4 жыл бұрын

if we have a weak entity connected with multiple strong entities, how do we decide which one of those strong entities to be the owner of the weak entity?

@akshaymotiyani291 3 жыл бұрын

Thankyou So much

@melvincotoner4878 5 жыл бұрын

i fucking love you man

@hakangalip9626 4 жыл бұрын

THANK´S A LOT

@KD-bh2to 3 жыл бұрын

I just wanted to find out how make a ERD on my SQL for the companie's DBMS

@charlesj84 2 жыл бұрын

Hello Mike, what software do you use to design the ER diagram?

@elenBk 5 жыл бұрын

Which program is used to make the ER diagram?

@elenBk 5 жыл бұрын

If someone is looking for a programm to make er diagrams, drawio is really good!

@albertsteve9551 3 жыл бұрын

Yeah I use draw.io too

@theloeb587 2 жыл бұрын

try ERDplus

@santiagorivera1562 4 жыл бұрын

What is the difference between n and m cardinality?

@pukka4140 5 жыл бұрын

hello, Can anyone explain why branch supplier was weak entity and what kind of keys are you going to use in relationship supplies?

@scottisitt 4 жыл бұрын

In the previous tutorial (number 21) at 10:58, he talks about a weak entity being dependent on another entity. The example he gave was that an exam cannot exist without a class. So "exam" was a weak entity. So here, the same logic applies where a branch supplier cannot exist without a branch (to supply). That similar relationship is not quite as obvious here, since you could reason that the branch also cannot exist without the supplier.... But...the supplier wouldn't know what to supply if it didn't have a branch to supply (just like an exam doesn't know what to test you on if it doesn't belong to a class). As for your second question about keys, it might be a composite key using supplier_name and branch_id (just my guess), but he'll probably talk about it in the next video.

@nevilholmes5900 3 жыл бұрын

thanks

@KD-bh2to 3 жыл бұрын

Oh and could u also help with views and stord procedures for the company database

@bedt1meb0y24 Жыл бұрын

Hey Mike eeeeey where r u man.....without you where is the freecode camp

@matl6338 4 жыл бұрын

Don't you have to resolve n to m cardinalities?

@jesuopin1612 Жыл бұрын

Why is not the manage relationship between employee and branch reflexive? the manager is also a manager, am i right?

@liemthai4439 3 жыл бұрын

so how many entities in this example?

@buugedy 2 жыл бұрын

What is the difference in cardinalities M and N? Please kindly explain with details on this example. For me it is hard to understand, when we have N and when we have M.

@myyoutubechannel7389 2 жыл бұрын

My exam is at 8: am M watching video here at 7:43 am.

@hrithikraj-ku5lk Жыл бұрын

Why company is not an entity ??

@sayyidalisajjadrizavi7418 4 жыл бұрын

I am sorry but you forgot to mention at 4:55 about the meaning of "#_employees" attribute added to Branch. Could you please tell that? I guess this might help others too.