ERD

Entity Relationship Design (ERD) is the process of modeling table relationships and is commonly used during database brainstorming and development.

This database ERD shows the relationship between several tables…in this case the assessment structure used for verifying quality education in Cal Poly’s GrC Department. I use ERD as a means to understand relationships in database modeling. I generally use some form of low-code technology like Caspio, but have fundamental skills in SQL too. The following are relationship designs for sample exercises developed for my classes. Non-relational (JSON) approaches can easily be employed for any of these ERD models.