Fitness Database Design Help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
chesmur
Forum Newbie
Posts: 2
Joined: Tue Jul 26, 2005 5:59 pm

Fitness Database Design Help

Post by chesmur »

Hi Everyone,

I'm new to this board and php. None of the books I've picked up seem to help me retain the information so I decided to give myself a small project to complete. I wanted to setup a fitness database in order to track workouts, nutrition and anything else I can think of along the way.

Before I get to that point I need some guidance on how best to setup a database. I googled in hopes of finding a script or database already setup so I can see how they designed it but no luck so far. Any help pointing me in the right direction would be appreciated. Or what should I be looking for when designing the database.

Thanks
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Research database normalization. This is most likely the direction you're going to want to take.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

Happy reading... viewtopic.php?t=24396
chesmur
Forum Newbie
Posts: 2
Joined: Tue Jul 26, 2005 5:59 pm

Post by chesmur »

Thanks to both of you for your assistance, looks like I got some reading to do. Hopefully I can get some feedback on a draft of the database once I get it together.


Thanks
Post Reply