Deze website is verplaatst naar Data-docent.nl



PersonPhone

Telephone number and type of a person.

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

Attributes

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.

Mappings

NameSourceSource attributeTargetTarget attribute
BusinessEntityID PersonPhoneBusinessEntityIDPersonPhoneBusinessEntityID
PhoneNumber PersonPhonePhoneNumberPersonPhonePhoneNumber
PhoneNumberTypeID PersonPhonePhoneNumberTypeIDPersonPhonePhoneNumberTypeID
ModifiedDate PersonPhoneModifiedDatePersonPhoneModifiedDate

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

Gekoppelde elementen

Logical datamodel example

Physical datamodel example

Links 2 Tags

Archimate Architect Architectuur Architectuur document Architectuur repository Big data Bouwblokken en patronen Criteria Data Data architectuur Data governance Data kwaliteit Data management Data modelleren Enterprise architectuur Idea Image library Master data Matrix Mdg Meta data Metafoor Modelleren Open source Principes Register Repository Simulator Software Sparx enterprise architect Sql Stakeholders Time aware modelleren Tips en tricks Training Webvideo Wpp