Re: how do you define a relationship?

[Richard Clarke]

Randy,

> I think I've firmed my "theoritical" understanding of relationships enough
> to be dangerous.  Now for the logical part....how do you actually define a
> relationship in mysql?  For instance...
>

http://www.mysql.com/doc/en/SEC447.html

>  table movies
>  columns (movie id(pk) , movie title , year filmed)
>
>  table directors
>  columns (director id(pk), movie id(fk), total movies)
>

Using these definitions the total_movies column seems redundant to me.

    select count(*) from movies,directors where
movies.movie_id=directors.movie_id

would yeald the total movies under said director_id.

Ric