Hi John, your design is normalized, but incomplete and unconnected.
Where do you put the information which actor was playing in what title, which title was done in what studio etc. ? Normalization is a representation technique to avoid storing *redundant* information. But first this information has to be there. So first make the design complete (in an unnormalized way, which fits the problem), then in a *second* step normalize it. Greetings Michael At Montag, 14. Oktober 2002 14:49 John Chang wrote: > I've read a bunch about normalization in MySQL and still can't do it very > well. What I want to normalize is videos (Title, Studios, Actors, Genre, > &bitrate). > > These are the tables and fields I think it needs. Is this > normalized? Thank you. > Table (Fields) > Title (VideoTitle, details, id) > Studio (Name, id) > Actors (F_Name, L_Name, id) > Genre (Name, id) > Bitrate (rate, id) -- Michael Zimmermann (http://vegaa.de) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php