Re: Primary and Foreign Keys
"Thomas B. Passin" wrote: > Another situation would arise if a table is a "join" table (Mike Gorman's > term is more charming, though: "intertwinkle" table). That generally means > a many-to-many relationship. The primary key for a join table is usually > compound, which leaves ID/IDRef out unless you use two of them in each > element. I like intertwinkle. Many-to-many relationships cause a special problem with nesting. When using a canonical object-relational mapping, they result in an extra element (representing the join row) between the elements corresponding to the joined rows. This element usually needs to be removed by XSLT or by smarts in the data transfer software. -- Ron
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format