Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to deal with n-tuples when n is variable?
Message
 
To
09/09/1999 22:11:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00263226
Message ID:
00263316
Views:
21
David,

Your situation is handled through a child table. The first normal form states that it is achieved by removing repeating or multivalued attributes to a child table.

In your scenario the Mother is one attribute and the others are children of the mother. You can see that every other field in teh table design is a child of the mother (they all have the same domain definition and therefore are the same attribute - a multivalued attribute).

To normalize this table you would create a table for the children that is related to the mother table and allow one record in the children table for each child of a mother.

Something like this:
            Mother                   Children
            MotherID   PK----\       ChildID   PK
            Mother Name       \----> MotherID  FK to Mother
                                     Child Name
Previous
Reply
Map
View

Click here to load this message in the networking platform