a) Design a genealogy database with one entity set: people. The information to record about persons includes their name, social security number. The people entity set has three different roles: mother, father and children.

b) Modify your diagram to include the following special types of people: Females, Males, and people who are parents. Use proper relationships to connect appropriate subclasses of people .