The MS SQL database used by the website [url removed, login to view] has become excessively large and complicated through multiple programmers duplicating work, and because of the absence of control of changes.
As future works are carried out on the web site, this complicated database becomes more and more complicated.
There is no database schema or stored procedure mapping to help and it is the intention of this Project to produce them.
That will be your main job.
In addition to duplicated procedures and overly complicated tables, fields are marked as foreign keys however they are not intelligent keys.
This project is in 3 parts:
Part 1 is to document the tables and stored procedures, creating a database schema and a stored procedure database map.
Part 2 is to recommend improvements and streamlining of the database and query system.
Part 3 is to carry out those improvements. (We might make this a new Project if it is big enough).
Before moving from part to part we must approve it first (and we will do that in writing).
It is expected that you will use advanced search and mapping tools to make the work fast.
Once the database schema and query mapping is completed, it is expected that it will become apparent where duplications can be eliminated and simplification can occur.
Once created, the database schema and stored procedure database relationship map will also be used on future projects to plan the work.
For more information on this project, please see the attached file.
You need to show us how good you are in working with MS SQL, so give us examples and knock our socks off!