Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Difficult select on non-normalized table
Message
 
À
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:
00762701
Vues:
12
Bob,

1st NF addresses multivalued fields like a phone number field in a person table where there may be many phone numbers for each person. When you start to create Phone1, phone2, phone3 etc then you are in violation of 1st NF. 2nd NF addresses the dependency of data fields on the Primary key and states that the values of all fields must be dependent on the whole primary key and not only part of it (this is an issue when the PK has more than one field in it). 3rd NF says the fields are dependent on ONLY the PK for their values and not on any other fields except for alternate Keys.

In view of these definitions then deciding to forgo a look up table for a certain value is not an issue of normalization but rather an issue of other relational design criteria.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform