Need Help with mysql admin for Mac

[Chris Goodiel]

Hello all.

I am new to cold fusion and databases all together. Infact I am doing an
online tutorial to get me started, my problem is the tutorial really just
scratches the surface for the mac side and in some cases sorta explains how to
do but no visual help and I am very visual.

I am searching for software that is really idiot proof to start my knowledge
with then make the transition when I learn more and more to hard coding. The
tutorial suggests Navicat for Mysql admin and it is nice but he is setting up
basic databases in Access which looks really easy and I am trying to follow
along with navicat but I am just not getting it specifically when it comes to
setting up relationships between tables. Can I use a software like FileMaker
Pro and just convert to mysql or is their other software that makes it a little
more easy to understand how to set up relationships like access does.

I am totally new to this stuff and I am looking for the easiest product to
use. Thanks again for your help and time.

Chris

[paross1]

Before you write your first query, you should become familiar with the concepts
of data modeling. Then find a good source (book, books-on-line, etc. ) for the
particular "flavor" of SQL used by your database of choice, then start writing
your queries. Data model first (entities, relationships, attributes), then SQL.

Couple of fairly good online tutorials for data modeling. <a target=_blank
class=ftalternatingbarlinklarge
href="http://www.utexas.edu/its/windows/database/datamodeling/index.html">Introd
uction to Data Modeling</a> and <a target=_blank
class=ftalternatingbarlinklarge
href="http://www.datamodel.org/DataModelReference.html">Data Model Reference</a>

Phil