Better choice

[endri81]

In the process of building db I have similar properties and attributes for the entities.For example I have for entity father-age,nationality,ID number.
Same data I have for mother and son.Do i have to include father mother and son in the same table or create different tables for each?

 

[namliam]

Same table I would say, then use a field in the table to identify the "type" of person your dealing with.

 

[boblarson]

Personally, I would think it all depends on the amount of data you are trying to capture for each part. You mention Mother and Son as well as Father, so it almost sounds like you should have a junction table to add relevent info as a single record for each, because not everyone will have a son or daughter (not sure exactly what you are tracking here so more information might give a better clue as to the better way to do it).

 

[vbaInet]

As mentioned, it all depends on what you're actually doing. But in generally I would go for a Parents table, with name of each parent as individual records. Children too will have one record per child. There will be a relationship table where you can indicate who's the Father and/or Mother for that child, where Father/Child is one record. The FKs from the Parents table plus the Relationship Type will determine how they relate. A child can have more than two parents. Just my thoughts but we would definitely need more info.

 

[namliam]

VBA, dont children eventually (usually/hopefully) become parents themselfs??

I would use a "person" table and self join the table or make a related table.
Natural father/mother is only one, but how many now a days have 2 daddies, 2 momies..
Or 3 daddies and 1 mom?

 

[boblarson]

And that's why I said we need more information about what, or who, (or both) is being tracked and why. Some, or all, of those questions might be moot depending on the answers.

 

[vbaInet]

VBA, dont children eventually (usually/hopefully) become parents themselfs??

No they don't They remain children even at 75

It depends though, if you want to still have that record archived.

Let's see what extra info the OP provides.