I forgot to add Video (This has all the Primary key id from the tables below) Now does it work?
My question is how do I get the Primary keys into the video table? Do I just put them in and the database will know it should look in the other tables? How do I connect it? I read some books but it doesn't tell you how to do it. Thanks. At 04:03 PM 10/14/2002 +0200, Michael Zimmermann wrote: >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