|
Software
Draw the structure of the new database on Paper Based on the new business requirements, you need to draw the structure of the new database on paper. We often use MS Access at this stage because it has a got a “Documenter” tool which generates a real professional output in a relatively short time.
Now you need to analyze the existing code to see how they are using the current database structure and how this usage will change based on the revised structure. For instance, if you are trying to split a long table into two separate tables, then all previous “Select *” queries on that table will be useful. Thus, all the existing code will have to be rewritten.
Business - List of business/finance/loan/mortgage resources
more 1 2 3 4 5
Computers - List of computer hardware/software/peripheral resources
more 1 2 3 4 5
Internet - List of webhosting/webdesign/internet marketing resources
more 1 2 3 4 5
Software - List of software resources
more 1 2 3 4 5
Web Design - List of web design/development resources
more 1 2 3 4 5
Web Hosting - List of web hosting resources
more 1 2 3 4 5
Web Promotion - List of search engine optimization/internet marketing resources
more 1 2 3 4 5
Web Resources - List of other web resources
more 1 2 3 4 5
Recreation - List of travel/hotel/cruise resources
more 1 2 3 4 5
Casino - List of online gambling/poker/blackjack/roulette resources
more 1 2 3 4 5
Health - List of online pharmacy/hospital/health resources
more 1 2 3 4 5
Shopping - List of online shopping/gift resources
more 1 2 3 4 5
Miscellaneous - List of all other resources not stated above
more 1 2 3 4 5
You need to create a migration plan. Leaving the tech stuff aside, this basically means how you are going to transfer the data from the old data into the new database. For this you will have a write a script of some kind. This stage is very critical because you might have to adjust your new database. For instance: If in the old database you have customers table which had a name column. Now, if the revised database has firstname, middlename and lastname column then I can bet your database redesign dreams will end here as you can’t migrate the data between the two versions unless your plan includes manual typing.
Now you get to design the new database structure as it should be implemented unless you have done in the very first step itself.
|