Address

Street address information for customers, employees, and vendors.

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

Attributes

Name Type Cardinality Description
AddressID int 1 - 1Primary key for Address records.
AddressLine1 nvarchar 1 - 1First street address line.
AddressLine2 nvarchar 1 - 1Second street address line.
City nvarchar 1 - 1Name of the city.
StateProvinceID int 1 - 1Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode nvarchar 1 - 1Postal code for the street address.
SpatialLocation geography 1 - 1Latitude and longitude of this address.
rowguid uniqueidentifier 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime 1 - 1Date and time the record was last updated.

Mappings

NameSourceSource attributeTargetTarget attribute
AddressID AddressAddressIDAddressAddressID
AddressLine1 AddressAddressLine1AddressAddressLine1
AddressLine2 AddressAddressLine2AddressAddressLine2
City AddressCityAddressCity
StateProvinceID AddressStateProvinceIDAddressStateProvinceID
PostalCode AddressPostalCodeAddressPostalCode
SpatialLocation AddressSpatialLocationAddressSpatialLocation
rowguid AddressrowguidAddressrowguid
ModifiedDate AddressModifiedDateAddressModifiedDate

Diagrams

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