Here's a User-Centric approach to Database Design based on Extreme Programming.
If you would like to contribute to this subject, please Email us
|
Extreme Programming is a rapid approach to systems development,based on incremental small steps with collaboration where the Users play a vital part in evolutionary development.
The approach described on this page is a User-Centric approach, and we have also established a
a Data-Centric Approach.
|
|
Here is a typical series of Steps :-
|
| 1 |
Define the User Scenarios |
This ensures User participation and commitment. |
| 2 |
Define the Steps in each Scenario
| Clarify the User Interaction. |
| 3 |
Derive the Data Model. |
Use a
Modelling Tool, such as Data Architect or ERWin to generate SQL. |
| 4 |
Relate Data Entities to each Step. |
Create Cross-reference matrix to check results. |
| 5 |
Identify Transactions for each Entity |
Confirm that each Entity has Transactions to load and read Data |
| 6 |
Prepare sample Data |
In collaboration with the Users. |
| 7 |
Prepare Test Scripts |
Agree sign-off with the Users. |
| 8 |
Define a Load Sequence |
Reference Data, basics such as Products, any existing Users or Customers,etc.. |
| 9 |
Run the Test Scripts |
Get User Sign-off to record progress. |
| |
