Create MS SQL Database Schema and Stored Procedure Database Map

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.

Your Experience...

You need to show us how good you are in working with MS SQL, so give us examples and knock our socks off!

Kemahiran: Reka Bentuk Laman Web

Lihat lagi: mssql create schema, database design procedure mssql, database map sql, sql create schema, web design creating database schema examples, create database schema sql, sql database map, schema stored procedure, map sql database, create schema mssql, create schema stored procedure, create schema sql, sql schema stored procedure, map procedure schema, create stored procedure schema, www see com au, www search com au, www job search com au, www job com au, writing a procedure, where are programmers, website design procedures, website design procedure, sql database website design, search improvements

Tentang Majikan:
( 27 ulasan ) Brisbane, Australia

ID Projek: #291294