If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Setting up a database for many values

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-23-10, 23:19
qkrcogml qkrcogml is offline
Registered User
 
Join Date: Aug 2010
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 08-25-10, 23:31
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
look up database normalization before you get started
Reply With Quote
  #3 (permalink)  
Old 08-30-10, 11:20
veggiecn veggiecn is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 08-30-10, 12:24
guelphdad guelphdad is offline
Registered User
 
Join Date: Mar 2004
Posts: 440
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.
Reply With Quote
  #5 (permalink)  
Old 09-02-10, 04:04
msjs msjs is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On