Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Jim, I have comment/question about Peters table being normalized. Believe me I'm not an expert but I've read alot about data normalization. In his situation there is alot of redundant data and from the way I understand normalizing data this is first normal form at best. From the way I understand normalization his situation could be broken into 3 separate tables, One for the person, One for the type of media, and it sound like one for the Title. That way if the name of a title changed you wouldn't have to each media type to change the title or go to several records to change a value of the title. That would put his situation in atleast second normal form and maybe consider by some as third normal form. But then again I could be wrong?? Interested to hear your thoughts.
respectfully
BW
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement