Source Data Examination

The first step in good datagbase design is understanding the current form of the data. Together we examin the source data to determine it existing characteristics and how those characteristics can affect the database design.

Why Do It?

Sometimes database projects involve converting existing data systems into a relational database form. These usually have the necessary data fields already determined making the conversion relatively straight forward.

Other projects involve using sources that contain more data elements than are desired in the new relational system. Sometimes sources that are missing data elements that would make the new system more useful and more robust.

Often the data examination phase reveals additional data that is either required or would be "nice to have" and that can be obtained easily at this stage and included in the project. Careful examination ensures that not only are the desired data elements identified and used but that provisions are made for any additional elements that come to light, savng time, effort and expense later.