This entity holds the personal records of the employees. This personal data of the employees would be like their Last Name, Given Name, Date of Birth etc. The data in this entity is strictly based on the personal record, not employment record. It is uniquely identified by a number. This number is known as the identity card number.

There is a system defined number which cannot be seen by the user. To the user, they only know the personal number, which is the identity card number of the person. This is the key to the record for a particular person. In some cases where the person changes his/her identity card number, the user can easily change its number, however, he/she will still be connected to other related records pertaining to the old identity number.

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

Shows the identity number of the person.

Holds the country of birth of the employee.
Example: Singapore / Malaysia / Indonesia

Holds the date of birth for the employee.
It is usually in the format: DD-MM-YYYY.

This Field stores the Person's name.

An assumed name which can be used to cover up one's real identity.

Shows the gender of the family member.
Example: Male = "1". Female = "0".

Holds the nationality of the person.
Example: Singaporean / Malaysian / Indonesian

This attribute would record the Height of the user. No validation is needed for this field.

This attribute would record the weight of the person. Like the height attribute, no validation is required.

This attribute is only used in Malaysia as they have two kinds of identity cards for a person. The reason for keeping two identity cards is because the Old identity card number is used for banking purposes while the new number is used for government purposes. As for the Key to this entity, it would be the new identity number.

Stores the employee's passport number.

Differentiates each employee. It would distinctively identify each employee in the company.

Shows the check digit for the identity number, i.e. the alphabet at the end of the identity number. This is to prevent anyone from entering Singapore with an illegal identity number.

Shows the first name of the employee.

Shows the middle name of the employee. Can also be the second name.

Shows the last name of the employee. It is also the surname.

Indicates the initials of the employee.

Shows the country in which the passport was issued.

Shows who issued the identity to the employee.