TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

Database

Entity-Relationship Model

Overview

In this tutorial, we will learn about relational database design using Entity-Relationship Model. An Entity-Relationship Model is the most common used model for relational database design.

An Entity-Relationship Model is used to model a relational database using a top-down method. This method starts with an overall black box view, then adds detail as the process is refined. The product of this modelling process is a diagram called an Entity-Relationship Diagram (ERD).

Entities and Relationships

https://www.testingdocs.com/database-entities-and-relationships/

ER Diagram

The outcome or the product of the database modelling process is a diagram called as an Entity-Relationship Diagram(ER Diagram or in short ERD ). The Entity-Relationship Diagram is a high-level graphical description of a data model. We can use this model diagram to assist in the database design.

There are multiple ERD types and are used at different stages of the database modelling. Popular ER model notations are as follows:

  • Chen Model
  • Crow’s Foot Model
  • UML Model

Crow’s foot notation is one of the most intuitive ER diagram notation style.

Example

In this example, we will use the MySQL world database. The database consists of three tables.

  • Country
  • City
  • CountryLanguage

MySQL world database ER Diagram

world database ERD

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

SQLite

Database /

SQLite database introduction

Database /

Popular NoSQL Databases

Database /

Database Design Process

SQL Sub Query

Database /

SQL SubQuery

SQL_statements

Database /

SQL Questions for Beginners

‹ Database Design Process› Popular NoSQL Databases

Recent Posts

  • Update draw.io on Windows
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com