UML Modeling Data Model (DIAGRAM)

A brief introduction of data modeling

Data modeling can not only model object properties (such as E-R diagram), but also model the behavior of the data (such as trigger trigger, stored procedure stored Procedure). When designing a database, you design the following concepts:

Schema schemas, primary key Primary, foreign key Foreign keys, relational relationship, constraint constraint, index indices, trigger Trigger, stored procedures Stored Procedure, view views.

Data modeling elements 1, tables (table)

Tables are the most basic model structures for relational databases. The following figure

Table's primary key: Inventoryid

Foreign key of the table: Warehouseid, the primary key associated to the table warehouse

You can set the database type of the table, as shown below