Concept of Relationships in ER Diagram

DBMS: Concept of Relationships in ER Diagram
Topics discussed:
1. Definition of Relationship & example.
2. Degree of Relationship:
a. Unary relationship
b. Binary relationship
c. Ternary relationship
3. Relationship Constraints
a. Cardinality Ratio (one to one, one to many, many to one & many to many).
b. Participation Constraints (Total & partial participation).
4. ER Diagram for COMPANY database.
5. Attributes of Relationship Types.
6. Role Names & Recursive Relationships.
7. Alternative Notations for ER Diagrams.
8. Enhanced ER (EER) Model:
a. Generalization
b. Specialization

Follow Neso Academy on Instagram: @nesoacademy(https://bit.ly/2XP63OE)

Contribute: http://www.nesoacademy.org/donate

Memberships: https://bit.ly/2U7YSPI

Books: http://www.nesoacademy.org/recommende...

Website ► http://www.nesoacademy.org/
Forum ► http://forum.nesoacademy.org/
Facebook ► https://goo.gl/Nt0PmB
Twitter ►   / nesoacademy  

Music:
Axol x Alex Skrindo - You [NCS Release]

#DBMSByNeso #DBMS #ERDiagram