Goal
The overall web site goal is determined by the client’s needs and requirements. The goal is a simplified version of the Business Needs and Requirements document, which outlines what the client wants to achieve through the web site.
Input and Output Data
The information that needs to be handled is categorized and grouped into input data and output data. The input data is information that is entered into the web site, and the output data is reports about that data.
Data Tables
Database tables are created to manage the data. The tables are then refined to avoid redundant data, to accommodate data that can be scaled in volume up or down over time, for web site security, and for the most efficient interaction with the web site interface and coding. The tables are organized in such way using standard documents called Entity-Relationship Diagrams (ERD), and using database keys that interact between tables and can be accessed from database queries to return results organized from different data tables, according to what is required by the user. This is called a Relational Database. For example: sales by country, jobs in production, etc.
How the System Handles Data
Two standard documents are then put together to handle the User Experience and the Data Flow:
- Use Case Scenarios – this is a series of simple forms listing the actions taken by users of the system to efficiently and accurately enter data into the new system. This is done to streamline and simplify the process so users can quickly and easily use the new system. It is obtained from actual users or their representatives, and produces the process that is the most effective for users of the system and the flow of data from obtaining the data to be input to accessing reports from the system. This is how the system handles the data from the user.
- A Data Flow Diagram (DFD) is then designed depicting the user interfaces (screens) that will access the data, the data stores and the flow of the data. It includes descriptions for the screens, such as “admin logs in” or “manager enters data”. This can include several levels to expand upon the data stores or reports. This is how the system handles the data itself.
Storyboard
Once these documents are prepared, a web site Storyboard is designed showing the levels of the User Interfaces connected by menus.
Wireframes
From the Storyboard, each User Interface is designed as a Wireframe drawing, using placeholders for content, buttons, data displays and the like. ASP.Net provides the ability to design Master Pages, which act as a template for the User Interfaces, so the web site is consistent in its look, feel and interaction with data throughout the whole project.
Database Set-Up with ASP.Net Schema
The database itself is set up on the hosting server. ASP.Net Shema is applied to the database. This provides complete encrypted security for user roles and authentication and authorization (log in, etc.), and is a standardized Microsoft best practice. The data tables and SQL stored procedures are then added to the database.
User Interfaces Prototype
The User Interfaces are then built, using the wireframe drawings as a guide, and placeholders are used for the prototype.
Business Logic and Functional Prototype
The Business Logic programming (code-behind) is added to the pages for interactivity, and a functional prototype of the web site is then sent to the client for approval.
Testing and Debugging
After the client approves the web site, actual content is added and test data is entered into the site for testing and debugging the final system. When the testing and debugging is complete, the test data is removed and the finished web site is delivered to the client with a document describing use of the system.