Person Data Model

This model describes a person. The model supports the storage of historical data. These are the entities with attributes FromDate and ToDate. Please note that the address entity is not complete.

Person Data Model, ERD in idef1x and crows foot notation

Click on the image to enlarge

Notation: Crow's Foot
IDEF1X Notation | Crow's Foot Notation

Entities in this data model:
Address ,Citizen ,Country ,Gender ,Identification ,Language ,LanguageRelationship ,MaritalStatus ,MaritalStatusType ,Passport ,Person ,PersonLanguage ,PersonRelationship ,RelationshipRole ,RelationshipRoleType ,Salutation ,SalutationType ,WeightAndLength

Download This Data Model

The download is a zipfile containing .dez files (the data model), images of the data model, and a license agreement. The .dez file contains a data model with MS SQL Server 2005 as target database. You can easily switch the target database to another database (MS Access, MySQL, Oracle, PostgreSQL,...) in DeZign for Databases.

You must use DeZign for Databases to open/view/edit the data model(s) (.dez file).

Please read the license before downloading this data model.

Recommended Tools

All data models on this website are made with DeZign for Databases. You can open/edit and view the data models with the trial (and full) version of this software. Download this data modeling tool here.

Popular Entities