Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Modeling (ER diagram), Data Modeling (ER diagram) - Coggle Diagram
Data Modeling (ER diagram)
Key elements
Entities
Which are an object such as a person, place, or thing to be tracked in the database.
Entities in your database will be the rows
Attributes
Various properties or traits
Attributes in your database will be depicted as the columns
Relationships
Exist between these different entities
The relationships describe how these entities will interact with each other, if at all.
Cardinality
Defines the relationship in a numerical context, particularly within minimums and maximums
Notions and their significance
Relationships
Drawing a line between entities
Draw a line between these particular elements, showing some interaction or connection in some way.
Cardinality
one
many
one and only one
zero or one
one or many
zero or many
Crow's foot notation
All other observations that makes the UML
Database
A collection of information that is organized so data can be easily stored, managed, updated, and retrieved.
A lot of moving information in a database, and understanding how the many elements of a database interact with each other can be difficult to grasp.
Entity Relationship Diagrams
A visual way to understand how all the separate elements are related to each other and how they're working together.
PK
Primary keys
FK
Foreign keys
Data Modeling (ER diagram)