Interactory Publicaties
Home
Onderwerpen
IDEA Addon voor Sparx
Web Publicatie Platform voor Sparx
Architectuur Repository
Sparx Enterprise Architect
Architectuur
Webvideo's
Whitepapers
Blog
Alle onderwerpen
Zoeken in repository
Trefwoorden zoeken in repository
ArchiMate zoeken in repository
Geavanceerd zoeken in repository
Packages in repository
Diagrammen in repository
Repository elementen
Extra
Repository verkenner
Matrix van Package
Matrix van Diagram
Begrippenlijst
Grafieken
Release notes
Participant
Inschrijven voor de webmailing
Login
Contact
Deze website is verplaatst naar
Data-docent.nl
BusinessEntityAddress
Cross-reference table mapping customers, vendors, and employees to their addresses.
Package
Physical datamodel example
Author
Bert Dingemans
Alias
--
Stereotypes
table
Attributes
Name
Type
Cardinality
Description
BusinessEntityID
int
1 - 1
Primary key. Foreign key to BusinessEntity.BusinessEntityID.
AddressID
int
1 - 1
Primary key. Foreign key to Address.AddressID.
AddressTypeID
int
1 - 1
Primary key. Foreign key to AddressType.AddressTypeID.
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
BusinessEntityAddress
BusinessEntityID
BusinessEntityAddress
BusinessEntityID
AddressID
BusinessEntityAddress
AddressID
BusinessEntityAddress
AddressID
AddressTypeID
BusinessEntityAddress
AddressTypeID
BusinessEntityAddress
AddressTypeID
rowguid
BusinessEntityAddress
rowguid
BusinessEntityAddress
rowguid
ModifiedDate
BusinessEntityAddress
ModifiedDate
BusinessEntityAddress
ModifiedDate
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.
Gekoppelde elementen
Logical datamodel example
BusinessEntityAddress
BusinessEntityAddress trace
Physical datamodel example
Address FK
AddressType FK
BusinessEntity FK
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