Extreme Database Design

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.