||How do I design a Database ?
Here is a series of Steps in designing a Database :-
Step 1. Establish the Scope of the Database.
Step 2. Identify the ‘Things of Interest’
Step 3. Define the Business Rules that determine how these ‘Things of Interest’ are related.
Step 4. Choose the Data Modelling Tool.
Step 5. Produce first draft Data Model and review with the Users.
Step 6. Ask the Users to provide sample data.
Step 7. Load data into Database and confirm the Design.
© DatabaseAnswers.org 2010