Summary
Keywords
Full Transcript
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://bit.ly/3EpZgBD Memberships: https://bit.ly/2U7YSPI Discord: https://bit.ly/3HiGtJr WhatsApp: https://whatsapp.com/channel/0029Va9B1Bq4tRru0nqgtx3h Books: https://bit.ly/4cZYQil Website ► https://www.nesoacademy.org/ App ► https://play.google.com/store/apps/details?id=org.nesoacademy Facebook ► https://www.facebook.com/nesoacademy Twitter [X] ► https://x.com/nesoacademy Music: Axol x Alex Skrindo - You [NCS Release] #DBMSByNeso #DBMS #ERDiagram
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
