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
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 - 1
Primary key for Address records.
AddressLine1
nvarchar
1 - 1
First street address line.
AddressLine2
nvarchar
1 - 1
Second street address line.
City
nvarchar
1 - 1
Name of the city.
StateProvinceID
int
1 - 1
Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode
nvarchar
1 - 1
Postal code for the street address.
SpatialLocation
geography
1 - 1
Latitude and longitude of this address.
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
AddressID
Address
AddressID
Address
AddressID
AddressLine1
Address
AddressLine1
Address
AddressLine1
AddressLine2
Address
AddressLine2
Address
AddressLine2
City
Address
City
Address
City
StateProvinceID
Address
StateProvinceID
Address
StateProvinceID
PostalCode
Address
PostalCode
Address
PostalCode
SpatialLocation
Address
SpatialLocation
Address
SpatialLocation
rowguid
Address
rowguid
Address
rowguid
ModifiedDate
Address
ModifiedDate
Address
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
Address
Address trace
Physical datamodel example
BusinessEntityAddress FK
StateProvince 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