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
In Figure 5–30, another index is applied to the role played by Country in the associ-
ation Person was born in Country. If you often want to inquire about where a person was
born, and you want the name of the country, not just the country-code, when you make
such a query, then this entails a frequent conceptual join operation between the two
roles played by Country. These roles map to separate tables, one role mapping to a for-
eign key and the other to its referenced primary key. At the relational level, this means
we have a need to efficiently join the tables by matching the foreign and primary key
values. In this case, you can add an index on the ...
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