Entity-relationship diagram
• Used to clarify table relationships in a relational
database
• Relational database tables may have:
• One-to-one relationship
• One-to-many relationship
• Many-to-many relationship
• Requires “join table” or intersection relation
that links the two tables to join information
Entity-relationship diagram
• Used to clarify table relationships in a relational
database
• Relational database tables may have:
• One-to-one relationship
• One-to-many relationship
• Many-to-many relationship
• Requires “join table” or intersection relation
that links the two tables to join information