Skip to content

ERD_description

Jump to bottom
Amit Das edited this page Aug 7, 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-One
  • EarthquakeDetails to MagType: Many-to-One
earthquake_erd

Below is a link to the .mwb file used to create the erd diagram. This file is also available in the main GitHub repository. model_earthquake.mwb

Clone this wiki locally