Hello everyone and welcome to this class !
This course is exactly what you need in order to understand entity relationship diagrams.
So much information is available on the internet and it might be confusing.
Instead of spending too much time looking for it, you can get everything here !
The course has 6 main chapters :
Entities and attributes
You will understand the basic descriptions of entities and attributes and it is drawn on an entity relationship diagram.
Here are the subchapters :
Entity
Entity Type
Entity Set
Entity Type Representation
Tables
Attributes
Single Valued Attributes
Multi Valued Attributes
Composite Attributes
Derived Attributes
Weak Entities
Relationships and cardinalities part 1
You will understand how relationships between entities work.
Here are the subchapters :
What are relationships for ?
Relationship roles
Participation
Recursive relationships
Binary relationships
Ternary relationships
N-ary relationships
Relationships and cardinalities part 2
You will have a better understanding of how entities are related to each other.
Here are the subchapters :
Business rules
Cardinalities
Zero To Zero Relationships
Zero To One Relationships
One To Zero Relationships
Mandatory One To One Relationships
Zero To Many Relationships
One To Many Relationships
Many To Zero Relationships
Many To One Relationships
Many To Many Relationships
Notations
You will understand all the notations that are used to make an entity relationship diagram.
Here are the subchapters :
Chen's Notation
Min/Max Notation
Crow's Foot Notation
IDEF1X Notation
UML Notation
Arrow Notation
Key Attributes
Key attributes are used the make the difference between two rows on a table.
They are extremely helpful to understand how servers proceed to retrieve the data.
Here are the subchapters :
Primary Key
Composite Primary Key
Surrogate Key
Alternate Key
Candidate Key
Natural Key
Unique Key
Foreign Key
Compound Key
Please note that aside from these lectures, there are also 7 quizzes and 2 assignments.
Thank you and enjoy it !