In the database's initial development, an ERD illustrated how system entities like employees, teams, and departments are interconnected. Concurrently, a Relational DBMS structured data in tables, managing relationships for efficient data access. This approach aligned with project needs, as the ERD guided relationship design and the DBMS facilitated database creation and management, ensuring data integrity and accessibility.
A type of flowchart that illustrates how “entities” relate to each other within a system.
An Entity Relationship Diagram (ERD) is a flowchart depicting how different "entities" relate in a system. Entities are distinct items that store data. The ERD shows if relationships are 1:1, 1:N, or N:N. For example, a user-to-email ERD might be 1:N, with one user having multiple emails. ERDs are vital for dashboards as they organize entity relationships connected through a Database Management System (DBMS).
A database is an organized collection of data so that it can be easily accessed.
To manage these databases, Database Management Systems (DBMS) are used.
Two or more tables are related to each other
A Database Management System (DBMS), which manages organized data collections for easy access. There are two primary types: relational and non-relational. In our project, we employed a relational DBMS, linking multiple tables. This enabled us to connect data from these tables, creating interactive graphs and charts with multiple variables.