Re: A Normalization Question

Suppose we have:

T_Person
ID Name Age
1 john 30

T_SoccerMember
ID Name Age
3 john 30

T_ChurchMember
ID Name Age
5 john 30

Following the first fold...
> 1. It is a process of eliminating redundant data. Not of "replacing
> things with references," but of _eliminating redundant data_.
...one might get:

T_Persons
ID Name Age
1 john 30

T_SoccerMember
ID Name Age

             (Redundant john elmininated)

T_ChurchMembers
ID Name Age

             (Redundant john elmininated)

while following mine...
> > replacing duplicate (redundant) things with a reference to the
> > original thing being represented.
...one gets:

T_Persons
ID Name Age
1 john 30

T_SoccerMember
ID PersonID
3 ->1 (redundant thing replaced with ref to original)

T_ChurchMembers
ID PersonID
3 ->1 (redundant thing replaced with ref to original) Received on Tue Jul 13 2004 - 20:57:13 CEST