Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: Setting up a database for many values

    I'm in the process of setting up a database for a simple medication tracker. A person would register and log in to enter in their daily medication and dosage. Since these values are unique to one specific user, I don't know how I would approach this at all. What would be the best way to store this type of information? Any help would be appreciated.

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    look up database normalization before you get started

  3. #3
    Join Date
    Aug 2010
    Posts
    1
    I have also always want to know the answer to this question. Please gurus, I am looking forward to your expert information. Thanks.

  4. #4
    Join Date
    Mar 2004
    Posts
    480
    Quote Originally Posted by veggiecn View Post
    I have also always want to know the answer to this question. Please gurus, I am looking forward to your expert information. Thanks.
    the answer is the post directly above yours.

  5. #5
    Join Date
    Sep 2010
    Posts
    3
    Start at wikipedia and search database normalization.
    Look at Tony Marston's Home Page for one way to do it.
    This is a huge subject and hard to get your head around until it apparently "clicks".
    Not convinced I get it yet.

    Even with the info you've given, we could not answer you.
    Ask yourself lots of questions like
    "Does one client have more than one medication?"
    "Does one client use one medication more than once per day?"
    "Does one client use more than one dose medication at any one time?"
    "Is one medication used by more than one client?"
    What other info do you need to keep?

    I do wonder if this isn't someone's "homework"
    HTH
    Max

Posting Permissions

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