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 /

Popular NoSQL Databases

world database ERD

Database /

Entity-Relationship Model

Database /

Database Design Process

SQL Sub Query

Database /

SQL SubQuery

‹ ER Diagram Cardinality Symbols› Database Design Plan

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