ER Diagrams Intro | SQL | Tutorial 21

[@vatsaakhil]

Best SQL tutorial out there! You're a great teacher Mike

[@computergeeks7546]

In MS-Access:
1:1 is equal to one-to-one relationship
1:M is equal to one-to-many relationship
N:M is equal to many-to-many relationship

[@labeh3750]

From your teaching techniques, i find your tutorials an Active way rather the passive learning. Thanks Mike.

[@postfixnotation9829]

Your series on ERDs helped me a lot! Thank you!

[@senalweerasekara]

Me and my friends watch tons of your videos. THANK YOU. YOU HELPED US SO MUCHHH

[@jamespottex5197]

And I wasted my two days in learning this things.. which this man completed in just 14 minute..

[@trungpham7588]

very easy to understand ... and appreciate the actions in which you move your pos to show the Class entity.

[@ThaiNguyen-co4jm]

Very good and funny videos bring a great sense of entertainment!

[@fluffyberry2222]

Entity: grey box
Attributes: circle
Composite Attributes: branches of attributes
Prim Key: Underlined in circle
Multivalued Attribute: two circles
Derived attribute: - derive from another attribute broken circle (eg: gpa get from grade)
Relationship: diamond box - take
Total participation: 2 line - students who attend class need to take it
Partial Particpation: one lines (not all students have to take class)
Relationship attribute - circle connected to relationship : a grade from taking class
cardinals:
M = any no. of classes
N = any no. of students
1:N
student can only take one class
class can b taken by any no. of students
M:1
a studnt can take any no. of classes
only one student can attend the classes
1:1
one student one class
weak identity: depends on another entity - broken underline (exam depends on class - cant have exam wirhout knowing which class it belongs to)
identifying relationship: diamond box
has
exam has a class

[@imohimijulius6291]

you deserve more than 100%,, guess no human can get above 100... so i give you 99%... one love.. the other 1% for most high

[@tuansiraj]

You are great man !!!

[@alvarotorres5958]

I would rather say that grade is a weak entity because it depends on the student and on the class... Besides this, great video and awesome explanation about cardinality!

[@daniilpogolovkin8221]

Thanks!

[@itiremiroglu7646]

hey mike, why your channel is not updated? are you give up from teaching or being youtuber? In my opinion, you should keep producing !

[@kishoreannu3649]

Great nice and clear explanation

[@bluebird563]

thanks white man for the clear explanation.

[@mscoco1431]

i sbuse u are beown .black or asian

[@franciscrypto9143]

hey welcome to draft academy, my name is mike

[@davidwu9626]

Hi, thanks for your videos. What's the double line means in the entity (Square and Diamond)?

[@naveenrawat6278]

Double rectangle is weak entity and double diamond is identifying relationship.

[@gramirom]

Thanks!!!

[@aydamuhaba7547]

Why you stop uploading videos mike

[@nevilholmes5900]

Thanks

[@john_atkins]

So can you think of the entity 'Student' as a class called 'Student' instead?

[@user-ir2vf2nw6d]

it helpful!!

[@adlbasit]

Hey dane... I remember I watched an 8 hrs long sql tutorial of yours... Can you please provide a link to that? I searched alot but couldnt find...

[@christianespinosa4632]

I have a problem with running code. it say no symbol found?

[@stinhuffine4422]

Where do you create these diagrams?

[@kailash._11.]

Which software can we use for creating ER Diagrams??

[@Ishaana3290]

Plz make a video on php n mysql

[@shibukumar2675]

Can you please share the slides?

[@freakwankerhans7959]

u spent 14 minutes to make the stuff clear which my professor spent 2 hrs messing up it

[@babakazizi3147]

I can only give prayers!
I can afford no donations, unfortunately.

[@gorvtaxak2923]

entitties xD

[@nevilholmes5900]

thanks