I've just been given a project of designing a SQL database. The data for the database is contained in text files. I was wondering if someone could please tell me where to start.
Printable View
I've just been given a project of designing a SQL database. The data for the database is contained in text files. I was wondering if someone could please tell me where to start.
The first step is to design your tables to accurately represent your data. Do you understand normalisation and the concepts of relations?
Before you have designed your structure don't even THINK about coding.
Cheers,
P.
Why not?Quote:
Originally posted by paulw
Before you have designed your structure don't even THINK about coding.
Because until you have your data structyres correctly specified, any code you write will be crap.
For instance, If your data structures indicate that you need a Customer table, an Orders table and an Orders Details table, there is not much point designing a whizzy import routine that captures the data to one large table... Much better to design the tables first and then write the data import routines to import directly to three tables.
OK?
Paul.