Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    5

    Unanswered: Design of Database

    Evening all,

    I'm trying to create a client management database but I'm struggling to think of the correct design of the database for example:

    My client profile would consist of

    1, Client Name
    2, Client Address
    3, Client Contacts
    4, Client Payment Details
    5, Information on work/tasks undertaken to date.

    Would I need a table for each section or can it all go on one table?

    SG

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    name and address can likely go in the main cllients table, as chances are, the client has only one of each

    the others would require one-to-many relationships to other tables
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2009
    Posts
    5
    Quote Originally Posted by r937 View Post
    name and address can likely go in the main cllients table, as chances are, the client has only one of each

    the others would require one-to-many relationships to other tables
    Thanks that clears things up.

    SG

Posting Permissions

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