Person / Personal Event

The person table contains only 2 attributes, namely a P Description of the person as free text, and the Birth Gender. Every other thing about a person can be described as an event in this person's life, and thus shall be contained in a separate table Personal Events.

A personal event shall be described by an Event Type coming from a data list of standard event types in a human life like birth, death, marriage, divorce, and so forth. Furthermore, an Event Date and an Event Description can be added for more information, especially for events of type Other event.

Another event that can happen is a change of gender. This one's easy, because if the birth gender is in the database, we can easily determine the gender the person changed to.

Finally, there are events that involve a change of name, notably the birth and the marriage. With three fields for first, last, and nick name changes, we can represent those changes within our data model. The advantage of this is that we save every name change in the same table.

Let's take a look at an example: Danielle Bunten Berry

The person table only contains male as birth gender and a description of this brillant mind.

The events table could look like this:

ID	1	2	3	4
Event Type	Birth	Marriage	Gender Change	Death
Event Date	19.02.1949		1992	03.07.1998
Event Description	Born in St Louis, Missouri.		After the failure of his third marriage, Dan Bunten informed his friends, coworkers, and family that he was embarking on the process of gender transformation. He adopted the name Danielle Bunten Berry (Berry being her mother’s maiden name). He underwent gender reassignment surgery in November 1992. For the next several years, Berry withdrew from the game industry to concentrate on the sex-change process and on the exploration of her new identify.	Died from lung cancer.
First Name Change	Daniel Paul		Danielle
Last name Change	Bunten		Bunten Berry
Nick Name Change			Dani