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

    Database

    Database Modeling

    Overview

    In this tutorial, we will learn about Database Modeling. Prior to building the actual database, we should spend time modeling the database structure. This process of specifying the table/data structure
    is based upon the specific type and use of the data that it will contain. The most commonly used model for relational database design is the Entity-Relational Model (ERM).

    The Entity-Relationship Model

    https://www.testingdocs.com/entity-relationship-model/

    Database Diagrams

    There are multiple types of database diagrams used at different stages of modeling:

    • Structure Diagram
    • Cardinality Diagram
    • ER Diagram( Entity-Relationship Diagram)

    Structure Diagram

    In order to better visualize the hierarchy of a database, a structure diagram can be used to organize the data into logical groups.

    Cardinality Diagram

    A cardinality diagram indicates the relationships between the database tables. The relationships are depicted using lines drawn from one table to another and a symbol at each end that defines the type.

    ER Diagram

    Database entities and relationships between the entities are the basic building blocks of this diagram.

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

    ERD relationship notation symbols:

    https://www.testingdocs.com/er-diagram-cardinality-symbols/

    —

    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 /

    Types of NoSQL databases

    Database /

    Popular NoSQL Databases

    Database /

    Database Characteristics

    3-Tier Architecture

    Database /

    3-Tier Architecture

    ‹ ER Diagram Cardinality Symbols› Database Design Plan

    Recent Posts

    • ChatGPT Subscription Plans
    • Stellar Converter for Database
    • Stellar Log Analyzer for MySQL
    • Stellar Repair for MySQL
    • ChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI Features
    • Shaping the Future of Development: Exploring Key Trends in Software Engineering
    • Improving Java Performance with Multithreading
    • Open-source Vector Databases

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com