Home Documents & Data Database Design IT Support Web Design Graphics & Maps About Contact

AMD Web

 

Database design: Design methods

Regardless of which design technology is used, the methods remain the same to achieve success.

1 Gather the user's requirements
  • What are the functions required
  • Speak with the operators
  • Listen to the operators !
  • Determine data input
  • Determine data output
  • What PC's will be used
  • Network considerations
  • Data restrictions & security
  • Any other factors
2 Analyse the requirements
  • Check data throughput
  • Check feasibility of primary functions
  • Check feasibility of secondary functions
  • What integration with other applications
  • Check if current PC's will perform ok
  • Check if current network will perform ok
3 Prepare the design specification
  • Specify the following
    • All functionality
    • How data will be entered
    • Type of outputs
    • Integration with other applications
    • General methods of operation
  • Prepare timeplan showing key dates
  • List items required from user
4 Design, implement and test
  • Design tables and/or links to other data
  • Design user interface, forms and reports etc
  • Add code to make the application work
  • Import test data
  • Use test software if needed
  • Test and debug the application
  • Customer test and feedback
  • Changes and documentation
  • Following customer tests make changes and fine tune
  • Retest
  • Document the design
  • Prepare User & Help documentation

5 Working Solution

We should have a working solution that does what the customer and operator want as we have combined the technical design with a strong emphasis of listening to the needs of those who are going to use the system and rely on its performance.