EmailAddress

Where to send a person email.

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

Attributes

Name	Type	Cardinality	Description
BusinessEntityID	int	1 - 1	Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
EmailAddressID	int	1 - 1	Primary key. ID of this email address.
EmailAddress	nvarchar	1 - 1	E-mail address for the person.
rowguid	uniqueidentifier	1 - 1	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	1 - 1	Date and time the record was last updated.

Mappings

Name	Source	Source attribute	Target	Target attribute
BusinessEntityID	EmailAddress	BusinessEntityID	EmailAddress	BusinessEntityID
EmailAddressID	EmailAddress	EmailAddressID	EmailAddress	EmailAddressID
EmailAddress	EmailAddress	EmailAddress	EmailAddress	EmailAddress
rowguid	EmailAddress	rowguid	EmailAddress	rowguid
ModifiedDate	EmailAddress	ModifiedDate	EmailAddress	ModifiedDate

Diagrams

Import Adventureworks Database

Diagram in repository

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.

Diagram in repository

Data Mapping

Data mapping is an example diagram of a data mapping in the IDEA implementation This implementation can be used in for example an ETL process but also for documenting the data flows and transformations in message transformation process or component.

Deze website is verplaatst naar Data-docent.nl

EmailAddress

Attributes

Mappings

Diagrams

Import Adventureworks Database

Physical example project

Data Mapping

Gekoppelde elementen

Logical datamodel example

Physical datamodel example

Links 2 Tags