Database designing is required for organisation of data according to a data model, To give your product a strong and powerful base we follow the following steps to design your database to make it very flexible and robust.
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.
Steps we follow :
First we research about your requirment for the database, Then we move forward to collect information accordingly.
organization of information
Gather all of the types of information you might want to record in the database, such as product name or order number.
Division of information
In this step we divide your information items into major entities or subjects. Each subject then becomes a table.
Then we accordingly decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table.
Now keys are created which will give your database more roboustness. All your data will be stored under Primary/secondary keys structure.
Then we will study each table and decide how the data in one table is related to the data in other tables. We will then add fields to tables or create new tables to clarify the relationships.
Now we will analyze the design for errors, Create the tables and add a few records of sample data, to see if we can get the results which we want from these tables.
Then the data normalization rules are applied to see if the tables are structured correctly, then voilla!! your data base is ready.