December 17, 2004 at 7:20 am
Hi,
I am facing a typical problem, can any help me out in guiding in a right direction.
I am having an application developed which is usin the data base as sql server 200 as back end. Currently the tables don't have any referential integrity nor normalized. Typically all the tables have only one coloumn and directly maped to the front end for bussiness validation. Now my job is to see that all the tables are normalised by getting the entities into one place and redesign the DB since the application database has to be integrated with other applications.
I am planning to do the things in this direction.
1. I am planning to earnalize all the functionalities at the front end first so that i can have a feel of data flow and then start the DB design instead of designing the DB first and mapping to the front end.
2. Then implement the Referential integrity to the tables.
Could you please give some hints so that i can start doing the things in a right way.
Thanx in advance..
Dev.
December 17, 2004 at 12:33 pm
Many ways you could approach this but I think you are right in starting with the front end to determine how the tables relate. Once you have this I would denormalize all the data (at least structure wise) into as few tables as possible (prefferably 1) then from there follow the rules of normilization to break it appart into a proper normalized structure. Once there clean up any garbage data or unrelated data then map the remaing items into the new structure to load.
http://www.sqlservercentral.com/columnists/bkelley/normalization_printversion.asp
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply