# Conceptual Database Design

## Agenda

Entity/Relationship Modelling
- Definition of Entities, Relationships, Attributes
- Types of Attributes
- Relationship grades, cardinalities & types
- Graphical notations of ER diagrams

## References

[Entity/Relationship Modelling](https://beginnersbook.com/2015/04/e-r-model-in-dbms/)
Peter Pin-Shan Chen (1976) „[The entity-relationship model—toward a unified view of data | ACM Transactions on Database Systems](http://doi.acm.org/10.1145/320434.320440)
[From Chaos to Clarity: Conceptual Modeling for Complex Systems - YouTube](https://www.youtube.com/watch?v=gRrz8WNrhFg) | Software Engineering Institure, Carnegie-Mellon University

## Modeling Tools

1. [MySQL Workbench](https://www.mysql.com/de/products/workbench/) Graphical Database IDE
3. [yED](https://www.yworks.com/products/yed) Opensource diagramming and graphing tool
4. [Kroki!](https://kroki.io/#support) Diagram-as-Code platform with references to E/R Modeling (with ERD, Mermaid modules)
5. [Entity/Relationship Diagram in Mermaid](https://mermaid-js.github.io/mermaid/#/./entityRelationshipDiagram) Diagram-as-Code in Mermaid
6. [Dbdiagram.io](https://dbdiagram.io/home) Online diagramming tool
7. [Diagrams.net](https://app.diagrams.net/) Online diagramming tool
8. More under [8 Best Relational Database Schema Design Tools in 2024](https://hevodata.com/learn/relational-database-schema-design-tool/)

## Flashcards

[Conceptual Database Design - AnkiWeb](https://ankiweb.net/shared/info/2135939403)