This is done by the use of normal forms a normal form

This preview shows page 11 - 12 out of 12 pages.

modified at this stage, and any problems identified are fixed. This is done by the use of normal forms. A normal form is a specific set of rules that can be used to test a table structure to ensure that it is sound and free of problems. The database design process is summarized as follows: 1. Determine the purpose of the database 2. Gather and organize the information required such as product names and order information 3. Divide the information into tables or major entities such as products and orders 4. Turn the information or items into columns by deciding on what information to be stored in each table, with each item becoming a field 5. Specify primary keys for each table to uniquely identify each row. For example product ID or order ID 6. Set up table relationships by deciding how data on one table is related to the data in other tables or create new tables to clarify relationships. 7. Refine the design by analyzing the design for errors and making adjustments as needed. 8. Apply the normalization rules to ensure that the tables are structured correctly. The design method used need not be complicated and should not be difficult to understand. The process should be presented in a straightforward manner and each concept clearly explained. Conclusion Databases are shared resources that are used by many units within an organization and require significant investment to build. They however bring significant benefits to an organization. Computer analyst and programmers may also use them in ways not originally envisioned. Therefore database designs must meet current organizational requirements and must be adaptable to future requirements and expansion.
References Whitten, J., & Bentley, L. (2007). Systems analysis and design methods: 2008 custom edition(7th ed.). Dubuque, IA: McGraw-Hill. Hernandez, M.J. (2008). Database Design for mere mortals (2nf Edition). A hands-on guide to the relational database design. Addison-Wellesley. Database design Retrieved November 1st, 2011 from Davidson, L. (2007). Ten common database design mistakes. Retrieved November 1st, 2011 from - administration/ten-common-database-design-mistakes/

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture