Telephone number and type of a person.

Package Physical datamodel example
Author Bert Dingemans
Alias --
Stereotypes table


Name Type Cardinality Description
BusinessEntityID int 1 - 1Business entity identification number. Foreign key to Person.BusinessEntityID.
PhoneNumber nvarchar 1 - 1Telephone number identification number.
PhoneNumberTypeID int 1 - 1Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
ModifiedDate datetime 1 - 1Date and time the record was last updated.


NameSourceSource attributeTargetTarget attribute
BusinessEntityID PersonPhoneBusinessEntityIDPersonPhoneBusinessEntityID
PhoneNumber PersonPhonePhoneNumberPersonPhonePhoneNumber
PhoneNumberTypeID PersonPhonePhoneNumberTypeIDPersonPhonePhoneNumberTypeID
ModifiedDate PersonPhoneModifiedDatePersonPhoneModifiedDate


Import Adventureworks Database


Physical example project

Physical data model for the TFG Academy example. It shows a subset of the tables as they are included in the TFG Academy database. These three entities are used and expanded in the other two layers logically and conceptually.

Linked elements

Logical datamodel example

Physical datamodel example