Database Design is the procedure of creating an itemized information model of a database. This data model contains all the required intelligent and physical outline decisions and physical storage parameters expected to produce a configuration in an information definition language, which can then be used to create a database.A properly designed database provides youaccess to up and coming, precise data. At last, you are a great deal more inclined to wind up with a database that meets your needs and can easily accommodate change.
Databases frequently contain mission-basic data for organizations. With the appearance of ecommerce, more individuals are increasing more access to a larger number of databases than any other time in recent memory. Those two actualities alone make database design a genuine test.
A good database design is, therefore, one that:
- Partitions your data into subject-based tables to lessen excess information.
- Furnishes Access with the data it requires to join the data in the tables together as required.
- Helps, support and guarantee the exactness and trustworthiness of your data.
- Obliges your information preparing and reporting needs.
The Design Process:
The design process consists of the following steps:
- Determine the purpose.
- Find and organize the information of data.
- Divide the information into tables.
- Turn information items into columns.
- Specify primary keys.
- Set up the table relationships.
- Refine your design.
- Apply the normalization rules.