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
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!
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
Best SQL tutorial out there! You're a great teacher Mike
From your teaching techniques, i find your tutorials an Active way rather the passive learning. Thanks Mike.
Why you stop uploading videos mike
And I wasted my two days in learning this things.. which this man completed in just 14 minute..
hey mike, why your channel is not updated? are you give up from teaching or being youtuber? In my opinion, you should keep producing !
Me and my friends watch tons of your videos. THANK YOU. YOU HELPED US SO MUCHHH
Your series on ERDs helped me a lot! Thank you!
I can only give prayers!
I can afford no donations, unfortunately.
Hi, thanks for your videos. What's the double line means in the entity (Square and Diamond)?
Double rectangle is weak entity and double diamond is identifying relationship.
Plz make a video on php n mysql
Where do you create these diagrams?
hey welcome to draft academy, my name is mike
So can you think of the entity 'Student' as a class called 'Student' instead?
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
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
I have a problem with running code. it say no symbol found?
Which software can we use for creating ER Diagrams??
u spent 14 minutes to make the stuff clear which my professor spent 2 hrs messing up it
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...
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!
entitties xD
Thanks!
Very good and funny videos bring a great sense of entertainment!
thanks white man for the clear explanation.
i sbuse u are beown .black or asian
very easy to understand ... and appreciate the actions in which you move your pos to show the Class entity.
Can you please share the slides?
You are great man !!!
it helpful!!
Thanks!!!
thanks
Thanks
Great nice and clear explanation