Database design is the process of forming a database that is going to tailor the needs of a user. The process of doing database design generally entails a number of steps which calls for a database designer. And so, data base designers are expected to be skilled in a task analysis so as to generate efficient database. Getting it right will boost the bottom line of a business in a range of ways. It will:
Guarantee data accuracy and reliability.
Optimize data retrieval for graphs and reports.
Support corporate goals & developing business initiatives.
Reduce the maintenance and upkeep of the database scheme.
Do away with the haphazard approaches so as to maintain data.
Database design refers to the -- tables, columns, relationships, keys and indexes of which a database is formed of. When the database is designed, the data which seems to be relevant are stocked up. Layout of the table, implementation of a primary keys and unique key constraints allows the data to be consistent.
The process of database design includes:
Purpose of a database.
Arranging the required information systematically.
Dividing the information in a tables
Turning the information items into a columns
Specifying the primary keys
Building up of the table relationships
Refining of the design
Applying of the normalization rules
A good database design is one which:
Gives access to the information.
Provides you with the up-to-date & accurate information.
Makes the queries simple which results in a fast execution.
Accommodates your data processing and reporting needs.
Helps, support and ensure the accuracy & integrity of your information.
Partition your information into the subject-based tables so as to decrease the strength of an outmoded data.
Source: http://www.itmatchonline.com/article/Database_Design.php
ITMatchOnline, an Outsourcing hub where provider and buyer exchange their needs. Looking for database design services for your website? Visit Itmatchonline.com
