Skip to main content

Posts

Showing posts with the label #datamodelling #sql # database #optimization #rdbms

Data modelling

What is data modelling! A key concepts while building a fresh new database, one need follow certain guidelines which allows the proper and efficient structure of the database. These guidelines include a series of steps divided in basically three steps: 1) conceptual step 2) logical step 3) physical step As the name suggests DDLC cycle which consist of requirement,design, development,testing, implementation is divided in these three steps. Benefits are like one would have the proper hierarchy in the project life cycle, blueprints will be created by default since documentation is done at each step.