Results 1 to 4 of 4

Thread: Where to start???

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224

    Question

    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.

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    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.
    Not nearly so tired now...

    Haven't been around much so be gentle...

  3. #3
    Guest
    Originally posted by paulw
    Before you have designed your structure don't even THINK about coding.
    Why not?

  4. #4
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    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.
    Not nearly so tired now...

    Haven't been around much so be gentle...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width