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

    Database /

    DB Browser for SQLite

    SQLite

    Database /

    SQLite database introduction

    Database /

    Types of NoSQL databases

    Database /

    Popular NoSQL Databases

    Database /

    Database Characteristics

    ‹ Database Design Process› MS Access Data Types

    Recent Posts

    • Running Tests in Parallel with Selenium Grid
    • Advanced Selenium Features
    • Locating Web Elements
    • Running the Test Script
    • Writing Your First Selenium Test Script
    • Getting Started with Selenium Automation Testing
    • Setting Up the Environment
    • How can you monitor the Quality Assurance Audit?
    • Leveraging LambdaTest with Appium 2.0
    • Appium 2.0 Plugins ListAppium 2.0 Plugins
    • Touch Actions and Multi-Touch Actions
    • Changes in Drivers and Classes
    • Appium Inspector
    • Capabilities in Appium 2.0
    • Appium 2.0 Driver ListAppium 2.0 Driver Installation & Management
    CyberLink Multimedia Software

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com