03Explorer
Technical User
I am in the process of building a database schema/model for data that is currently captured in numerous formats and styles (excel single record per xls, excel many records per xls, old access db's (poorly designed), etc) I am identifying the fields and constructing a normalized table structure. Is there any web site that helps with the project steps? A few feet out view of the project?
ie
step 1 - Gather all documents to be building a database from
step 2 - obtain a sample of data (i choose 5 rows) to begin normalizing
step 3 - draw a diagram with relationships to tables based on step 2 and fields used. Incorporate foreign key fields to link the tables (this done using Visio)
step 4 - ??
step 5 - ??
I am looking for some kind of guidance on a proper method to begin designing a database (independant of application). Something I can hand to a DBA and most of the project is ready for the action of building.
Is there a web site or book that can help?
Thanks
ie
step 1 - Gather all documents to be building a database from
step 2 - obtain a sample of data (i choose 5 rows) to begin normalizing
step 3 - draw a diagram with relationships to tables based on step 2 and fields used. Incorporate foreign key fields to link the tables (this done using Visio)
step 4 - ??
step 5 - ??
I am looking for some kind of guidance on a proper method to begin designing a database (independant of application). Something I can hand to a DBA and most of the project is ready for the action of building.
Is there a web site or book that can help?
Thanks