N
Nils Titley
I am working on a family tree data base. I have the following tables
Tables Defined
NAME ADDRESS SPOUSE
*NameID *AddressID *SpouseID
AddressID Address AddressID
ParentID City WifeHusband
First State First
Middle PostalCode Middle
Madien PhoneNum Last
Last BirthDate
BirthDate BirthPlace
BirthPlace DeathDate
DeathDate CellPhone
MarriageDate WorkPhone
SpouseID EmailPers
DivorceDate EmailBus
MarriageDate2
SpouseID2
DivorceDate2
CellPhone
WorkPhone
EmailPers
EmailBus
The * is the key. The ParentID contains the NameID for the parent of the
person.
Are these normalized tables and do I need a relationship table?
Thanks
Tables Defined
NAME ADDRESS SPOUSE
*NameID *AddressID *SpouseID
AddressID Address AddressID
ParentID City WifeHusband
First State First
Middle PostalCode Middle
Madien PhoneNum Last
Last BirthDate
BirthDate BirthPlace
BirthPlace DeathDate
DeathDate CellPhone
MarriageDate WorkPhone
SpouseID EmailPers
DivorceDate EmailBus
MarriageDate2
SpouseID2
DivorceDate2
CellPhone
WorkPhone
EmailPers
EmailBus
The * is the key. The ParentID contains the NameID for the parent of the
person.
Are these normalized tables and do I need a relationship table?
Thanks