Here's a User-Centric approach to Database Design based on Extreme Programming
If you would like to contribute to this subject, please
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 :-
Define the User Scenarios
This ensures User participation and commitment.
Define the Steps in each Scenario
Clarify the User Interaction.
Derive the Data Model.
, such as Data Architect or ERWin to generate SQL.
Relate Data Entities to each Step.
Create Cross-reference matrix to check results.
Identify Transactions for each Entity
Confirm that each Entity has Transactions to load and read Data
Prepare sample Data
In collaboration with the Users.
Prepare Test Scripts
Agree sign-off with the Users.
Define a Load Sequence
Reference Data, basics such as Products, any existing Users or Customers,etc..
Run the Test Scripts
Get User Sign-off to record progress.
Ask a Question
IceBreaker WebDesigns 2002