Data Base Design Process

OVERVIEW:

Before we design a database for any organization, we have to consider many aspects to find out the practical scenario of owning a database. Few of them are discussed as follows:

• Feasibility Study: This is also called preliminary investigation of the required database. It involves the area identification and selection. i.e. which area or aspect is to be selected to start with. After the project is selected, it is allocated a specific fund and a proper planning is chalked out for its practical implementation. Side by side, a proper market analysis is also worked out.
• Requirements Analysis: During this activity, the requirements are gathered i.e. the possible inputs for the database and the required functionality out of it. The users precisely narrate their needs of the database and the possible domain and restrictions are also chalked out.
• Project Planning: A proper schedule is laid down to accomplish this activity. All the cost factors are taken into consideration i.e., the salaries of team members, their logistic involved, other trivial expenses (such as marriage gifts, insurances etc) and hardware costs.
• Data Analysis: This is an important analysis aspect while designing a database. It involves the following activities:

          (i)   Data Flow Diagrams  (DFD)
         (ii)   Decision Tables

         (iii) Decision Trees

Data Modeling:

Data Modeling is the process of identifying the data objects and the relationships between them.