Concept of Relationships in ER Diagram

Concept of Relationships in ER Diagram

588.745 Lượt nghe
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/recommended-books Website ► http://www.nesoacademy.org/ Forum ► http://forum.nesoacademy.org/ Facebook ► https://goo.gl/Nt0PmB Twitter ► https://twitter.com/nesoacademy Music: Axol x Alex Skrindo - You [NCS Release] #DBMSByNeso #DBMS #ERDiagram