Skip to Main Content
Database Modeling with Microsoft® Visio for Enterprise Architects
book

Database Modeling with Microsoft® Visio for Enterprise Architects

by Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
September 2003
Intermediate to advanced content levelIntermediate to advanced
425 pages
16h 30m
English
Morgan Kaufmann
Content preview from Database Modeling with Microsoft® Visio for Enterprise Architects
The graphical representation of the new fact “Patient has PhoneNr” will be
automatically placed on the diagram.
16.6 Three-Way Synchronization
From the previous two sections, it may appear that the Update Wizard is designed
solely to propagate model changes to the physical schema, while the Refresh Wizard is
designed to propagate changes from the physical schema back to the logical model.
16.6 Three-Way Synchronization 343
Figure 16–15 About to update the model.
Patient
Country
Patient nr smallintPK
PK
PK, FK1
PK
Patient nr
Drug name
smallint
varchar(5)
Country code char(2)
U1 CountryName varchar(44)
Country_code
FamilyName
PhoneNr
char(2)
varchar(35)
varchar(14)
FK1 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Data Modeling: A User-Driven Approach

Mastering Data Modeling: A User-Driven Approach

John Carlis
Architecting Data-Intensive SaaS Applications

Architecting Data-Intensive SaaS Applications

William Waddington, Kevin McGinley, Pui Kei Johnston Chu, Gjorgji Georgievski, Dinesh Kulkarni
Limitless Analytics with Azure Synapse

Limitless Analytics with Azure Synapse

Saranya Ravichander, Prashant Kumar Mishra

Publisher Resources

ISBN: 9781558609198