Post reply

database design

  • July 27, 2009 at 7:45 am

    #134616

    Hi,

    I was given a job to design the database for my application.

    What is the procedure to design the database.

    I mean the tools, database design life cycle, any documents bla bla.

    thanks in advance

  • July 27, 2009 at 8:13 am

    #1030529

    a2zwd (7/27/2009)

    Hi,

    I was given a job to design the database for my application.

    What is the procedure to design the database.

    I mean the tools, database design life cycle, any documents bla bla.

    thanks in advance

    This URL outlines the steps in designing a database.


    Pradeep Singh

  • July 27, 2009 at 8:42 am

    #1030568

    This quite a large and open-ended question that i dont think can be answered correctly in a forum post, but one aspect that in database design that you should get to grips with is Normalisation.

    http://en.wikipedia.org/wiki/Database_normalization

  • July 27, 2009 at 8:45 am

    #1030573

    That link is a good start, but you really ought to pick up a book on database design. It's one of those things that if you don't know how to do it, then you can't do it, and probably shouldn't.

    But you have to learn. This is a place where you read about it and learn by example. Post sample designs for a small section of the model and get comments. It isn't easy, or simple, and there is no one way, but you will need guidance from others that have been through the process.

  • July 27, 2009 at 11:26 am

    #1030666

    Huge topic. You might want to start off defining your role. Take a look at Craig Mullins book called "Database Administration." It's system agnostic and very useful.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 27, 2009 at 11:35 am

    #1030668

    Hi,

    The URL is good and gives lot of information.

    Thanks

  • July 28, 2009 at 12:06 pm

    #1031223

    a2zwd (7/27/2009)

    Hi,

    I was given a job to design the database for my application.

    What is the procedure to design the database.

    I mean the tools, database design life cycle, any documents bla bla.

    thanks in advance

    If they want the design in the next month, you need to be honest with them and tell them you don't know how... this is not a trivial task to learn if you actually want to do it correctly.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply