Converting E-ERD to Physical DBMS Step by Step

A step-by-step approach and techniques used to create the database.

·         Extracting information from System Requirement Specification E-ERD.

·         Generating conceptual data entities.

·         Transforming a conceptual model into a logical one.

·         Schema refinement.

·         Building a physical database from a logical model.

Conceptual modeling

Capturing core entities

Identifying entity attributes

Creating unique identifiers

Graphically representing a conceptual model

Logical modeling

Apply data types to entity attributes

Describing relationships: one-to-one, one-to-many, many-to-many

Building recursive relationships

                       

                       

Schema refinement

Normalization Techniques

Avoiding update anomalies

Identifying functional dependencies

Applying rules for normalization

Normalizing multi-valued attributes

Building a Relational Database

Physical database design

Implementing keys from unique identifiers

Building foreign keys from relationships

Tools that can be used 

·         Visual Paradigm Community Edition.

·         ERDPlus  (https://erdplus.com/#/)