First we store and anlize your database requirement, the next thing that we need to do is creating a conceptual database plan. This phase is called conceptual design. When the conceptual design phase is in progress, the basic data modeling operations can be deployed to define the high-level user operations that are noted during analysis of the functions.

In the logical phase of database design is also called the data modeling mapping phase in this phase we make ER digram and Class digram, To create the relation schemas is mainly mechanical operation. There are rules for transferring the ER model or class diagram to relation schemas.

Normalization is, the last piece of the logical design puzzle. The main purpose of normalization is to remove superfluity and every other potential anomaly during the update. Normalization in database design is a way to change the relation schema to reduce any superfluity. With every normalization phase, a new table is added to the database.

The last phase of database design is the physical design phase. In this phase, we implement the database design. Here, a DBMS (Database Management System) must be chosen to use. For instance, different DBM systems have different names for every datatype and they have different data types. SQL clauses are written to help in creating the database. Also, the indexes and the integrity constraints (rules) are defined in this phase. And finally the data is added and the database can finally be tested and will be delivered to you.