Skip to content

ERD_description

Jump to bottom
Amit Das edited this page Aug 6, 2023 · 6 revisions

Creating an Entity Relationship Diagram

My ERD includes 7 tables: City, Location, Country, Continent, EarthquakeDetails, MagType, and Network. Each of these tables conforms to 3NF. That is, all non-prime attributes are directly related to the primary keys. Furthermore, there are no transitive dependencies present in each of the tables. The attributes of each of the tables, along with the table names, are represented in the diagram. Below is a brief summary of the relationships present within this database.

  • Location to City: Many-to-One
  • City to Country: Many-to-One
  • Country to Continent: Many-to-One
  • EarthquakeDetails to Location: Many-to-One
  • EarthquakeDetails to Network: Many-to-
earthquake_erd One - EarthquakeDetails to MagType: Many-to-One

ERD Diagram

Clone this wiki locally