|  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. |
Search Project
