Logical & Conceptual Database Design using DbSchema

Design the database logical schema, generate the physical schema for all databases including MySql, MariaDB, PostgreSQL, SqlServer, Oracle, Sybase, MongoDB, Sqlite. Share the schema design in team using GIT repositories. Compare and synchronize different versions of the design model. Generate HTML5 documentation.

Download DbSchema: https://dbschema.com/download.html?utm_source=youtube&utm_medium=organic_video&utm_campaign=youtube_channel&utm_content=mBBpy5Xc2n4

---

Closed Caption:

design The Logical schema using DB
schema The Logical database design is a
more generic database independent design
of the
schema The Logical design is using
subject areas entities attributes and
relations instead of schemes tables
columns and foreign Keys the relation
can have a cardinality as identifying or
non identifying one: one one to many or
many to many these options are available
only in The Logical design in the
physical design the cardinality is a
consequence of the column's mandatory
and
uniqueness from the design menu you can
access two dictionaries the naming
dictionary is for mapping The Logical
name to a different physical name the
conversion dictionary can map the data
type and the default value to another
type in the physical
database validate the model using
validation rules they can check
different properties of the tables and
columns the validators can act as a
filter and in this case the subsequent
validators will be checked only if the
previous validators are
true add comments to entities and
attributes beside text comments add key
values tags the tags can be defined in
the tag manager among the project tags
can be used for data governance and in
automation scripts sample automation
scripts are available in the deploy
menu use the generate physical model to
convert from a logical design to a
physical
design The Logical design can be
compared with another logical design
model from the file and the differences
between models can be visualized
The Logical design model can be saved in
a g repository and shared with the
team use the G dialogue to view the
different versions of the design model
and compare the repository commits