Time Software : Database Design

System Design

The design of the database and application is laid out in the Technical Specification. This is the technical employment of the Systems specification and is extremely detailed.

Database Design

Database design involves the layout of the database tables, their fields and their field's data types, and the relationship between the tables. The design reveals field constraints, table dependancies and the various business rules that may need to be placed in the database. Issues such as security, data integrity, back-up and recovery policies and procedures are also documented.

Application Design

Application design involves the technical details that go into the structure and coding of an application. These details are based on the information provided in the systems specification which is itself based on the business rules and requirements for the proposed system.

Application design also details the 'look and feel' of the application's Graphical User Interface (GUI) and how the user is to navigate through the application in order to perform its various functions. To this end the application's various forms along with their respective details and associations between them are documented fully.

We also often produce a prototype to facilitate the whole 'look and feel' effect to quickly attain user approval as part of the design phase. This ensures that the user will be comfortable with the functionality and entire flow of the application's processes right from the start.