Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difficult select on non-normalized table
Message
De
07/03/2003 01:22:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00762391
Message ID:
00762591
Vues:
14
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
Fil
Voir

Click here to load this message in the networking platform