Extreme Database Design

Here's a User-Centrica approach to Database Design based on Extreme Programming (this takes you off our Site). If you would like to contribute to this subject, please Email us
Extreme Programming is a (very) rapid approach to systems development, based on small steps with collaboration where the Users play a vital part in directing evolutionary development. The approach described on this page is a User-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.